ive searched high and low.....

adam_uk · 07-27-2003, 01:27 PM

on how i can get the size of a mysql database in megabytes (or kilobytes)but i cant find it anywhere

anyone got any tips or advice?

IndigoPixel · 08-15-2003, 02:32 PM

Use SHOW TABLE STATUS;

This will give you a result set row (for all the tables in the database, if you don't specify which one with a FROM clause) with a whole bunch of columns:

Name
Type
Row_format
Rows
Avg_row_length
Data_length
Max_data_length
Index_length
Data_free
Auto_increment
Create_time
Update_time
Charset in MySQL 4.1+
Check_time
Create_options
Comment

Data_length is the size (in bytes) of the table data file.

Brak · 08-15-2003, 11:38 PM

Also might care to look at the source of phpMyAdmin, I know when you view structure of a database you get a total size in kilobytes at the bottom right cell.

07-27-2003, 01:27 PM	#1 (permalink)
adam_uk Senior Member Join Date: May 2003 Posts: 2,211 6,170.25 NP$ (Donate)	ive searched high and low..... on how i can get the size of a mysql database in megabytes (or kilobytes)but i cant find it anywhere anyone got any tips or advice?

08-15-2003, 11:38 PM	#3 (permalink)
Brak New Member Join Date: Aug 2003 Posts: 14 21.00 NP$ (Donate)	Also might care to look at the source of phpMyAdmin, I know when you view structure of a database you get a total size in kilobytes at the bottom right cell. __________________ Design \| Game \| Music

08-15-2003, 02:32 PM	#2 (permalink)
IndigoPixel New Member Join Date: Jul 2003 Posts: 9 14.00 NP$ (Donate)	Use SHOW TABLE STATUS; This will give you a result set row (for all the tables in the database, if you don't specify which one with a FROM clause) with a whole bunch of columns: Name Type Row_format Rows Avg_row_length Data_length Max_data_length Index_length Data_free Auto_increment Create_time Update_time Charset in MySQL 4.1+ Check_time Create_options Comment Data_length is the size (in bytes) of the table data file.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)