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!! -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
> 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?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? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Check to see if you have write-back caching enabled in the RAID configuration. DZ On May 3, 10:11 am, Philip Hallstrom <r...-SUcgGwS4C16SUMMaM/qcSw@public.gmane.org> wrote:> > 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? > > 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?--~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---