Lars, ----- Original Message ----- From: "Lars Andersson" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, December 20, 2002 12:17 PM Subject: add one more innodb_data file when I do have an autoextending one?
> I have an production MySQL-Max -3.23.54a server running innodb databases. > > I've migrated the server and data from an older Linux installation (with > max filesize 2GByte). The new server is running Linux 2.4 and can deal > with larger files. > > I have three in innodb_data files and the last one is autoextending and > it's soon full. My innodb_data_file_path looks like this (wordwrapped in > order to make it readable). > > innodb_data_file_path = > disk1/innodb/ibdata/ibdata1:2000M; > disk1/innodb/ibdata/ibdata2:2000M; > disk1/innodb/ibdata/ibdata3:100M:autoextend:max:2000M > > Can I remove the autoextend option on the last data_file, and add a new > one wich is autoextending? > > Will mysql make the ibdata3 file like the other files automatically? > Does it work or will I lose data? http://www.innodb.com/ibman.html#InnoDB_start " innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:100M:autoextend instructs InnoDB to create just a single data file whose initial size is 100 MB and which is extended in 8 MB blocks when space runs out. If the disk becomes full you may want to add another data file to another disk, for example. Then you have to look the size of ibdata1, round the size downward to the closest multiple of 1024 * 1024 bytes (= 1 MB), and specify the rounded size of ibdata1 explicitly in innodb_data_file_path. After that you can add another data file: innodb_data_home_dir = innodb_data_file_path = /ibdata/ibdata1:988M;/disk2/ibdata2:50M:autoextend " > I want to do this with as little downtime as possible. I've tried to add > a ibdata4 file thats autoextending but MySQL only supports one > autoextending file. > > > /Lars Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php