当前位置:Gxlcms > mysql > HowtoEnableMySQLQueryMonitoring_MySQL

HowtoEnableMySQLQueryMonitoring_MySQL

时间:2021-07-01 10:21:17 帮助过:14人阅读

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

人气教程排行