size of database

[srpa01red]

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.

[Upsilon]

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.

[mwasif]

Please find here the table limit (http://dev.mysql.com/doc/refman/5.0/en/full-table.html). You can increase the limit by ALTERing Max_data_length.

Max_data_length is in bytes as Upsilon said.

[varmadba]

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