Bug 124453

Summary:	MySQL max_connections should be set to same as MaxClients in apache httpd.conf
Product:	Gentoo Linux	Reporter:	Jonas Jonsson <jonas>
Component:	[OLD] Server	Assignee:	Gentoo Linux MySQL bugs team <mysql-bugs>
Status:	RESOLVED INVALID
Severity:	enhancement
Priority:	High
Version:	unspecified
Hardware:	All
OS:	Linux
Whiteboard:
Package list:		Runtime testing required:	---

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

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.