To know what mysql is doing we enable the query logging.
Enable Query logging
- Enter mysql console as root
# mysql -uroot -p
- Enable logging:mysql> SET global general_log = 1; SET global log_output = ‘table’;
- View the log and see what is supposed to be executed
mysql> select * from mysql.general_log;
Disable Query loggning
mysql> SET global general_log = 0;
This is useful when you want to track whats going on in your SIP server’s database.
To know about other types of mysql logging Mysql-Server-Logs