mysql opened_tables settings - help?
I'm getting lost connections to mysql errors (happened during peak and offpeak) and I'm not sure if it's due to table_cache settings.
My table_cache is 1024 but opened_table is 1557 and open tables is 940 due peak hours.
I read conflicting information about whether 1024 for table_cache is too high or I should even up it more.
The advice given in mysql documentation is:
Make sure that your operating system can handle the number of open file descriptors implied by the table_cache setting. If table_cache is set too high, MySQL may run out of file descriptors and refuse connections, fail to perform queries, and be very unreliable.
You can check if your table cache is too small by checking the mysqld variable Opened_tables. If this is quite big, even if you haven't done a lot of FLUSH TABLES, you should increase your table cache.
Suppose all your slots are busy and a new user needs to come in and access a table. He'll have to wait until something opens up. This back log will start to bring your system down.
Suppose all your slots are busy and a new user needs to come in and access a table. He'll have to wait until something opens up. This back log will start to bring your system down.
p.s. my mysql server is dual xeon 2.8 has 2GB ram + scsci hdd
