mysql常用命令

查看所有日志

show master logs;

从库设置为只读

set global read_only=1;

---

mysql 查看数据库大小
SELECT
table_schema AS "Database",
ROUND(SUM(data_length + index_length) / 1024 / 1024, 2) AS "Size (MB)"
FROM
information_schema.tables
GROUP BY
table_schema;