Bruce Dembecki wrote:
At the 2004 Users Conference in Orlando in April there were two sessions on
optimizing MySQL hosted by a MySQL staffer who's name eludes me for the
moment.
Peter Zaitsev I believe. He did some InnoDB performance tuning sessions.
He told the assembled masses that in benchmarks he ran that
innodb_file_per_table was somewhat faster than using the large innodb table
space. I didn't get the impression it was like 50% faster or anything, but
once finished optimizing indexes and so on any gains are likely to be in
small pieces, but they all add up.
In most environments you are correct, the performance improvement you
might get from innodb_file_per_table is not going to be of a large
magnitude. Naturally, the best way for you to determine any performance
benefits of this or any other parameter tweaking is to benchmark your
performance before and after adjusting the parameter.
Cheers,
Doug
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
