The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
2k views

MySQL connections aborted - should I be worried?

I'm tuning MySQL on a webserver with Apache and mod_php for speed so I ran mysqltuner and here's the result: -------- General Statistics -------------------------------------------------- [--] ...
0
votes
1answer
208 views

MySQL Tuning — High Memory Usage

I'm trying to tune a mysql db using mysqltuner. Mysqltuner is advising that I increase the join_buffer_size and the query_cache_size. At the same time, however, it is warning that my max memory usage ...
1
vote
1answer
1k views

MysqlTunner and query_cache_size dilemma

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 ...
2
votes
3answers
246 views

MySQL - Identifying a never ending, server crashing query

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 ...
1
vote
2answers
651 views

mysqltuner suggestion

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 ...