All,
I am currently using a win/mysql solution. I am running into a problem
where the table cache is not registering from the ini when the server
starts. Below are my versions...
Win: Windows 2003 Enterprise
MySQL: 5.0.18
In my.ini the table_cache is set to 3020 (I am not sure why as I did not
originally configure.) But when I query the variable value (show
variables like 'table_cache';) it shows 264. If I correct the value
(set global table_cache=120;) the value will stays until the service is
restarted.
This is happening on 2 Win2K3 Ent servers. Although on the other server
the table_cache in the ini is 6020 but displays 64. I also understand
64 is the default.
My question is two-fold. 1. Why would this happen? and 2. How would I
correct this so that I do not have to reset the table_cache every time
the service is restarted?
Thank you all for your feedback!
Robert Coggins
--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32 [at] m.gmane.org
