From: Reindl Harald Date: June 4 2012 12:42pm Subject: Re: table cache value error in my.cnf file List-Archive: http://lists.mysql.com/mysql/227583 Message-Id: <4FCCAD4A.3040804@thelounge.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigA8CEA29D0EAEC8CEC8B40390" --------------enigA8CEA29D0EAEC8CEC8B40390 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Am 04.06.2012 14:39, schrieb Joey L: > i am getting this wierd error in the mysql log: > 120604 8:31:32 [Warning] option 'table_cache': unsigned value > 536870912 adjusted to 524288 >=20 > I have 28G of ram in my server, can anyone tell me what this value > should be set to ? > what is the syntax - i have tried different syntax -- get the same erro= r table count * expected connections --------------enigA8CEA29D0EAEC8CEC8B40390 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk/MrUoACgkQhmBjz394AnnhOgCePXcAjCTUw31web2BL4bWRvFI /o0An2lEusBHNWjN2cE8BXH0r0Dqwgv4 =xyLe -----END PGP SIGNATURE----- --------------enigA8CEA29D0EAEC8CEC8B40390--