MySql收集

MySQL开启配置binlog及通过binlog恢复数据步骤详析

https://www.jb51.net/database/322559yq7.htm

 

杀死进程

SHOW PROCESSLIST;

SELECT concat('KILL ',id,';') FROM information_schema.processlist WHERE `USER` ='app' AND COMMAND ='Sleep'

 

MySQL 查看每个表的数据量并按倒序排列

SELECT table_schema AS '数据库名', table_name AS '表名', table_rows AS '记录数', round(data_length/1024/1024, 2) AS '数据大小(MB)', round(index_length/1024/1024, 2) AS '索引大小(MB)'

, round((data_length + index_length)/1024/1024, 2) AS '总大小(MB)'

FROM information_schema.TABLES WHERE table_schema = DATABASE() -- 只查询当前数据库 ORDER BY table_rows DESC;

 

授权账号

mysql -u root -p

 

-- 如果用户不存在则创建，并设置密码

CREATE USER 'nacos'@'%' IDENTIFIED BY '你的密码';

-- 授予 tl_nacosdb 数据库的所有权限

GRANT ALL PRIVILEGES ON nacosdb.* TO 'nacos'@'%';

-- 刷新权限

FLUSH PRIVILEGES;