table_cache not registering

Robert Coggins <[email protected]> Tue, 03 Oct 2006 10:15:50 -0400
Newsgroups gmane.comp.db.mysql.windows
Message-ID <[email protected]>
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/[email protected]