MySQL Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do you find out the size of a database on mysql v 4.1 without information_schema?

3363898Dec 15 2016 — edited Dec 16 2016

Hi,

Is there a way to find the database size on MySQL v4.1 without information_schema? Getting the same result as the following query without using information_schema:

mysql> SELECT ENGINE, COUNT(*), SUM(DATA_LENGTH), SUM(INDEX_LENGTH) FROM information_schema.TABLES WHERE TABLE_SCHEMA='TABLE_SCHEMA_NAME' GROUP BY ENGINE;

Thank you.

This post has been answered by Gbenga Ajakaye on Dec 15 2016

Jump to Answer

Added on Dec 15 2016

#mysql-faqs, #mysql-user-groups

15 comments

1,243 views