The tag has no wiki summary.

learn more… | top users | synonyms

-2
votes
0answers
36 views

Optimization Tips For MYSQL Tuner/Primer [closed]

So I have a site that has a crap ton of traffic. I see a decent amount of latency when the site has over 1,000 active visitors on it. I have new relic installed and it seems Im only using 10% of the ...
0
votes
1answer
453 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
120 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 ...
0
votes
1answer
664 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
182 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
551 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 ...