Re: Fw: modifying InnoDB storage

2005-04-26 Thread Gleb Paharenko
Hello. According to this: "If your last data file was defined with the keyword autoextend, the procedure to edit my.cnf must take into account the size to which the last data file has grown. You have to look at the size of the data file, round the size downward to the closest multiple of 1

Re: modifying InnoDB storage

2005-04-26 Thread Heikki Tuuri
Jigal, - Alkuperäinen viesti - Lähettäjä: "Jigal van Hemert" <[EMAIL PROTECTED]> Vastaanottaja: Kopio: "Gleb Paharenko" <[EMAIL PROTECTED]>; "Heikki Tuuri" <[EMAIL PROTECTED]> Lähetetty: Tuesday, April 26, 2005 2:09 PM Aihe: Fw: modifying

Fw: modifying InnoDB storage

2005-04-26 Thread Jigal van Hemert
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/ibdata

Re: modifying InnoDB storage

2005-04-20 Thread Jigal van Hemert
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: =

Re: modifying InnoDB storage

2005-04-20 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/adding-and-removing.html Think also about per-table tablespaces. See: http://dev.mysql.com/doc/mysql/en/multiple-tablespaces.html "Jigal van Hemert" <[EMAIL PROTECTED]> wrote: > Hi list, > > If you have the InnoDB tablespace f

modifying InnoDB storage

2005-04-20 Thread Jigal van Hemert
Hi list, If you have the InnoDB tablespace files defined as two files of 2GB and an autoextend file, is there any way to add extra tablespace files in this case? Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.