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
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
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
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
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 for all
[snip]
When I upload some data into my mysql database, the file ibdata1 is growing.
Usually I export contents of files into database. That's our requirement.
When I remove the same data from tables, there is no change in ibdata size.
I.e. it is not getting reduced with the deletions. But if I
Hi
Any help is greatly appreciated.
When I upload some data into my mysql database, the file ibdata1 is growing.
Usually I export contents of files into database. That's our requirement.
When I remove the same data from tables, there is no change in ibdata size.
I.e. it is not getting