MySQL 4 Database Size

07-11-2008, 03:38 AM

Hi,

I'm facing a problem:

Well, in MySQL 5 it's easy to query the Information_Schema Database to retrieve the size of all the batabases of your MySQL5 instance.

What about MySQL 4 ?

I have still several MySQL4 instances containing informations that needs to be centralized. It's 3 days i'm seeking through the web but I cannot find how to retrieve the datafile sizes of all my databases running on my MySQL4 instances using ONLY SQL. I'm turning crazy.

I can only SQL, and my boss doesn't want me to create a bash file to do that job.

Comment

With that command I have too much informations. I don't care about the name of the database, its size, row format, row count, average row size etc... I just want a unique information when I query the database: its size (index+datas).

Under a Unix based system, I would use the Grep command, but it has to be only SQL command.