its my first time here, so hi to all. I am reader of mysqlperformance blog and I have some subjects about MySQL to discuss, to find feedback with other people.
I will explain a real case. This post is to know if most of the people that use MySQL usually, uses tools like MySQL Tunner or Tunning primer.sh
MySQL Tunner, by my experience, give to you a very restrictive recommendations. I think it try to limit the use of global RAM to 80% or system and when you have a configuration that exceed this rule, it give you a warning.
Total buffers: 666.0M global + 168.2M per thread (325 max threads)
I had a BD with MySQL on Centos5, MySQL 5.0.45 with setup based on MySQL Tunner recommendations. This DB had a 14 GB of dates and use MyISAM. But lately, performance getting worse day by day, and waiting % was very high. In this situation, the consumption of RAM by MySQL was very low, because my.cnf was setup, as I say before, with recommendations of Tunner.
So we changed yesterday my.cnf to try to improve performance. And was a success. Almost, because some tables of DB are now corrupted. So we gain performance but lost stability.
With a more restrictive setup, I noticed that the tables was ok, no corrupted.
So this is my dilemma. Any idea or advice will be good. Thanks!