Dear All,
I have the following table (MYISSAM or INNODB)
Tablename Filed Type size
app_colid_Examid registerno varchar 15
app_colid_Examid subcode varchar 15
app_colid_Examid mode varchar 2
app_colid_Examid programmeid Integer
app_colid_Examid subjectorder Integer
app_colid_Examid
We are running MySQL 5.0.77, and using INNODB in production for the first time.
The production database has a lot of inserts and deletes, and the shared
ibdata1 file is continually growing. I understand that to return the unused
space to the operating system, we must delete and recreate
Am 01.11.2011 15:02, schrieb Rozeboom, Kay [DAS]:
We are running MySQL 5.0.77, and using INNODB in production for the first
time. The production database has a lot of inserts and deletes, and the
shared ibdata1 file is continually growing. I understand that to return
the unused space to
Kay,
There's no way to regain InnoDB space.
I can suggest some techniques but no magic.
1. dump the whole database and reimport
2. setup a brand new slave ,sync and switch to it
Cheers
Claudio
2011/11/1 Rozeboom, Kay [DAS] kay.rozeb...@iowa.gov
We are running MySQL 5.0.77, and
- Original Message -
From: Kay Rozeboom [DAS] kay.rozeb...@iowa.gov
I realize that this would not return the unused space to the
operating system. But would it return it to MySQL so that it could
be re-used for subsequent inserts, instead of extending ibdata1
further?
That should