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.

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
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.