How MySQL monitor in real time?
If you are the administrator of a MySQL database and want to analyze the operation of MySQL in real time to diagnose problems, then you need to monitor the operating load of the server.

Through PHPMyAdmin you can see the variables of the MySQL server to check the settings and list of the processes, however, it is not a real time analysis.

There is a free tool available for monitoring real-time operation of MySQL, mtop. To use mtop tool, you simply have an account on the machine where the MySQL server is running.