Unfortunately no response from the list anymore :-( Can we ever get rid of the autoexpanding ibdata file without completely rebuilding the databases?
Regards, Jigal. ----- Original Message ----- From: "Jigal van Hemert" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Wednesday, April 20, 2005 12:31 PM Subject: Re: modifying InnoDB storage > From: "Gleb Paharenko" > > Hi Gleb, > > Thanks for your response. > > > http://dev.mysql.com/doc/mysql/en/adding-and-removing.html > > If it currently reads: > innodb_data_file_path = > /ibdata/ibdata1:2000M;/ibdata/ibdata2:2000M;/ibdata/ibdata3:2000M;/ibdata/ib > data4:10M:autoextend > > Can you change this into: > = > /ibdata/ibdata1:2000M;/ibdata/ibdata2:2000M;/ibdata/ibdata3:2000M;/ibdata/ib > data4:2000M;/ibdata/ibdata5:10M:autoexten > or > = > /ibdata/ibdata1:2000M;/ibdata/ibdata2:2000M;/ibdata/ibdata3:2000M;/ibdata/ib > data5:2000M;/ibdata/ibdata4:10M:autoexten > ??? > > > Think also about per-table tablespaces. See: > > Sorry, it's still 4.0.x that our sysadmin wants... > > Regards, Jigal. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
