/etc/init.d/mysqld status
/etc/init.d/mysqld start
删除表内容
truncate range_tb_watch_position;
查看事件
SHOW EVENTS
select * from mysql.event
查看是否开启定时器
SHOW VARIABLES LIKE ‘event_scheduler’;
开启定时器 0:off 1:on
SET GLOBAL event_scheduler = 1; .
删除
drop EVENT *_event;
查询分区
SELECT PARTITION_NAME,TABLE_ROWS FROM INFORMATION_SCHEMA.PARTITIONS WHERE TABLE_NAME = ‘tb_notification_config’;