Re: Database migration from default configuration to innodb_file_per_table

2014-03-26 Thread Christophe
Hi, Data migration made last night. Use of a new MySQL instance has been quite useful to operate, the outage was about 7 minutes. ibdata1 is now using 58 MiB of disk space ! each table having a proper .ibd file and full data directory from 13GiB to 3.2GiB ... Server load divided by 3 ~ 4 ;). I

Re: Database migration from default configuration to innodb_file_per_table

2014-03-23 Thread Christophe
Hi Shawn, and thanks for this concise anwser ;) . Le 22/03/2014 05:35, shawn l.green a écrit : > > The system is operating exactly as designed. The ibdata* file(s) contain > more than just your data and indexes. This is the common tablespace and > it contains all the metadata necessary to identify

Re: Database migration from default configuration to innodb_file_per_table

2014-03-21 Thread shawn l.green
Hello Christophe, On 3/21/2014 4:47 PM, Christophe wrote: Hi list, I'd like your advice, (one more time ;) ) about this case : The context is : A huge database using InnoDB engine from filling about several years (without possible shrinking, as I've seen, except dropping all databases to recr