Good morning!
I am on a project where we are migrating a site running on perl and mysql on IIS.
The current configuration is with everything on one server, both IIS and MySQL.
The new configuration has IIS on one server, and MySQL on another, both machines are approximately equivalent to the old (aka current) box power wise..
The problem I am having is that a given script (granting it is based on an ugly query with 7 joins) runs in a few seconds on the old box, but takes easily 10 times as long on the new system.
the biggest difference is that the new box is running MySQL 5.0 and the old box is on MySQL 4.1.7, however I dont believe that is the cause of the speed issues, as we slapped the site on yet a third box, which is running MYSQL 5.0, and it is returning the data very snappily (a few seconds).
A "first" pass at trying to make it work better was to increase the buffer sizes. I can not report what they set them to, but as I understand they have "maxed" out the buffers to try to speed it up (doing so, cut time to run backups of the DB by about half).
I am not the admin for any of these machines, (ahh, Sarbanes Oxley, wouldn't it be nice if SOX were to die a horrible fiery death?) but I can ask the admins anything, if anyone might have a suggestion as to what we could chase to determine what is wrong. I have not had to deal with something like this, previously, so any advice on what we might try would be a huge help!
I am sure I am leaving out all kinds of useful information, but this is the complete rundown of what I currently know (sorry, I am in a bit of a third person situation here, but I have decided to peruse it myself rather than continuing to wait on others who know more than I (besides, thats how I end up knowing more than them!))
Thanks!
Adam McCormack
I am on a project where we are migrating a site running on perl and mysql on IIS.
The current configuration is with everything on one server, both IIS and MySQL.
The new configuration has IIS on one server, and MySQL on another, both machines are approximately equivalent to the old (aka current) box power wise..
The problem I am having is that a given script (granting it is based on an ugly query with 7 joins) runs in a few seconds on the old box, but takes easily 10 times as long on the new system.
the biggest difference is that the new box is running MySQL 5.0 and the old box is on MySQL 4.1.7, however I dont believe that is the cause of the speed issues, as we slapped the site on yet a third box, which is running MYSQL 5.0, and it is returning the data very snappily (a few seconds).
A "first" pass at trying to make it work better was to increase the buffer sizes. I can not report what they set them to, but as I understand they have "maxed" out the buffers to try to speed it up (doing so, cut time to run backups of the DB by about half).
I am not the admin for any of these machines, (ahh, Sarbanes Oxley, wouldn't it be nice if SOX were to die a horrible fiery death?) but I can ask the admins anything, if anyone might have a suggestion as to what we could chase to determine what is wrong. I have not had to deal with something like this, previously, so any advice on what we might try would be a huge help!
I am sure I am leaving out all kinds of useful information, but this is the complete rundown of what I currently know (sorry, I am in a bit of a third person situation here, but I have decided to peruse it myself rather than continuing to wait on others who know more than I (besides, thats how I end up knowing more than them!))
Thanks!
Adam McCormack
Comment