-
Categories
-
Tags/Keywords
Firefox WWW SSH Family CLI postfix Linux van der Molen DNS samba RAID Subversion nutrition Screen zimbra VIM MediaWiki plugin xen Ruby Debian WordPress Gentoo WLB07051 HTML metabolism shell Ubuntu Windows HTTP RuG smb Apache bash T61 X XTerm mod_rewrite svn MySQL ssl PHP blog.bigsmoke.us CSS Javascript -
Recent Posts
-
Recent Comments
Tag: size
Listing MySQL table sizes
This query lists the sizes of all tables in MySQL:
SELECT
TABLE_SCHEMA,
TABLE_NAME,
CONCAT(ROUND(data_length / ( 1024 * 1024 ), 2), 'MB') DATA,
CONCAT(ROUND(data_free / ( 1024 * 1024 ), 2), 'MB') FREE
from information_schema.TABLES
where TABLE_SCHEMA NOT IN ('information_schema','mysql', 'performance_schema');
Read More »