How to Enable MySQL Query Monitoring_MySQL

Related MicroZone Resources

INFOGRAPHIC: The Future of the Database

What We Offer: Clustrix Features

Clustrix Whitepapers

Proven in Production: Clustrix Case Studies

Like this piece? Share it with your friends:

Do you need to monitor any SQL statements passing through your MySQL server? You would need to turn on the server logging. Edit your my.cnf file and add these:
log-output=FILE
general-log=1
general_log_file=mysql-general.log

Published at DZone with permission ofZemian Deng, author and DZone MVB. (source)

(Note: Opinions expressed in this article and its replies are the opinions of their respective authors and not those of DZone, Inc.)

Tags:

• MySQL
• Tips and Tricks
• SQL