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. Ciao Claudio 2009/3/26 Riccardo Michele Filippone <ethern...@gmail.com> > Well, I think it's abnormal because after a few days I can have a ibdata1 > of 7-8 GB!!! I don't think it's normal because, if ibdata1 continue > is growth... I must be purchase a datacente :P > > Now I try to retrive a charts of queries... > > however do you know if there is an engine that support/manage foreign key? > > I use innodb for this reason.. but the size of ibdata1 is a problem :'( > > Thanks for ur reply > > > Il giorno 26/mar/09, alle ore 12:30, Claudio Nanni ha scritto: > > 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 minute is it growing? > > How many inserts do you have on the tables per second/minute/hour? > > Ciao! > > Claudio > > 2009/3/26 Riccardo Michele Filippone <ethern...@gmail.com> > >> 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 for all DB (correct) >> - ibdata1 is however created and increase its size... >> >> how can I prevent the creation of this file (ibdata1)? >> >> Thanks for your future suggestion. >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >> http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com >> >> > > >
