Author: paul
Date: 2009-09-05 18:37:41 +0200 (Sat, 05 Sep 2009)
New Revision: 16479
Log:
r44257@frost: paul | 2009-09-05 11:34:47 -0500
Update "too many connections" section per James
Modified:
trunk/refman-4.1/errors-problems.xml
trunk/refman-5.0/errors-problems.xml
trunk/refman-5.1/errors-problems-core.xml
trunk/refman-5.4/errors-problems-core.xml
trunk/refman-6.0/errors-problems.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:26218
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:25547
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:44229
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
+ 07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/mysqldoc/trunk:26218
07c7e7b4-24e3-4b51-89d0-6dc09fec6bec:/mysqldoc-local/trunk:25547
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:43968
4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/trunk:44480
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:44257
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:39036
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/trunk:39546
Modified: trunk/refman-4.1/errors-problems.xml
===================================================================
--- trunk/refman-4.1/errors-problems.xml 2009-09-05 00:03:38 UTC (rev 16478)
+++ trunk/refman-4.1/errors-problems.xml 2009-09-05 16:37:41 UTC (rev 16479)
Changed blocks: 1, Lines Added: 17, Lines Deleted: 6; 1765 bytes
@@ -1055,14 +1055,25 @@
<para>
The maximum number of connections MySQL can support depends on
- the quality of the thread library on a given platform. Linux
- or Solaris should be able to support 500–1000
- simultaneous connections, depending on how much RAM you have
- and what your clients are doing. Static Linux binaries
- provided by Sun Microsystems, Inc. can support up to 4000
- connections.
+ the quality of the thread library on a given platform, the
+ amount of RAM available, how much RAM is used for each
+ connection, the workload from each connection, and the desired
+ response time. Linux or Solaris should be able to support at
+ 500–1000 simultaneous connections routinely and as many
+ as 10,000 connections if you have many gigabytes of RAM
+ available and the workload from each is low or the response
+ time target undemanding. Windows is limited to (open tables
+ × 2 + open connections) < 2048 due to the Posix
+ compatibility layer used on that platform.
</para>
+ <para>
+ Increasing <option role="mysqld">open-files-limit</option> may
+ be necessary. Also see <xref linkend="linux-post-install"/>,
+ for how to raise the operating system limit on how many
+ handles can be used by MySQL.
+ </para>
+
</section>
<section id="out-of-memory">
Modified: trunk/refman-5.0/errors-problems.xml
===================================================================
--- trunk/refman-5.0/errors-problems.xml 2009-09-05 00:03:38 UTC (rev 16478)
+++ trunk/refman-5.0/errors-problems.xml 2009-09-05 16:37:41 UTC (rev 16479)
Changed blocks: 1, Lines Added: 17, Lines Deleted: 6; 1765 bytes
@@ -1055,14 +1055,25 @@
<para>
The maximum number of connections MySQL can support depends on
- the quality of the thread library on a given platform. Linux
- or Solaris should be able to support 500–1000
- simultaneous connections, depending on how much RAM you have
- and what your clients are doing. Static Linux binaries
- provided by Sun Microsystems, Inc. can support up to 4000
- connections.
+ the quality of the thread library on a given platform, the
+ amount of RAM available, how much RAM is used for each
+ connection, the workload from each connection, and the desired
+ response time. Linux or Solaris should be able to support at
+ 500–1000 simultaneous connections routinely and as many
+ as 10,000 connections if you have many gigabytes of RAM
+ available and the workload from each is low or the response
+ time target undemanding. Windows is limited to (open tables
+ × 2 + open connections) < 2048 due to the Posix
+ compatibility layer used on that platform.
</para>
+ <para>
+ Increasing <option role="mysqld">open-files-limit</option> may
+ be necessary. Also see <xref linkend="linux-post-install"/>,
+ for how to raise the operating system limit on how many
+ handles can be used by MySQL.
+ </para>
+
</section>
<section id="out-of-memory">
Modified: trunk/refman-5.1/errors-problems-core.xml
===================================================================
--- trunk/refman-5.1/errors-problems-core.xml 2009-09-05 00:03:38 UTC (rev 16478)
+++ trunk/refman-5.1/errors-problems-core.xml 2009-09-05 16:37:41 UTC (rev 16479)
Changed blocks: 1, Lines Added: 17, Lines Deleted: 6; 1780 bytes
@@ -1059,14 +1059,25 @@
<para>
The maximum number of connections MySQL can support depends on
- the quality of the thread library on a given platform. Linux
- or Solaris should be able to support 500–1000
- simultaneous connections, depending on how much RAM you have
- and what your clients are doing. Static Linux binaries
- provided by Sun Microsystems, Inc. can support up to 4000
- connections.
+ the quality of the thread library on a given platform, the
+ amount of RAM available, how much RAM is used for each
+ connection, the workload from each connection, and the desired
+ response time. Linux or Solaris should be able to support at
+ 500–1000 simultaneous connections routinely and as many
+ as 10,000 connections if you have many gigabytes of RAM
+ available and the workload from each is low or the response
+ time target undemanding. Windows is limited to (open tables
+ × 2 + open connections) < 2048 due to the Posix
+ compatibility layer used on that platform.
</para>
+ <para>
+ Increasing <option role="mysqld">open-files-limit</option> may
+ be necessary. Also see <xref linkend="linux-post-install"/>,
+ for how to raise the operating system limit on how many
+ handles can be used by MySQL.
+ </para>
+
</section>
<section id="out-of-memory">
Modified: trunk/refman-5.4/errors-problems-core.xml
===================================================================
--- trunk/refman-5.4/errors-problems-core.xml 2009-09-05 00:03:38 UTC (rev 16478)
+++ trunk/refman-5.4/errors-problems-core.xml 2009-09-05 16:37:41 UTC (rev 16479)
Changed blocks: 1, Lines Added: 17, Lines Deleted: 6; 1780 bytes
@@ -1058,14 +1058,25 @@
<para>
The maximum number of connections MySQL can support depends on
- the quality of the thread library on a given platform. Linux
- or Solaris should be able to support 500–1000
- simultaneous connections, depending on how much RAM you have
- and what your clients are doing. Static Linux binaries
- provided by Sun Microsystems, Inc. can support up to 4000
- connections.
+ the quality of the thread library on a given platform, the
+ amount of RAM available, how much RAM is used for each
+ connection, the workload from each connection, and the desired
+ response time. Linux or Solaris should be able to support at
+ 500–1000 simultaneous connections routinely and as many
+ as 10,000 connections if you have many gigabytes of RAM
+ available and the workload from each is low or the response
+ time target undemanding. Windows is limited to (open tables
+ × 2 + open connections) < 2048 due to the Posix
+ compatibility layer used on that platform.
</para>
+ <para>
+ Increasing <option role="mysqld">open-files-limit</option> may
+ be necessary. Also see <xref linkend="linux-post-install"/>,
+ for how to raise the operating system limit on how many
+ handles can be used by MySQL.
+ </para>
+
</section>
<section id="out-of-memory">
Modified: trunk/refman-6.0/errors-problems.xml
===================================================================
--- trunk/refman-6.0/errors-problems.xml 2009-09-05 00:03:38 UTC (rev 16478)
+++ trunk/refman-6.0/errors-problems.xml 2009-09-05 16:37:41 UTC (rev 16479)
Changed blocks: 1, Lines Added: 17, Lines Deleted: 6; 1765 bytes
@@ -1056,14 +1056,25 @@
<para>
The maximum number of connections MySQL can support depends on
- the quality of the thread library on a given platform. Linux
- or Solaris should be able to support 500–1000
- simultaneous connections, depending on how much RAM you have
- and what your clients are doing. Static Linux binaries
- provided by Sun Microsystems, Inc. can support up to 4000
- connections.
+ the quality of the thread library on a given platform, the
+ amount of RAM available, how much RAM is used for each
+ connection, the workload from each connection, and the desired
+ response time. Linux or Solaris should be able to support at
+ 500–1000 simultaneous connections routinely and as many
+ as 10,000 connections if you have many gigabytes of RAM
+ available and the workload from each is low or the response
+ time target undemanding. Windows is limited to (open tables
+ × 2 + open connections) < 2048 due to the Posix
+ compatibility layer used on that platform.
</para>
+ <para>
+ Increasing <option role="mysqld">open-files-limit</option> may
+ be necessary. Also see <xref linkend="linux-post-install"/>,
+ for how to raise the operating system limit on how many
+ handles can be used by MySQL.
+ </para>
+
</section>
<section id="out-of-memory">
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r16479 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-5.4 refman-6.0 | paul.dubois | 5 Sep |
