Menu
I was wondering if there is a tool that I can monitor MySQL DB data in real time using PHP?
Currently I use an Ajax call to check the database for any updates every few seconds but I assume this is not the correct way when I have more users as it puts a lot of pressure on the server.
** Just to add a note that I actually want to show the data on my website which is written based on PHP, so it would be useful to find out what is the best way to integrate other tools in order to achieve this.
904
As we stated, MySQL Enterprise Monitor is a part of the paid MySQL Enterprise Edition. For all users of the MySQL Community, MariaDB or Percona Server, MySQL Enterprise Edition is not available. ClusterControl provides access to monitoring of MySQL in its free Community version.
MySQL Enterprise Monitor can monitor all types of installation, from a single MySQL instance to large farms of database servers. MySQL Enterprise Monitor is a web-based application, enabling you to monitor MySQL instances on your network or on a cloud service.
Access MySQL Enterprise Service Manager services using the script mysqlmonitorctl.sh / mysqlmonitor. bat which is installed in the root of your MySQL Enterprise Service Manager installation directory. To see the available options, run the command mysqlmonitorctl.sh help .
PHP is not really the best for real time monitoring as it is (normally) transaction based (HTTP).
There is a free open source Java program called "Mysql Monitor Tool" which can monitor a MySQL (or multiple) databases in real time:
http://sourceforge.net/projects/mysqlmt/
81
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
