Well, I scoured the HDDs and I was unable to find additional my.ini files. Any other thoughts!
Thanks again for your help! Robert Coggins wrote: > 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]
