SELECT table_schema,
table_name,
ROUND(data_length/1024/1024,2) total_size_mb
FROM information_schema.tables
WHERE table_name = 'table_name' AND table_schema = 'database_name';
Lähde:
http://www.discussweb.com/database-support/1589-how-calculate-table-size-mysql.html
0 comments
No comments yet.