Hi Paul Dubois, we late to answers due to administration problems. > MySQL doesn't have anything to do with HTTP connections. Next is an extract of MySQL documentation (MySQL reference manual up to Version 4.1.0-alpha).
...In other words, this value is the size of the listen queue for incoming TCP/IP connections. Your operating system has its own limit on the size of this queue. The manual page for the Unix listen(2) system call should have more details. Check your OS documentation for the maximum value for this variable. Attempting to set back_log higher than your operating system limit will be ine®ective. And , in relation to back_log=600 variable in my my.cnf file, I want to know if there is an effect to setting this variable with a value higher that system parameter listen queue size ? This response will help to determine the causes of bugs which appears in our web site as soon as apache HTTP processes which interact with MySQL server tends to higher value like 300-400 process . Think in advance -----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: mercredi 30 juillet 2003 04:44 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: how listen queue size affect MySQL on RedHat At 14:53 +0000 7/29/03, <[EMAIL PROTECTED]> wrote: >Hi all, >i want to know if the system parameter somaxconn affect the >capabalities of MySQL to maintain more than five thousands of HTTP >connections ? If so , any clarifications may help. >think in advance MySQL doesn't have anything to do with HTTP connections. What are you really asking? -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
