site slow?
May 30, 2004, 01:45 PM
#31
Evolved Member
iTrader: (2)
Join Date: Mar 2004
Location: TPA
Posts: 664
Likes: 0
Received 0 Likes
on
0 Posts
Duplexing issues can cause this sort of behavior, but it would be more perevelant. Anytime the server (nic) and the router negotiate at the wrong speed. A duplexing issue is simple to test. Get on the router/switch that is connected to the server and send a large amount of large ping packets to another host on the same VLAN. If you see randonm dropped packets it usually leads to duplexing.
I also do this for a living so if you need anything please feel free to PM me. I can walk you through checking the routing (if you have the enable password) or I can help you go through the server/nic settings. You may want to set up a sniffer trace between the web server and the SQL server to check for timeouts there. Perhaps you have a stored procedure that is less than optimized. I seem to be seeing the latency issue come and go; so that could be explained by a bad DB call.
Anyway, let me know if you need anything. ;-)
I also do this for a living so if you need anything please feel free to PM me. I can walk you through checking the routing (if you have the enable password) or I can help you go through the server/nic settings. You may want to set up a sniffer trace between the web server and the SQL server to check for timeouts there. Perhaps you have a stored procedure that is less than optimized. I seem to be seeing the latency issue come and go; so that could be explained by a bad DB call.
Anyway, let me know if you need anything. ;-)
May 30, 2004, 07:39 PM
#32
Thanks guys. My pm is currently disabled, but you can always email me using the form. I checked to see if there were issues with anyone else on Mzima's network, but I didn't find anything.
From checking the db, I find a number of tables being locked at times and they are the most commonly queried ones. This includes the user table, post, thread, and session. The locked queries are ones from the forum software, which I never actually wrote. I think this is a configuration issue for the MySQL database. I'm trying to find out what settings to use to optimize things and prevent these table locking issues.
We did actually have a nic issue ealier on and this caused a lot of connection errors. The nic card just seemed to die. We switched to the secondary card and everything was working much better. That could have something to do with it. I'm not much of a tech myself, but if you have any steps that I should pass to the NOC to try out, that would be great!
Mark
From checking the db, I find a number of tables being locked at times and they are the most commonly queried ones. This includes the user table, post, thread, and session. The locked queries are ones from the forum software, which I never actually wrote. I think this is a configuration issue for the MySQL database. I'm trying to find out what settings to use to optimize things and prevent these table locking issues.
We did actually have a nic issue ealier on and this caused a lot of connection errors. The nic card just seemed to die. We switched to the secondary card and everything was working much better. That could have something to do with it. I'm not much of a tech myself, but if you have any steps that I should pass to the NOC to try out, that would be great!
Mark
May 30, 2004, 08:08 PM
#33
Newbie
Join Date: May 2004
Posts: 2
Likes: 0
Received 0 Likes
on
0 Posts
Hello,
Just wanted to drop a note here to mention that the issue is not with the network. The servers routinely are hitting decent Mbit/s speeds.
Here is an example:
3.14MB/s is around 25Mbit/s so the speed is very good.
The issue isn't with the network. It appears to be with the way the script is interacting with the mysql server. The loads on the servers are also low, but there is a lot of tables being locked (something we cannot prevent) as it deals with the script.
-Steven
Just wanted to drop a note here to mention that the issue is not with the network. The servers routinely are hitting decent Mbit/s speeds.
Here is an example:
root@database1 [~]# wget http://mirrors.kernel.org/fedora/cor...i386-disc1.iso
--23:00:48-- http://mirrors.kernel.org/fedora/cor...i386-disc1.iso
=> `yarrow-i386-disc1.iso.1'
Resolving mirrors.kernel.org... done.
Connecting to mirrors.kernel.org[204.152.189.120]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 660,340,736 [text/plain]
14% [====> ] 96,994,744 3.14M/s ETA 02:51
root@database1 [~]
--23:00:48-- http://mirrors.kernel.org/fedora/cor...i386-disc1.iso
=> `yarrow-i386-disc1.iso.1'
Resolving mirrors.kernel.org... done.
Connecting to mirrors.kernel.org[204.152.189.120]:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 660,340,736 [text/plain]
14% [====> ] 96,994,744 3.14M/s ETA 02:51
root@database1 [~]
The issue isn't with the network. It appears to be with the way the script is interacting with the mysql server. The loads on the servers are also low, but there is a lot of tables being locked (something we cannot prevent) as it deals with the script.
-Steven
Last edited by ihsteven; May 30, 2004 at 08:10 PM.
Jun 1, 2004, 02:15 PM
#37
Evolved Member
iTrader: (1)
Join Date: Aug 2003
Location: .
Posts: 1,302
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by KK
Ok, I found the issue. It was with the gallery and review scripts. I hacked them to fix the issue, but I'd like to see if other people have seen a speed up.
Mark
Mark
Jun 2, 2004, 05:42 PM
#38
Also, we enabled a feature that was removed for some odd reason. We're compressing pages to reduce their size for everyone... uses less bandwidth and makes for a quicker download 
Mark
Mark
Thread
Thread Starter
Forum
Replies
Last Post
CweSt eVo
Site Feedback / Suggestions
6
Apr 29, 2004 08:53 PM