Re: Windows Server Getting Slow
Jangita <[email protected]>
| Newsgroups | gmane.comp.db.mysql.windows |
|---|---|
| Message-ID | <[email protected]> |
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 <[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 > -- PO Box 26453 00504 Nairobi, Kenya. TEL: +254722996532 [email protected] -- MySQL Windows Mailing List For list archives: http://lists.mysql.com/win32 To unsubscribe: http://lists.mysql.com/[email protected]