Windows Server Getting Slow

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

--
PO Box 26453 00504
Nairobi, Kenya.
TEL: +254722996532
jangita@jangita.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org

Re: Windows Server Getting Slow

--------------enig296C21793DFE42CC5A9BCA5F
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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
> Date: > Tue, 22 Aug 2006 14:39:12 +0300
> To: > win32@lists.mysql.com
>=20
> To: > win32@lists.mysql.com
>=20
> Message-ID: > <44EAECE0.2020000@jangita.com>
> MIME-Version: > 1.0
> Content-Type: > text/plain; charset=3DISO-8859-1; format=3Dflowed
> Content-Transfer-Encoding: > 7bit
>=20
>=20
> Hello all,
>=20
> 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
>=20
> 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
>=20
> 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.
>=20
> i had to break the network into computers of 15 each and install severa=
l
> 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 purpos=
e
> of what i want to do.
>=20
> from the server administrator i see most of the connections in the stat=
e
> unauthenticated user with very few (about 4 or 5) connected to the
> database.
>=20
> i must be doing something wrong; can anyone help me?
>=20
> thanks
>=20
> j


--------------enig296C21793DFE42CC5A9BCA5F
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----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

iQEVAwUBROux9LXBHi2y3jwfAQrenQgAhtLyTCwzjRb8BbdlTyt7ADO09aJv Qn2/
9plcVXz+N5pRIj8ta50Ms0TfwRE4YBH/QirGp+epPbTNb8eNJdvuqBiqF/36 5M6Y
NbjKJIGhINzpH7sHlfK1h+Ld/jwaDiKd4RL8tzRbc9mzS8wCxe8ThW/u3HTG b8er
pjhZaO6itA2I+C6Ja+bf6caY8XUQ9R8zxFPSzWl+qYgmyX+bfa9b8xC7QTMp 8GWl
9Ts/6LQCDvHzMjW1DBruWtoYgxcHE4rWkOU4cgJK9cp8IMJ2oRiDItUljj9Z UQpc
m4xenPDmyYUDogIuIbj4VRC5G7dAa4p1pNAAljNmMMAmWyB/X2dojQ==
=cv2u
-----END PGP SIGNATURE-----

--------------enig296C21793DFE42CC5A9BCA5F--

Re: Windows Server Getting Slow

Thanks for the points; i think its network saturation.
A symptom is the mysqld-nt goes to 100 percent and the server becomes
*very* slow. I suspect bad querry planning.

Michael Louie Loria wrote:
> 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
>> Date: > Tue, 22 Aug 2006 14:39:12 +0300
>> To: > win32@lists.mysql.com
>>
>> To: > win32@lists.mysql.com
>>
>> Message-ID: > <44EAECE0.2020000@jangita.com>
>> 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
>

--
PO Box 26453 00504
Nairobi, Kenya.
TEL: +254722996532
jangita@jangita.com

--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org