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. ;-)

 

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

 

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

 

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

 

i have noticed the difference already...ill let you know if i notice anymore....

thank you mark

 

I think you should reboot the box.

 

Yes, it's definately faster.

 

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

 

I feel the diff man!! Tweaking helps!

Krunal

 

yep, the speeds are MUCH quicker now, good job Mark

 

yep it's quick!!

 

lots quicker thanks a bunch...

 

i dont know....it used to be slow for me, but then it got faster, its on and off

 

Alright we got the point. "It's faster."

Closed.