RE: innodb file per table

2006-05-02 Thread Duzenbury, Rich
> > but you don't know __when__ innodb_file_per_table was set! > > So it's possible that many innodb tables actually reside in ibdata > > [1-4]. > > Check your data directory to see the individual innodb files/tables > > (*.ibd). > > This is true, and even on a fresh install that has always had

Re: innodb file per table

2006-05-01 Thread Ware Adams
On Apr 26, 2006, at 3:54 AM, Dr. Frank Ullrich wrote: Duzenbury, Rich wrote: Hi all, I've inherited an innodb database that is configured like: innodb_file_per_table innodb_data_file_path = ibdata1:3000M;ibdata2:3000M;ibdata3:3000M;ibdata4:3000M:autoextend Um, doesn't this allocate 12G that wi

Re: innodb file per table

2006-04-26 Thread Dr. Frank Ullrich
Duzenbury, Rich wrote: Hi all, I've inherited an innodb database that is configured like: innodb_file_per_table innodb_data_file_path = ibdata1:3000M;ibdata2:3000M;ibdata3:3000M;ibdata4:3000M:autoextend Um, doesn't this allocate 12G that winds up being unused, since innodb_file_per_table is se