时间：2021-07-01 10:21:17 帮助过：22人阅读
普通查询日志记录客户端连接信息和执行的sql语句信息
mysql> show variables like ‘general_log%‘;+------------------+---------------------------+| Variable_name | Value |+------------------+---------------------------+| general_log | OFF | -> 默认为关闭状态| general_log_file | /data/3306/data/node1.log |+------------------+---------------------------+mysql> set global general_log = ON;mysql> set global general_log_file = "/data/3306/data/general_90root.log";mysql> show variables like ‘general_log%‘;+------------------+------------------------------------+| Variable_name | Value |+------------------+------------------------------------+| general_log | ON || general_log_file | /data/3306/data/general_90root.log |+------------------+------------------------------------+## 以上配置临时生效 |
[root@node1 ~]# cat /data/3306/my.cnf[mysqld]character_set_server = utf8general_log = ONgeneral_log_file = "/data/3306/data/general_90root.log"; [root@node1 ~]# /data/3306/mysql restart[root@node1 ~]# mysql -uroot -p90root3306 -S /data/3306/mysql.sockmysql> show variables like ‘general_log%‘;+------------------+-------------------------------------+| Variable_name | Value |+------------------+-------------------------------------+| general_log | ON || general_log_file | /data/3306/data/general_90root.log |+------------------+-------------------------------------+[root@node1 ~]# tail -f /data/3306/data/general_90root.log160723 4:54:49 4 Query show databasesmysql> show databases;+--------------------+| Database |+--------------------+| information_schema || 90_root || 90root || 90root_gbk || 90root_test || ab || mysql || performance_schema || test || test_sz |+--------------------+ |
企业里一般是关闭的, 因为性能的问题
慢查询日志只记录执行时间超出指定值的sql语句
慢查询的设置对于数据库sql的优化非常重要
[root@node1 ~]# cat /data/3306/my.cnf[mysqld]long_query_time = 1 -> sql执行语句超过1秒记录到慢查询日志slow-query-log-file = /data/3306/slow.log -> 慢查询日志文件路径log_queries_not_using_indexes -> 没有走索引的sql语句记录到慢查询日志[root@node1 ~]# /data/3306/mysql restart |
本文出自 “断肠人在天涯” 博客，请务必保留此出处http://8649605.blog.51cto.com/8639605/1855594
MySQL 普通查询日志 和 慢查询日志介绍
标签：general sql语句 日志记录 mysql 客户端