Hi! ----- Original Message ----- From: ""Rodrigo Gonzalez"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Friday, April 05, 2002 8:59 PM Subject: InnoDB
> First of all excuse my english...I hope someone can understand me.... > > I am thinking in converting from MyIsam to InnoDb tables. > > I have this table: > > > du -sm table* > 323 table.MYD > 276 table.MYI > 0 table.frm > > How much tablespace I need to convert it to InnoDb, I found that I need a > lot more space for this table type, but I could not find how to calculate > this space... The auto-extending data file of InnoDB-3.23.50 will solve your problem. No need to preallocate tablespace any more. I think the following formula usually gives a rough estimate of the needed size: 1.5 x size of the .MYD file + 5 x size of .MYI file. > Regards, > > Rodrigo Gonzalez. > > sql,query 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 --------------------------------------------------------------------- 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