First of all, many thanks for mysqltuner.pl. It is a great little app!
Second, I see that table_cache is almost always recommended very high in the variables to adjust (depending on my number of tables or temporary tables, of course). However, benchmarking apparently shows that it is not always good to increase it. See http://www.mysqlperformanceblog.com/2009/11/16/table_cache-negative-scalability/
I think it would be good to mention that in the General recommendations, or to do some kind of check to make sure the right value is suggested.
The text was updated successfully, but these errors were encountered:
First of all, many thanks for mysqltuner.pl. It is a great little app!
Second, I see that table_cache is almost always recommended very high in the variables to adjust (depending on my number of tables or temporary tables, of course). However, benchmarking apparently shows that it is not always good to increase it. See http://www.mysqlperformanceblog.com/2009/11/16/table_cache-negative-scalability/
I think it would be good to mention that in the General recommendations, or to do some kind of check to make sure the right value is suggested.
The text was updated successfully, but these errors were encountered: