FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Query your base's size





ralcantara
With this query you can see your base_size and the free_space.

SELECT table_schema 'Data Base Name',
sum( data_length + index_length ) / 1024 /
1024 'Data Base Size in MB',
sum( data_free )/ 1024 / 1024 'Free Space in MB'
FROM information_schema.TABLES
GROUP BY table_schema ;

Wink
jmraker
I think the same info is in this SQL command
Quote:
SHOW TABLE STATUS
Related topics
Implementing your database access in PHP as a layer.
Frankfurt Motor Show, 2005
Nuke-Evolution
HTML formulier
[solved] html multiply list doesnt give all values
The new norm for website height/width?
Help SQL Sort
A Bit of Data Size Terminology
[Help]Leyendo imagenes desde un directorio (Permisos)
[Help]Reading images from folder (permissions)
Index and Search My Site
Proprietary attribute warning
Injecting Text into a Text entry field
Google the knowledge engine and the future of webmastering
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.