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
2  2266  Atli 5,058
Recognized Expert Expert
I've edited the thread's title to better describe it's contents.
Please read the Posting Guidlines before posting Moderator
I am more of a software guy so this is not really my area, but I would think the connection between the SQL server and the IIS server is the problem.
I mean, if the SQL server is running fine, and the IIS server is also running fine, and you know there are supposed to work fine together, the problem must be somwhere on the path between them.
How are they linked together?
Sorry about the title, I was interrupted probably a half dozen times while typing this up, and now realize that beyond the poor title, I left out some other test results.
I was in agreement on the issue being the network connection between the two machines, but there was another test we ran that eliminates that possibility.
We installed IIS on the machine that is hosting the DB so we could try the scripts without the network communication getting involved and it was still as slow as it was on the two machine tests.
I really am sorry I didn't get that in the first post.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: Phil Powell |
last post by:
I've read some online resources that utilize various MySQL
command-line actions to migrate data from Access to MySQL.
The situation is this: a group of co-workers of mine will be using an
Access db in a shared source (for now, a directory.. ???) to be able
to generate reports on the fly. What they want to do is to be able to
migrate that data to a MySQL db instance that currently exists on a
different server.
What would be the best...
|
by: ZR |
last post by:
I am writing two applications which needs to (among other things)
communicate through network, so one of them is a client and the other one is
a server. I have used asynchronous socket examples found at
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconblockingclientsocketexample.asp
as templates (they have to be asynchronous, because application must not
freeze if connection fails). I have converted the...
|
by: Ike |
last post by:
Let's say I have a MySQL 4.12 database, opened to the internet on
111.111.111.111 allowing all incoming and outgoing ports. I have a username
and password setup, which CAN connect to this database, from
222.222.222.222.
Also on 222.222.222.222, which is running Tomcat, I have a Java servlet,
called, say, servlet.class in WEB-INF/classes. servlet.class has permissions
755, as does WEB-INF/classes.
Additionally, I have on...
|
by: courtney.machi |
last post by:
Hello,
I am trying to connect to a remote mysql server through php. Here's the
code:
mysql_connect("my.hostname.edu", "username", "password") or die
(mysql_error());
mysql_select_db("db_name") or die ("unable to select
db".mysql_error());
$r1 = mysql_query('SELECT * FROM table') ;
|
by: dronkanoki |
last post by:
I am attempting to set up myODBC 3.51 on Win XP Pro to a remote MySQL Linux server. I get the following error:
Access denied for user: 'username@ipaddress.serviceprovider.net' (Using password: YES)
I had MySQL installed locally for testing, and myODBC worked fine. All the other apps I use locally (Dreamweaver, PHPmyAdmin, MySQL Front) work great on the remote server with the same login info.
This is my thought (patience, please). My...
| | |
by: ELINTPimp |
last post by:
Hello folks,
Having a bit of trouble getting PDO to connect to my remote MySQL
database...
PHP: 5.2.1, w/ php_mysql, php_pdo, php_pdo_mysql; error reporting is
on, ERROR_STRICT (development server)
OS: Windows 2003 R2 w/ SP2
Web Server: IIS 6, PHP installed as ISAPI
MySQL: 3.23.54 on remote Solaris 9 9/04
|
by: Jerim |
last post by:
I have a script on one server, trying to access the MySQL database on
another server. The server with the script is on an outside network,
hosted with another company. The MySQL server is here in the
office;behind a firewall. Script works fine when it is on the local
machine, but when I moved it to the offsite webserver it gives me:
Warning: mysql_connect() : Lost connection to
MySQL server during query in...
|
by: jmohan |
last post by:
Dear Sir/Madam,
I develop a website in asp.net with c#. And also, I develop a toolbar in the toolbar studio separately.
Aim of the Website: Enabling the visitors to become a member of our webiste
by downloading the toolbar from our website.
After the member downloads the toolbar, The toolbar is added to the ie browser. The member can get the facilities such as searching, weather online, internet radio,etc., The toolbar includes a...
|
by: xoise |
last post by:
Warning: mysql_connect() : Lost connection to MySQL server at 'reading initial communication packet', system error: 113 in /webs/sites/monetized.com/includes/mysql_connect.inc.php on line 2
Lost connection to MySQL server at 'reading initial communication packet', system error: 113
I'm receiving the above error whenever trying to connect to my database server from any remote server. It WAS working before without any problems. I can't think...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
| | |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
