mysql日志服务器_单台MySQL服务器的日志策略

use mysql ;

delimiter EOF

create procedure rotate_log_pro()

begin

drop table if exists general_log_old, general_log_tmp;

create table general_log_tmp like general_log;

rename table general_log to general_log_old, general_log_tmp to general_log;

drop table if exists slow_log_old, slow_log_tmp;

create table slow_log_tmp like slow_log;

rename table slow_log to slow_log_old, slow_log_tmp to slow_log;

end EOF

delimiter ;

复制代码

#创建事件调用存储过程

create event mysql.rotate_log_tables

on schedule every 5 hour

on completion preserve

do call rotate_log_pro();

复制代码

引自：http://www.kekeyun.com/forum.php?mod=viewthread&tid=150&extra=

分享到：

2013-12-25 16:49

浏览 1413

分类:数据库

评论