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
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
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