MySQL数据库常用操作汇总
1.查询数据库各个库大小
语法:
1 | SELECT |
例子:
1 | Welcome to the MariaDB monitor. Commands end with ; or \g. |
2.查询并发
1 | show global status like 'Threads%'; |
例子:
1 | Welcome to the MariaDB monitor. Commands end with ; or \g. |
3.查询从节点 语法:
1 | show slave hosts; |
例子:
1 | MySQL [(none)]> show slave hosts; |
All articles in this blog are licensed under CC BY-NC-SA 4.0 unless stating additionally.