show global variables like '%general%';
set global general_log=on;
set global log_output=table;
select * from mysql. general_log\G;
alter table general_log engine = myisam;
set global general_log=off;
由--general-log或者general_log打开
由general_log_file指定绝对路径
记录数据库的全部SQL,连接信息
格式如下:
Event_time | thread_id | command_type | argument |
Event_time每秒第一次query打印
Query发出时记录
错误的,失败的,成功的均会记录
数据库的流量日志
additional usage?
日志切分脚本:script_tools/cutlog.sh
为general log每一行打印时间戳
为general log每一行打印user@host
程序示例:
#!/bin/bash
datetime=`date +%y%m`
log=$1
awk "{
if(\$1~/^$datetime/) {
time1=\$1;
time2=\$2;
print \$0;
}else{
print time1,time2,\$0
}
}
" $log