Re: A problem relative ibdata1

2009-03-26 Thread Dan Nelson
In the last episode (Mar 26), Riccardo Michele Filippone said: > Hello! First of all sorry for my terrible english. > > Well I've a big problem with ibdata1, this damn file increase its size > constantly. > > I tryed to use innodb_file_per_table... but: > > - MySQL create a lot of ibd files fo

Re: A problem relative ibdata1

2009-03-26 Thread Claudio Nanni
Hi Riccardo, I don't think you should need any other storage engine if you need foreign keys. InnoDB is by far the most used, standard, transactional, foreign key-supporting MySQL storage engine. No other valid option comes to my mind now. But please share your needs and let's see if I am wrong

Re: A problem relative ibdata1

2009-03-26 Thread Claudio Nanni
You can't! it is part of the datafiles of InnoDB storage engine! and It contains important data like the information schema. So I would rather ask you, is it abnormally growing or is it just your feeling? You should be more precise to have good answers, for instance how much megabytes per minu