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...
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
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
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