List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:May 6 2011 12:20pm
Subject:RE: Input needed...
View as plain text  
> From: h.reindl@stripped
> To: mysql@stripped
> Subject: Re: Input needed...
> 
> Am 06.05.2011 13:26, schrieb J M:
> > Config:
> > 
> > Running on 8G Server.. Currently utilizing 7G.. running only mysql..
> 
> > [mysqld]
> > innodb_data_home_dir = /var/lib/mysql/
> > innodb_data_file_path = ibdata1:2000M;ibdata2:10M:autoextend
> 
> bad - you get one flat storage-pool which will grow
> and never can be rudced with "optimize table"
MG>so the datafile could never be reduced with OPTIMIZE TABLE
MG>http://www.pythian.com/news/1067/difference-between-innodb_data_file_path-and-innodb_file_per_table/
MG>would you suggest using innodb_file_per_table for more granular control?
MG>is it worth the effort to export the database and reimport the data into new db
> using innodb_file_per_table enabled in my.cnf?
MG>http://dev.mysql.com/doc/refman/5.1/en/innodb-parameters.html#sysvar_innodb_file_per_table
> 
danke,
Martin
 		 	   		  
Thread
Input needed...J M5 May
  • Re: Input needed...Reindl Harald5 May
    • Re: Input needed...J M6 May
      • RE: Input needed...Martin Gainty6 May
      • Re: Input needed...Reindl Harald6 May
        • RE: Input needed...Martin Gainty6 May
        • Re: Input needed...Peter Boros8 May