Dan, Thanks for the reply...
I wondered if this might be the case myself. However, I made a change the the variable query_cache_size in the same ini and it registered correctly after the service restart. Or, are you saying MySQL might be reading from multiple ini files? Well, either way in the mean time I am going to search for additional ini files that may contain the offending variable value. Thanks! Robert Coggins Dan Buettner wrote: > Robert, I recall a similar issue on Windows a couple of months ago. > The problem there was the presence of multiple ini files scattered > about. Check your system for multiple ini files and consolidate & > remove the extras, perhaps. > > HTH, > Dan > > On 10/3/06, Robert Coggins <[EMAIL PROTECTED]> wrote: >> All, >> >> I asked this in the win32 list but not getting much of a response. >> Thought I would ask here since there seems to be more traffic. >> >> 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 General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/[EMAIL PROTECTED] >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
