I am preparing a Linux server and I just ran mysqltuner. Among the results, I get the following: [--] Total buffers: 144.0M global + 9.6M per thread (151 max threads) [OK] Maximum possible memory ...
On a busy mysql server MySQLTuner 1.2.0 always recommends to add query_cache_size no matter how I increase the value (I tried up to 512MB). On the other hand it warns that : Increasing the ...
My server keeps crashing from OOM errors cause by MySQL. I am convinced there is a query on this site that is wrong, too long and causes this issue. My server and MySQL logs show very little strain ...
I have a VPS running Zen Cart. The server is built on CentOS 5.7 64Bit, and has 2 Virtual CPUs and 2GB RAM. I try to use the mysqltuner script to optimize my mysql database. The current ...