forgot the list, sorry :) Walter Heck
---------- Forwarded message ---------- From: Walter Heck - OlinData.com <li...@olindata.com> Date: Thu, Mar 26, 2009 at 2:09 PM Subject: Re: A problem relative ibdata1 To: Cc: Riccardo Michele Filippone <ethern...@gmail.com> Riccardo, if you're ibdata1 file is growing fast, it means you are inserting lots of data into it. It doesn't magically grow out for no reason :) We can't look into your application, so you will have to monitor it yourself. Try enabling the general query log for 1 minute or so and see what kind of queries are running. You will most likely find something you are not expecting. What kind of application are you running MySQL under? If it is a website, is it custombuilt or an off-the-shelf product? Could it be some kind of logging procedure that is going banana's? We need more info to be able to answer your question :) good luck! Walter Heck On Thu, Mar 26, 2009 at 1:29 PM, Claudio Nanni <claudio.na...@gmail.com> wrote: > 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 >>> >>> >> >> >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
