Previous Thread
Next Thread
Print Thread
Rate Thread
#261068 10/21/2003 9:14 AM
Joined: Feb 2002
Posts: 950
Hacker
Hacker
Offline
Joined: Feb 2002
Posts: 950
After all these years I'm still learning that Apache's own configuration can dramatically effect server performance. In this case, more so than the MySQL configuration.

KeepAliveTimeout on my server was set to 8 seconds. Since I have this signature script doing 1,750,000+ impressions a day, I had a boatload of connections in "waiting" mode - 256 of them in fact. 256 * 8MB httpd process is 2GB itself with no room for MySQL to run.

I lowered by KeepAliveTimeout to 2 and it had a dramatic effect on my server performance. I'm lowered the number of servers than can run down to 180 to fit within my membery limits and also considering dropping my timeout limit to 1.

Since doing this I've seen a dramatic reduction in the use of memory by Apache processes and a boot in site performace (pages taking 2.5 seconds to process are now taking half that time).

So, while tuning MySQL, you will probably want to look at your Apache configuration, too.

Sponsored Links
Joined: Oct 2000
Posts: 2,223
Veteran
Veteran
Offline
Joined: Oct 2000
Posts: 2,223
It's a system. It all has to work well together as a unit.

I didn't want to muddy the waters in in your persistant = bad thread because in most cases that is true, but as you get your system's parts more into tune with each other it doesn't HAVE to be bad. You've dramatically reduced the number of apache proceses. If you go back and balance that number with the number of MySQL connections allowed, and balance all of that to the amount of memory you have to use you might find they work ok for you.

As an aside, look at your apache. Have you compiled your modules in or are they loading as a DSO? Are you loading modules that you don't need? Memory waster there if you are. @8megs per my guess is you're not loading a lot of unused modules, but it's worth checking. A meg here, a meg there......



Picture perfect penmanship here.
Joined: May 2003
Posts: 8
Newbie
Newbie
Offline
Joined: May 2003
Posts: 8
[]PhotoPost said:I lowered by KeepAliveTimeout to 2 and it had a dramatic effect on my server performance.... and also considering dropping my timeout limit to 1.[/]

Just disable KeepAlive:
http://www.slogic.org/manual/ibm/9atperf.htm


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Posts: 70
Joined: January 2007
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221218)