刀刀网
您的当前位置:首页HowtoEnableMySQLQueryMonitoring_MySQL

HowtoEnableMySQLQueryMonitoring_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
  • 显示全文