Howdy all, We're looking at building a new database server and I'm looking into strategies for optimizing disk i/o.
Bit of background. We will be running a single database on this box under MySQL 5.0.15. All of the tables are INNODB. We have about 130 tables in the db. I've read that it's a good idea to have the innodb log files written out to a seperate physical drive so that those operations don't bog down the rest of the database disk I/O operations. Configuring INNODB to do that looks straightforward. Then there's the data. I know that I can create multiple shared table spaces and locate them on seperate disks but that doesn't seem to give me control over where individual tables' data are written on the disk array. Is there a way using innodb_file_per_table to control where the individual .idb files are located in the disk array? Do I have to use symbolic links to trick innodb or is there a cleaner way? Also, I've been told that innodb table spaces never shrink. Is this true or is there a way to periodically cleanup the idb files to reclaim unused space? Cheers, Tripp __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
