List:General Discussion« Previous MessageNext Message »
From:Walter Heck - OlinData.com Date:March 26 2009 1:10pm
Subject:Fwd: A problem relative ibdata1
View as plain text  
forgot the list, sorry :)

Walter Heck

---------- Forwarded message ----------
From: Walter Heck - OlinData.com <lists@stripped>
Date: Thu, Mar 26, 2009 at 2:09 PM
Subject: Re: A problem relative ibdata1
To:
Cc: Riccardo Michele Filippone <ethernaly@stripped>


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.nanni@stripped> 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 <ethernaly@stripped>
>
>> 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 <ethernaly@stripped>
>>
>>> 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=1
>>>
>>>
>>
>>
>>
>
Thread
Fwd: A problem relative ibdata1Walter Heck - OlinData.com26 Mar