Re: Different ibdata files for every database
There is a way you can achieve this: run multiple instances of mysqld on the same server. This is often done by those wanting run run a single machine as a slave to more than one master.
The other trick is to make sure you use innodb_file_per_table as that leads to more efficient use of disk space. As far as I'm aware there is no way to recover space used by ibdata files other than by starting again with a clean install and reimporting data. Personally I think that's a big enough problem that it should be regarded as a bug.
Subject
Views
Written By
Posted
4890
June 30, 2010 11:32AM
1382
June 30, 2010 06:46PM
1439
June 30, 2010 09:45PM
2052
June 30, 2010 10:58PM
1465
June 30, 2010 11:28PM
2200
July 01, 2010 12:01AM
1662
July 01, 2010 08:10PM
2086
July 08, 2010 01:37AM
3421
July 08, 2010 10:19AM
Re: Different ibdata files for every database
1656
July 01, 2010 04:15AM
1475
July 05, 2010 01:16AM
1564
July 05, 2010 02:07AM
2492
July 05, 2010 12:06PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.