Forums

Size of mysql database are included to disk quota?

If so, how to calculate the database size?

Yes it is, but it's not automatically synced up -- that is, if you hit your limit, we'll be alerted and will get in touch, so your app should continue running for a while.

To find out how much space the current database is using, start a MySQL console on the database in question, then run this:

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

Script worked.

Thank you.

May be, you need to add your answer to FAQ?

Thanks for confirming! That's a good idea, I'll do that now.

:)

New page MySQLDatabaseSize

Thanks! I should have linked to that myself :-)