List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:March 26 2009 12:29pm
Subject:Re: A problem relative ibdata1
View as plain text  
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
A problem relative ibdata1Riccardo Michele Filippone26 Mar
  • Re: A problem relative ibdata1Claudio Nanni26 Mar
  • Re: A problem relative ibdata1Dan Nelson26 Mar
Re: A problem relative ibdata1Claudio Nanni26 Mar