table_cache not read
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]
Re: table_cache not read
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]
Re: table_cache not read
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]
Re: table_cache not read
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]
Re: table_cache not read
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]
