炫酷网站欣赏,制作企业宣传册用什么软件,网页设计实训总结报告三千字,百度搜索推广多少钱查询日志的作用是记录所有客户端发来的sql语句#xff0c;也就是记录客户端的所有操作Log参数将要过时#xff0c;现在用general_log来代替打开查询日志功能mysql showvariables like %log;-----------------------| Variable_name| Value |----------------…查询日志的作用是记录所有客户端发来的sql语句也就是记录客户端的所有操作Log参数将要过时现在用general_log来代替打开查询日志功能mysql showvariables like %log;-----------------------| Variable_name| Value |-----------------------| back_log| 50|| general_log| OFF|| log| OFF|| relay_log||| slow_query_log | OFF|| sync_binlog| 0|-----------------------6 rows in set (0.01 sec)mysql set global general_log1;Query OK, 0 rows affected (0.18 sec)mysql set globallog1;Query OK, 0 rows affected, 1 warning (0.00sec)mysql showvariables like %log;-----------------------| Variable_name| Value |-----------------------| back_log| 50|| general_log| ON|| log| ON|| relay_log||| slow_query_log | OFF|| sync_binlog| 0|-----------------------6 rows in set (0.00 sec)也可以在my.cnf中添加参数general_log1general_log_file/tmp/chenzhongyang.log这样来设定mysql show variables like%file;--------------------------------------------------------------| Variable_name| Value|--------------------------------------------------------------| ft_stopword_file| (built-in)|| general_log_file| /tmp/chenzhongyang.log|| init_file||| local_infile| ON|| pid_file|/usr/local/mysql/var/test4.wolf.org.pid || relay_log_info_file | relay-log.info|| slow_query_log_file |/usr/local/mysql/var/test4-slow.log|--------------------------------------------------------------查看日志文件的内容[roottest4 ~]# tail -f/tmp/chenzhongyang.log/usr/local/mysql/libexec/mysqld, Version:5.1.70-log (Source distribution). started with:Tcp port: 3306Unix socket: /tmp/mysql.sockTimeId CommandArgument130903 16:09:431 Connectrootlocalhost on1 Queryselectversion_comment limit 1130903 16:10:141 Queryshow variables like %file130903 16:12:091 Queryselect * fromtt130903 16:12:161 QuerySELECT DATABASE()1 Init DBtest130903 16:12:181 Queryselect * fromtt一般情况下我们不打开查询日志功能因为他对系统效率的影响很大管理查询日志文件一般的日志文件会很大所以要处理日志[roottest4 ~]# mysqladminflush-logs;刷新日志所有日志文件
