欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

How to Enable MySQL Query Monitoring_MySQL

程序员文章站 2023-12-22 12:21:22
...

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

上一篇:

下一篇: