Re: Windows Server Getting Slow

I think you should have benchmarked (mybench) your production server.
You should also be using a monitoring tool (mytop).

Possible problems

1. Check the stored procedures. In my opinion, I would say that not all
queries should be stored procedures. There must be a balance in using a
stored procedure or not. Stored procedures add some load to your server.
2. Check if indexes are used on the queries used.
3. Check the variables you have set on my.ini (configuration file) like
buffer size, maximum connections, etc...  Gradually increase it by a
factor of 10 or 20 and see the changes with a monitoring tool.
4. Check if network is saturated.
5. Check the server's hardware like RAM, etc..

> Subject: > Windows Server Getting Slow
> From: > Jangita <[email protected]>
> Date: > Tue, 22 Aug 2006 14:39:12 +0300
> To: > [email protected]
> 
> To: > [email protected]
> 
> Message-ID: > <[email protected]>
> MIME-Version: > 1.0
> Content-Type: > text/plain; charset=ISO-8859-1; format=flowed
> Content-Transfer-Encoding: > 7bit
> 
> 
> Hello all,
> 
> I have a dell intel xeon 80gb hdd and 1mb ram running windows 2003
> server and i have installed mysql and configured it in the "dedicated
> server" mode. here is my problem
> 
> i have about 60 connections from the lan which connect to the database
> and run querries using storedprocs. when i get to about 30 connections
> the server becomes very *slow* and hangs and sometimes is totally
> unresponsive. needless to say the clients too become very slow
> 
> i kind of thought 30 or even up to 100 connections on a windows 2003
> server running [only] mysql should be able to handle such connections
> with ease, another symptom is the clients take longer and longer to
> connect to the mysql server.
> 
> i had to break the network into computers of 15 each and install several
> database servers to serve the clusters - since something needed to be
> done in a rush; i wouldnt want to deploy like this, it beats the purpose
> of what i want to do.
> 
> from the server administrator i see most of the connections in the state
> unauthenticated user with very few (about 4 or 5) connected to the
> database.
> 
> i must be doing something wrong; can anyone help me?
> 
> thanks
> 
> j

-----BEGIN PGP SIGNATURE-----
Comment: GPG Public Key: https://www.biglumber.com/x/web?qs=0x4A256EC8
Comment: GPG Public Key: http://www.lorztech.com/GPG.txt
Comment: Google, Skype, Yahoo ID: michaellouieloria

iQEVAwUBROux9LXBHi2y3jwfAQrenQgAhtLyTCwzjRb8BbdlTyt7ADO09aJvQn2/
9plcVXz+N5pRIj8ta50Ms0TfwRE4YBH/QirGp+epPbTNb8eNJdvuqBiqF/365M6Y
NbjKJIGhINzpH7sHlfK1h+Ld/jwaDiKd4RL8tzRbc9mzS8wCxe8ThW/u3HTGb8er
pjhZaO6itA2I+C6Ja+bf6caY8XUQ9R8zxFPSzWl+qYgmyX+bfa9b8xC7QTMp8GWl
9Ts/6LQCDvHzMjW1DBruWtoYgxcHE4rWkOU4cgJK9cp8IMJ2oRiDItUljj9ZUQpc
m4xenPDmyYUDogIuIbj4VRC5G7dAa4p1pNAAljNmMMAmWyB/X2dojQ==
=cv2u
-----END PGP SIGNATURE-----