Gentoo Websites Logo
Go to: Gentoo Home Documentation Forums Lists Bugs Planet Store Wiki Get Gentoo!
Bug 124453 - MySQL max_connections should be set to same as MaxClients in apache httpd.conf
Summary: MySQL max_connections should be set to same as MaxClients in apache httpd.conf
Status: RESOLVED INVALID
Alias: None
Product: Gentoo Linux
Classification: Unclassified
Component: [OLD] Server (show other bugs)
Hardware: All Linux
: High enhancement (vote)
Assignee: Gentoo Linux MySQL bugs team
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-02-28 12:21 UTC by Jonas Jonsson
Modified: 2007-05-11 07:49 UTC (History)
0 users

See Also:
Package list:
Runtime testing required: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Jonas Jonsson 2006-02-28 12:21:40 UTC
Hi..

When installing MySQL the default max_connections is set to 100 but should be the same as the MaxClients for Apache, 150. Since there are many users that use a LAMP solution and the there should be enough MySQL connections for the Apache...

Is this a bad idea?
Comment 1 Robin Johnson archtester Gentoo Infrastructure gentoo-dev Security 2007-05-11 07:49:04 UTC
Yes it's a bad idea.
The apache maxclients needs to be higher because apache also serves static content and alternatively, your application could be using pconnect and sharing connections.

Really, if this is a problem with your system, change the setting yourself, as it's specific to your application.