Real-time MySQL monitoring

Question

I was wondering if there is a tool that I can control MySQL database data in real time using PHP?

I am currently using the Ajax call to check the database for any updates every few seconds, but I assume that this is not true when I have more users, as this puts a lot of pressure on the server.

** Just add a note that I really want to show data on my website written in PHP, so it would be useful to know what is the best way to integrate other tools to achieve this.

Answer 1

PHP is not the best for real-time monitoring, since it is (usually) transaction-based (HTTP).

There is a free open-source Java program called the Mysql Monitor Tool, which can track MySQL (or several) databases in real time:

http://sourceforge.net/projects/mysqlmt/

Answer 2

I am using JET Profiler: http://www.jetprofiler.com/

It also has a free version.

Answer 3

Mysql Workbench also has a server monitoring feature. It shows basically most of the things you need to know in real time.

To open it, open a connection to the database, go to the "Server" tab, and then "Server Status".

Answer 4

As Petah mentioned: PHP is not the best for real-time monitoring, since it is (usually) transaction-based (HTTP).

I am using the Monyog tool, which has a real-time monitoring function with some other functions.