�� MySQL (Heckfy)

Wed, 06 Feb 2008 12:12:00 GMT

��, �� :

use information_schema;
SELECT
concat(table_schema,'.',table_name) AS sql_table,
concat(round(table_rows/1000000,2),'M') rows,
concat(round(data_length/(1024*1024*1024),2),'G') DATA,
concat(round(index_length/(1024*1024*1024),2),'G') idx,
concat(round((data_length+index_length)/(1024*1024*1024),2),'G') total_size,
round(index_length/data_length,2) idxfrac
FROM TABLES
ORDER BY data_length+index_length DESC
LIMIT 10;

+------------------------+--------+--------+--------+------------+---------+
| sql_table | rows | DATA | idx | total_size | idxfrac |
+------------------------+--------+--------+--------+------------+---------+
| dev.event_logs_backup2 | 75.83M | 14.39G | 13.31G | 27.70G | 0.93 |
| dev.event_logs_backup | 26.90M | 4.48G | 4.31G | 8.79G | 0.96 |
| dev.event_logs | 1.20M | 0.20G

OpenForum RSS: ������ �������� �������: ���������� ������� ������ MySQL

���������� ������� ������ MySQL (Heckfy)

OpenForum RSS: �� : �� MySQL

�� MySQL (Heckfy)