Does anyone know if it is better to have 1 large innodb datafile on a disk or if it is better to have a few smaller datafiles?
Here is what I have. Both drives are 15K scsi running at full 160MB/S speed. /var/lib/mysql/ - contains all myisam tables as well as a 1GB innodb datafile. /mysql2 - contains 3 innodb datafiles. Each 3GB in size. Would I be better off with a 9GB datafile on the /mysql2 disk or the 3 smaller files? The reason I ask is this machine is 1 of 2 slaves. We're planning on replacing our primary database with this one. I've run a query on this machine which is taking about a minute to run. If I run the same query on the other slave, it only takes about 13 seconds. The "only" difference in the mysql setup is that the other slave has a 6.2GB datafile on the /mysql2 partition instead of the 3 3GB datafiles. The other machine is also about 1/2 the speed of this one and runs on 5200rpm IDE drives. Below are the specs for the two machines. I'd try creating just a single datafile on the /mysql2 drive, but I don't want to shut down both slaves if I don't have to. Slow running slave - Athlon XP2200, 768MB RAM, 2 15K scsi drives running at full 160MB/s speed. set-variable = innodb_buffer_pool_size=300M set-variable = innodb_additional_mem_pool_size=50M Fast running slave - Pentium III 600MHz, 500MB RAM, 2 5200 RPM drives. set-variable = innodb_buffer_pool_size=200M set-variable = innodb_additional_mem_pool_size=20M Thanks! -- Walter Anthony System Administrator National Electronic Attachment Atlanta, Georgia "If it's not broke....tweak it" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
