- Original Message -
> From: "Kay Rozeboom [DAS]"
>
> 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 normally alr
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]
> We are running MySQL 5.0.77, and using INNODB in producti
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
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 "ibd
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 colle
