How to get size of mysql database ?

Question

Suppose the target database is called "v3"

Answer 1

Run this query and you'll probably get what you're looking for:

SELECT table_schema "DB Name", sum( data_length + index_length ) / 1024 / 1024 "DB Size in MB" 
FROM information_schema.TABLES GROUP BY table_schema ;

This query comes from here, where there are more comprehensive instructions available.

Answer 2

Alternatively you can directly jump into data directory and check for combined size of v3.myd, v3. myi and v3. frm files (for myisam) or v3.idb & v3.frm (for innodb).