----- Original Message -----
From: "Bruce Dembecki" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Cc: "Ow Mun Heng" <[EMAIL PROTECTED]>
Sent: Monday, October 09, 2006 3:13 PM
Subject: Re: InnoDB, 1 file per table or 1 BIG table?
There are some minor performance benefits here when run against
benchmarks... but tiny. It is generally true that for tiny tiny
We really really like innodb_file_per_table - but mostly because it
makes our lives easier in many ways, not so much for performance
reasons.
Interesting stuff. Is the directory/file organization then similar to
that used by MyISAM tables when this option is enabled? That is, along
the lines of innodb_data_root/database/table?
How do you go about converting InnoDB databases from the single tablespace
to those using the table-per-file file organization?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
