Want to read Slashdot from your mobile device? Point it at m.slashdot.org and keep reading!


Forgot your password?
Slashdot Deals: Deal of the Day - Pay What You Want for the Learn to Code Bundle, includes AngularJS, Python, HTML5, Ruby, and more. ×

Submission + - How to monitor a MySQL server in real time?

oliderid writes: I have almost finished a web application that should support more than 100 queries per second some tables having more than 500.000 rows. Well I'm not used to this kind of load. I did my best to apply the best practices I could find over the web, reduce the queries to the database to the minimum, indexing, etc. but I'd like to have a GPL tool to monitor this database in real-time and see clearly how often a query is done, redundant ones, be sure that my mental is respected "One query per "page", processing time, etc. See when the server is about to be overloaded. The server is remote, Linux (redhat or ubuntu). There is no Xwindow, so I can monitor it through SSH/shell or through a web application. Any idea? Thx!
This discussion was created for logged-in users only, but now has been archived. No new comments can be posted.

How to monitor a MySQL server in real time?

Comments Filter:

"The most important thing in a man is not what he knows, but what he is." -- Narciso Yepes