To: Rozeboom, Kay [DAS]
Cc: mysql@lists.mysql.com
Subject: Re: Reusing ibdata1 space
- 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
- Original Message -
From: Nick Khamis sym...@gmail.com
I should mention that we have deleted the ib_* files in the past.
I hope that was an accident, because if you thought that was a good idea I'm
sending someone over with the spiked cluebat.
Luckily for you, the solution to that
I wonder, if there could be any method to regain InnoDB space other than
dump the whole database and reimport.
Thanks,
On Thu, Nov 10, 2011 at 12:44 AM, Johan De Meersman vegiv...@tuxera.bewrote:
- Original Message -
From: Nick Khamis sym...@gmail.com
I should mention that we
- Original Message -
From: Prabhat Kumar aim.prab...@gmail.com
I wonder, if there could be any method to regain InnoDB space other
than dump the whole database and reimport.
Very simple answer to that: no.
--
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene
Hello Reindi,
I don't mean to revisit an old post however, we are also using innodb
and experiencing a rough start.
Should we set innodb_file_per_table to 1? Also we expereince this
scenario a lot:
mysql show tables;
+---+
| Tables_in_symax |
Hello Reindl, I just noticed that I misspelled your name. Sorry about that!
Cheers,
Nick.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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