Re: Number of InnoDB files vs performance?

2005-09-23 Thread Gleb Paharenko
Hello. In my opinion, if you're unable to put InnoDB files on different disks there is no sense to use separate files. Even more - using the raw partition for InnoDB might increase a performance. See: http://dev.mysql.com/doc/mysql/en/innodb-raw-devices.html However, if you prefer

Number of InnoDB files vs performance?

2005-09-21 Thread Richard F. Rebel
Hello, I was wondering if anyone had any knowledge to share regarding creating many 2GB innodb table space files, vs creating a few 100GB ones. It has been my habit to create many smaller for several reasons, including nfs clients/servers or utlities which don't reliably copy/ back