Try this for Database Size or Table Size :
SELECT TABLE_NAME,ROUND((DATA_LENGTH/1024)/1024) AS DATA_SIZE,ROUND((INDEX_LENGTH/1024)/1024) AS INDEX_SIZE,ROUND(((DATA_LENGTH/1024)/1024) + ((INDEX_LENGTH/1024)/1024)) AS TOTAL_TABLE_SIZE
FROM information_schema.TABLES
GROUP BY TABLE_NAME
Last edited by peter_budo; Apr 15th, 2009 at 7:39 am. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags. Keep It Spam-Free Do not spam, advertise, plug your website.
Reputation Points: 22
Solved Threads: 9
Junior Poster in Training
Offline 83 posts
since Jun 2008
Unsolved 
