I have 3 boxes, each running Ubuntu Feisty. All of them are AMD64, one of them is in 32b mode, other two are 64b mode. All have the same filesystem type, and roughly the same hardware config. Each has the ruby mysql gem installed. I have a script that fills a database with random data for testing. Its mainly a lot of inserts and takes about 30 to run on 2 of the boxes. On one of them (a 64b mode machine) it uses *very little CPU* and takes FOREVER to run. I benchmarked the disk and its faster than the other HDs (this was done with repeated writes to a sqlite db), however this machine is the only one with a raid configuration. Can anyone think of anything I should check out to fix this problem? Thanks!!
on 2007-05-03 04:30
on 2007-05-03 18:59
> machine is the only one with a raid configuration. > > Can anyone think of anything I should check out to fix this problem? Any chance the *C* .so library for that mysql gem isn't installed on that last box? I mean, the directory might be there and it might seem like it's installed, but is the .so lib file there?
on 2007-05-03 19:31
Check to see if you have write-back caching enabled in the RAID configuration. DZ