mysql日志

mysql –help|grep my,cnf;

SHOW VARIABLES LIKE ‘%log_error%’;/错误日志/

SHOW VARIABLES LIKE ‘%long_query_time%’;/运行时间超过该值则记录到慢查询日志/
SHOW VARIABLES LIKE ‘%log_slow_queries%’;/手动添加至配置文件 值为ON/
SHOW VARIABLES LIKE ‘%log_slow_queries_file%’;/慢查询日志保存目录/

SHOW VARIABLES LIKE ‘%log_queries_not_using_indexes%’;/运行没有用到索引则记录至慢查询日志/
SHOW VARIABLES LIKE ‘%log_throttle_queries_not_using_indexes%’;/每分钟没有用到索引记录的个数，0为无限制/