如何利用MySQL命令高效查询数据库的使用率？

要查询MySQL数据库的使用率，可以使用以下命令：

1、查看数据库大小和表空间使用情况：

SELECT table_schema AS 'Database', SUM(data_length + index_length) / 1024 / 1024 AS 'Size (MB)' FROM information_schema.tables GROUP BY table_schema;

2、查看数据库中每个表的大小：

SELECT table_name AS 'Table', table_rows AS 'Rows', data_length AS 'Data Length', index_length AS 'Index Length', round((data_length + index_length) / 1024 / 1024, 2) AS 'Size (MB)' FROM information_schema.tables WHERE table_schema = 'your_database_name';

3、查看数据库中每个表的行数：

SELECT table_name AS 'Table', table_rows AS 'Rows' FROM information_schema.tables WHERE table_schema = 'your_database_name';

请将上述命令中的your_database_name替换为您要查询的数据库名称。

SELECT
  table_schema AS Database,
  SUM(data_length + index_length) / 1024 / 1024 AS Total_MBs,
  SUM(data_length) / 1024 / 1024 AS Data_MBs,
  SUM(index_length) / 1024 / 1024 AS Index_MBs
FROM
  information_schema.TABLES
WHERE
  table_schema NOT IN ('information_schema', 'mysql', 'performance_schema', 'sys')
GROUP BY
  table_schema
ORDER BY
  Total_MBs DESC;

下面是查询结果的表格格式：

这里的X.YZ,A.BZ,C.DZ 是示例数据，你需要运行上述查询语句来获取实际的数据库使用情况，你可能需要根据你的数据库结构和需求调整查询语句。