How to Monitor SQL queries
by David Pham • October 2, 2014 • Blog • 3 Comments
In PHP web development what relate to database, I usually want to check my SQL detail. But not all of time, I can debug line by line or print out the SQL query to check. Instead of showing SQL queries, I will make it show everything in mysql log file with detail of SQL to check. Here is the easiest way to monitor SQL queries in Linux (you can do the same in Windows or Mac).
Visit the mysql configuration file:
|
1 |
/etc/mysql/my.cnf |
Find and uncomment this line
|
1 2 3 4 |
# Both location gets rotated by the cronjob. # Be aware that this log type is a performance killer. log = /var/log/mysql/mysql.log |
Now restart mysql server
|
1 |
sudo /etc/init.d/mysql restart |
Now we’re ready to start monitoring the queries as they come in. Open up a new terminal and run this command to scroll the log file, adjusting the path if necessary.
|
1 |
tail -f /var/log/mysql/mysql.log |
Related Posts
The best way to prevent SQL injection in PHP
Joomla nginx set up and configuration
mod_php, FastCGI or PHP-FPM for Server?
Disable warning and notice message for wamp
Joomla System Requirements
Hide the Article Author in Joomla 3.x
Configure joomla memcached for faster speed
3 ways to force secure https by .htaccess
PHP Cli on Ubuntu with problem “MIB search path”
Joomla SEO – Settings to optimize onpage factors
It ‘s really simple instruction. It help me a lot to debug transaction query. Thank author.
You are welcome, I will release more useful article soon about mysql server.
Is any way in non root hosting?