OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
Re: Calculate total size of InnoDB tables?

From: Krishna Prajapati (prajapatikcgmail.com)
Date: Mon Sep 15 2008 - 00:32:53 CDT

mysql> select table_schema, sum(round(data_length/1024/1024,2)) as
total_size_mb from information_schema.tables where table_schema like 'dip'
and engine like 'innodb' group by table_schema;
+--------------+---------------+
| table_schema | total_size_mb |
+--------------+---------------+
| dip | 169.01 |
+--------------+---------------+
1 row in set (0.38 sec)

On Sat, Sep 13, 2008 at 1:55 AM, Ryan Schwartz <ryanryanschwartz.net>wrote:

> Is there an easy way to calculate the total size of all InnoDB tables?
> --
> Ryan Schwartz
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=prajapatikcgmail.com
>
>

--
Krishna Chandra Prajapati
MySQL DBA,
Ed Ventures e-Learning Pvt.Ltd.
1-8-303/48/15, Sindhi Colony
P.G.Road, Secunderabad.
Pin Code: 500003
Office Number: 040-66489771
Mob: 9912924044
URL: ed-ventures-online.com
Email-id: prajapatikcgmail.com