| Reduce InnoDB Table Space [message #3268] |
Wed, 09 July 2008 19:09  |
 Speeple
Messages: 91
Registered: August 2006 |
Member |
|
|
I recently changed to a per-table file for InnoDB.
The problem now is I'm left over with a 70Gb old table space file which used to singularly hold the entire database.
Is there a way of reducing the size without harming the data?
I've tried moving the log files and old table space so that MySQL recreates them, but then the individual tables are lost via this process so I must revert to the old files.
I guess a full backup and re-insert will rectify the problem but that's a process that takes more time than I want.
Cheers!
Martin Gallagher | Speeple: The latest news
|
|
|
|
| Re: Reduce InnoDB Table Space [message #3278 is a reply to message #3273 ] |
Fri, 11 July 2008 16:37  |
Speeple
Messages: 91
Registered: August 2006 |
Member |
|
|
I understand the central table space needs to exist, but being 75Gb means it contains all of the old data which is now in separate files.
I did do a backup etc. now the default table space is 50Mb.
Martin Gallagher | Speeple: The latest news
|
|
|
|
| Re: Reduce InnoDB Table Space [message #3280 is a reply to message #3279 ] |
Fri, 11 July 2008 18:32 |
Speeple
Messages: 91
Registered: August 2006 |
Member |
|
|
What I mean is data was moved from a single table space to per file per table.
This means there was a lot of empty space in the 75Gb old single table space. There is no vacuum or such function, so a dump and re-insert rectified the space issue.
Martin Gallagher | Speeple: The latest news
|
|
|
Members
Search
Help
Register
Login
Home
