Hi all,
I've been searching the archives & mysql documentation for a while and I
can't seem to find an answer to my question -
Is there a way to force InnoDB to shrink its filesize? I just dropped a 7GB
table, but it hasn't freed up the disk space and I need it back. From what
I've been reading, a restart will cause this to happen, but I'm in a
production environment, and I'm afraid that InnoDB will take its sweet time
while my users are holding their breath.
Does anyone have any experience with this?
Here is a cut/paste:
mysql> show table status like 'CNRC' \G
*************************** 1. row ***************************
Name: CNRC
Type: InnoDB
Row_format: Fixed
Rows: 18777009
Avg_row_length: 54
Data_length: 1028128768
Max_data_length: NULL
Index_length: 1296220160
Data_free: 0
Auto_increment: 34182820
Create_time: NULL
Update_time: NULL
Check_time: NULL
Create_options:
Comment: InnoDB free: 7083008 kB
1 row in set (2.06 sec)
Thanks very much in advance!
-Dave Seltzer
-------------------------
Dave Seltzer
Systems Architect
TVEyes
p: 203.254.3600 x222
f: 203.254.3605
e: [EMAIL PROTECTED]
-------------------------
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
