The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
12 views

Troubleshooting mySQL load problems

SSD VPS with one Magento site on it. Recently whenever I make a save to a product, the mysql QPS skyrockets and server load goes up tenfold for several minutes (even though the admin page loaded long ...
2
votes
2answers
474 views

mytop: least privileges required to run it?

What is the minimum set of privileges that mytop requires in order to work, without actually requiring super-user privileges. I feel uncomfortable with the fact that I have to save the password in ...
1
vote
2answers
2k views

MyTop doesn't display executed queries

I'm trying to use mytop for figuring out what queries are being executed and how long they take. I can connect properly to the db but MySQL on localhost (5.1.41-3ubuntu12.8) up ...
0
votes
1answer
550 views

How to write output from mytop to file

Our application is using a very busy MySQL database with lots of reads, sometimes I don't want to look at the MySQL log files, I just want the output from mytop for the last 5 minutes. How do I write ...
4
votes
5answers
422 views

Give me my KILL-power when something goes wrong

We've had it a few times now. Suddenly our production server won't respond because a process is in an infinite loop, or the MySQL server stops serving new requests because one query is blocking ...