MySQL DBA常用脚本
1、编码相关
1.1、查看表编码、引擎、大等各类信息
SHOW TABLE STATUS FROM hive LIKE '%zeus_worker%';
1.2、修改表编码
--修改表编码为utf8
ALTER TABLE test CONVERT TO CHARACTER SET utf8;
--查看修改结果
SHOW CREATE TABLE test;
2、调度器相关
2.1、查看/启用调度器并创建调度
SHOW VARIABLES LIKE '%scheduler%';
SET GLOBAL event_scheduler = 1;
CREATE EVENT purge_binary_logs
ON SCHEDULE EVERY 1 DAY
DO
PURGE BINARY LOGS BEFORE DATE_SUB(NOW( ),INTERVAL 3 DAY);
SHOW EVENTS;
ALTER EVENT purge_binary_logs ENABLE;