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.
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.
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.
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_NAMEWe're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.