0

how can i find size of my database

what is the max table size in mysql

is table size shown is in terms of kb or mb in mysql by default

actually dis is the max_data length shown using "show table status" 281474976710655. means data size is shown in kb or mb.

4
Contributors
3
Replies
4
Views
8 Years
Discussion Span
Last Post by varmadba
0

actually dis is the max_data length shown using "show table status" 281474976710655. means data size is shown in kb or mb.

I thought Max_data_length was in bytes, but I could be wrong. Also the maximum size of a table is usually determined by the operating system and not MySQL itself, in most cases I think this is around 2GB.

0

Try this for Database Size or Table Size :

SELECT TABLE_NAME,ROUND((DATA_LENGTH/1024)/1024) AS DATA_SIZE,ROUND((INDEX_LENGTH/1024)/1024) AS INDEX_SIZE,ROUND(((DATA_LENGTH/1024)/1024) + ((INDEX_LENGTH/1024)/1024)) AS TOTAL_TABLE_SIZE
FROM information_schema.TABLES
GROUP BY TABLE_NAME
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.