摘要:
查询库: SELECT TABLE_SCHEMA, CONCAT(TRUNCATE(SUM(data_length)/1024/1024,2),' MB') AS data_size, CONCAT(TRUNCATE(SUM(index_length)/1024/1024,2),'MB') AS i 阅读全文
摘要:
1、 查看MySQL是否开启了事件功能 查看命令: show variables like '%sc%'; 打开event_scheduler(临时开启,MySQL服务重启后时效) SET GLOBAL event_scheduler = ON; 永久开启方法:my.cnf中[mysqld]添加ev 阅读全文