Author: paul
Date: 2007-10-25 21:26:24 +0200 (Thu, 25 Oct 2007)
New Revision: 8325
Log:
r26184@frost: paul | 2007-10-25 14:25:26 -0500
connect_timeout default increased from 5 to 10 seconds.
Bug#28359.
Modified:
trunk/dynamic-docs/changelog/mysqld.xml
trunk/dynamic-docs/command-optvars/mysqld.xml
trunk/refman-4.1/dba-core.xml
trunk/refman-4.1/errors-problems.xml
trunk/refman-5.0/dba-core.xml
trunk/refman-5.0/errors-problems.xml
trunk/refman-5.1/dba-core.xml
trunk/refman-5.1/errors-problems-core.xml
trunk/refman-5.2/dba-core.xml
trunk/refman-5.2/errors-problems.xml
Property changes on: trunk
___________________________________________________________________
Name: svk:merge
- 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:31592
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:26181
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:20005
+ 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:31592
7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:26184
b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218
bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:20005
Modified: trunk/dynamic-docs/changelog/mysqld.xml
===================================================================
--- trunk/dynamic-docs/changelog/mysqld.xml 2007-10-25 18:35:18 UTC (rev 8324)
+++ trunk/dynamic-docs/changelog/mysqld.xml 2007-10-25 19:26:24 UTC (rev 8325)
Changed blocks: 1, Lines Added: 30, Lines Deleted: 0; 1018 bytes
@@ -140176,4 +140176,34 @@
</logentry>
+ <logentry entrytype="feature">
+
+ <tags>
+ <manual type="connect_timeout"/>
+ </tags>
+
+ <bugs>
+ <fixes bugid="28359"/>
+ </bugs>
+
+ <versions>
+ <version ver="5.0.52"/>
+ <version ver="5.1.23"/>
+ </versions>
+
+ <message>
+
+ <para>
+ The default value of the <literal>connect_timeout</literal>
+ system variable was increased from 5 to 10 seconds. This might
+ help in cases where clients frequently encounter errors of the
+ form <literal>Lost connection to MySQL server at
+ '<replaceable>XXX</replaceable>', system error:
+ <replaceable>errno</replaceable></literal>.
+ </para>
+
+ </message>
+
+ </logentry>
+
</changelog>
Modified: trunk/dynamic-docs/command-optvars/mysqld.xml
===================================================================
--- trunk/dynamic-docs/command-optvars/mysqld.xml 2007-10-25 18:35:18 UTC (rev 8324)
+++ trunk/dynamic-docs/command-optvars/mysqld.xml 2007-10-25 19:26:24 UTC (rev 8325)
Changed blocks: 1, Lines Added: 19, Lines Deleted: 1; 976 bytes
@@ -6160,12 +6160,30 @@
<vartype isdynamic="yes" class="system" format="connect_timeout" scope="global"/>
</types>
- <values vartype="numeric" platform="all">
+ <values vartype="numeric" platform="all" outversion="5.0.52">
<value default="5"/>
</values>
+ <values vartype="numeric" platform="all" inversion="5.0.52">
+
+ <value default="10"/>
+
+ </values>
+
+ <values vartype="numeric" platform="all" outversion="5.1.23">
+
+ <value default="5"/>
+
+ </values>
+
+ <values vartype="numeric" platform="all" inversion="5.1.23">
+
+ <value default="10"/>
+
+ </values>
+
<versions>
<manual version="4.1"/>
<manual version="5.0"/>
Modified: trunk/refman-4.1/dba-core.xml
===================================================================
--- trunk/refman-4.1/dba-core.xml 2007-10-25 18:35:18 UTC (rev 8324)
+++ trunk/refman-4.1/dba-core.xml 2007-10-25 19:26:24 UTC (rev 8325)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 1; 995 bytes
@@ -3746,8 +3746,17 @@
<para>
The number of seconds that the <command>mysqld</command>
server waits for a connect packet before responding with
- <literal>Bad handshake</literal>.
+ <literal>Bad handshake</literal>. The default value is 5
+ seconds.
</para>
+
+ <para>
+ Increasing the <literal>connect_timeout</literal> value
+ might help if clients frequently encounter errors of the
+ form <literal>Lost connection to MySQL server at
+ '<replaceable>XXX</replaceable>', system error:
+ <replaceable>errno</replaceable></literal>.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-4.1/errors-problems.xml
===================================================================
--- trunk/refman-4.1/errors-problems.xml 2007-10-25 18:35:18 UTC (rev 8324)
+++ trunk/refman-4.1/errors-problems.xml 2007-10-25 19:26:24 UTC (rev 8325)
Changed blocks: 9, Lines Added: 36, Lines Deleted: 8; 4024 bytes
@@ -29,7 +29,7 @@
<para>
The MySQL Enterprise Monitor provides a <quote>Virtual DBA</quote>
- to assist with problem solving. For more information see
+ to assist with problem solving. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -704,6 +704,34 @@
</section>
+ <section id="error-lost-connection">
+
+ <title><literal>Lost connection to MySQL server</literal></title>
+
+ <indexterm>
+ <primary>errors</primary>
+ <secondary>lost connection</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>problems</primary>
+ <secondary>lost connection errors</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>lost connection errors</primary>
+ </indexterm>
+
+ <para>
+ An error of the form <literal>Lost connection to MySQL server
+ at '<replaceable>XXX</replaceable>', system error:
+ <replaceable>errno</replaceable></literal> can indicate that
+ the server's <literal>connect_timeout</literal> value is set
+ too low.
+ </para>
+
+ </section>
+
<section id="old-client">
<title><literal>Client does not support authentication protocol</literal></title>
@@ -962,7 +990,7 @@
Subscribers to the MySQL Enterprise Monitor receive advice
on dynamically configuring the
<literal>max_connections</literal> variable — avoiding
- failed connection attempts. For more information see
+ failed connection attempts. For more information, see
<ulink url="&base-url-enterprise;advisors.html" />.
</para>
@@ -1562,7 +1590,7 @@
For reasons of security and performance the advisors
provided by the MySQL Enterprise Monitor pay special
attention to the <literal>Aborted_connections</literal>
- status variable. For more information see,
+ status variable. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -2760,7 +2788,7 @@
<para>
For expert advice on security-related issues, subscribe to
- the MySQL Enterprise Monitor. For more information see
+ the MySQL Enterprise Monitor. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -3361,7 +3389,7 @@
<para>
For early notification of possible problems with your MySQL
configuration subscribe to the MySQL Enterprise Monitor. For
- more information see
+ more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -3432,7 +3460,7 @@
<para>
Advisors provided by the MySQL Enterprise Monitor
automatically detect excessive temporary table storage to
- disk. For more information see
+ disk. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -4180,7 +4208,7 @@
<para>
Ensure that your data is adequately protected by subscribing
- to the MySQL Enterprise Monitor. For more information see
+ to the MySQL Enterprise Monitor. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -4659,7 +4687,7 @@
<para>
For expert advice on configuring MySQL servers for optimal
performance, subscribe to the MySQL Enterprise Monitor. For
- more information see
+ more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
Modified: trunk/refman-5.0/dba-core.xml
===================================================================
--- trunk/refman-5.0/dba-core.xml 2007-10-25 18:35:18 UTC (rev 8324)
+++ trunk/refman-5.0/dba-core.xml 2007-10-25 19:26:24 UTC (rev 8325)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 1; 1041 bytes
@@ -4173,8 +4173,17 @@
<para>
The number of seconds that the <command>mysqld</command>
server waits for a connect packet before responding with
- <literal>Bad handshake</literal>.
+ <literal>Bad handshake</literal>. The default value is 10
+ seconds as of MySQL 5.0.52 and 5 seconds before that.
</para>
+
+ <para>
+ Increasing the <literal>connect_timeout</literal> value
+ might help if clients frequently encounter errors of the
+ form <literal>Lost connection to MySQL server at
+ '<replaceable>XXX</replaceable>', system error:
+ <replaceable>errno</replaceable></literal>.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.0/errors-problems.xml
===================================================================
--- trunk/refman-5.0/errors-problems.xml 2007-10-25 18:35:18 UTC (rev 8324)
+++ trunk/refman-5.0/errors-problems.xml 2007-10-25 19:26:24 UTC (rev 8325)
Changed blocks: 11, Lines Added: 43, Lines Deleted: 15; 5003 bytes
@@ -29,7 +29,7 @@
<para>
The MySQL Enterprise Monitor provides a <quote>Virtual DBA</quote>
- to assist with problem solving. For more information see
+ to assist with problem solving. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -703,6 +703,34 @@
</section>
+ <section id="error-lost-connection">
+
+ <title><literal>Lost connection to MySQL server</literal></title>
+
+ <indexterm>
+ <primary>errors</primary>
+ <secondary>lost connection</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>problems</primary>
+ <secondary>lost connection errors</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>lost connection errors</primary>
+ </indexterm>
+
+ <para>
+ An error of the form <literal>Lost connection to MySQL server
+ at '<replaceable>XXX</replaceable>', system error:
+ <replaceable>errno</replaceable></literal> can indicate that
+ the server's <literal>connect_timeout</literal> value is set
+ too low.
+ </para>
+
+ </section>
+
<section id="old-client">
<title><literal>Client does not support authentication protocol</literal></title>
@@ -961,7 +989,7 @@
Subscribers to the MySQL Enterprise Monitor receive advice
on dynamically configuring the
<literal>max_connections</literal> variable — avoiding
- failed connection attempts. For more information see
+ failed connection attempts. For more information, see
<ulink url="&base-url-enterprise;advisors.html" />.
</para>
@@ -1223,6 +1251,13 @@
away</literal> error if MySQL is started with the
<option>--skip-networking</option> option.
</para>
+
+ <para>
+ Another networking issue that can cause this error occurs
+ if the MySQL port (default 3306) is blocked by your
+ firewall, thus preventing any connections at all to the
+ MySQL server.
+ </para>
</listitem>
<listitem>
@@ -1232,13 +1267,6 @@
connection to the MySQL server. This can be avoided by
using a separate connection for each child process.
</para>
-
- <para>
- Another networking issue that can cause this error occurs
- if the MySQL port (default 3306) is blocked by your
- firewall, thus preventing any connections at all to the
- MySQL server.
- </para>
</listitem>
<listitem>
@@ -1529,7 +1557,7 @@
For reasons of security and performance the advisors
provided by the MySQL Enterprise Monitor pay special
attention to the <literal>Aborted_connections</literal>
- status variable. For more information see
+ status variable. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -2680,7 +2708,7 @@
<para>
For expert advice on security-related issues, subscribe to
- the MySQL Enterprise Monitor. For more information see
+ the MySQL Enterprise Monitor. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -3280,7 +3308,7 @@
<para>
For early notification of possible problems with your MySQL
configuration subscribe to the MySQL Enterprise Monitor. For
- more information see
+ more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -3351,7 +3379,7 @@
<para>
Advisors provided by the MySQL Enterprise Monitor
automatically detect excessive temporary table storage to
- disk. For more information see
+ disk. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -4127,7 +4155,7 @@
<para>
Ensure that your data is adequately protected by subscribing
- to the MySQL Enterprise Monitor. For more information see
+ to the MySQL Enterprise Monitor. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -4573,7 +4601,7 @@
<para>
For expert advice on configuring MySQL servers for optimal
performance, subscribe to the MySQL Enterprise Monitor. For
- more information see
+ more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
Modified: trunk/refman-5.1/dba-core.xml
===================================================================
--- trunk/refman-5.1/dba-core.xml 2007-10-25 18:35:18 UTC (rev 8324)
+++ trunk/refman-5.1/dba-core.xml 2007-10-25 19:26:24 UTC (rev 8325)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 1; 1041 bytes
@@ -4289,8 +4289,17 @@
<para>
The number of seconds that the <command>mysqld</command>
server waits for a connect packet before responding with
- <literal>Bad handshake</literal>.
+ <literal>Bad handshake</literal>. The default value is 10
+ seconds as of MySQL 5.1.23 and 5 seconds before that.
</para>
+
+ <para>
+ Increasing the <literal>connect_timeout</literal> value
+ might help if clients frequently encounter errors of the
+ form <literal>Lost connection to MySQL server at
+ '<replaceable>XXX</replaceable>', system error:
+ <replaceable>errno</replaceable></literal>.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.1/errors-problems-core.xml
===================================================================
--- trunk/refman-5.1/errors-problems-core.xml 2007-10-25 18:35:18 UTC (rev 8324)
+++ trunk/refman-5.1/errors-problems-core.xml 2007-10-25 19:26:24 UTC (rev 8325)
Changed blocks: 10, Lines Added: 38, Lines Deleted: 10; 4375 bytes
@@ -31,7 +31,7 @@
<para>
The MySQL Enterprise Monitor provides a <quote>Virtual DBA</quote>
- to assist with problem solving. For more information see
+ to assist with problem solving. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -705,6 +705,34 @@
</section>
+ <section id="error-lost-connection">
+
+ <title><literal>Lost connection to MySQL server</literal></title>
+
+ <indexterm>
+ <primary>errors</primary>
+ <secondary>lost connection</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>problems</primary>
+ <secondary>lost connection errors</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>lost connection errors</primary>
+ </indexterm>
+
+ <para>
+ An error of the form <literal>Lost connection to MySQL server
+ at '<replaceable>XXX</replaceable>', system error:
+ <replaceable>errno</replaceable></literal> can indicate that
+ the server's <literal>connect_timeout</literal> value is set
+ too low.
+ </para>
+
+ </section>
+
<section id="old-client">
<title><literal>Client does not support authentication protocol</literal></title>
@@ -965,7 +993,7 @@
Subscribers to the MySQL Enterprise Monitor receive advice
on dynamically configuring the
<literal>max_connections</literal> variable — avoiding
- failed connection attempts. For more information see,
+ failed connection attempts. For more information, see
<ulink url="&base-url-enterprise;advisors.html" />.
</para>
@@ -1533,7 +1561,7 @@
For reasons of security and performance the advisors
provided by the MySQL Enterprise Monitor pay special
attention to the <literal>Aborted_connections</literal>
- status variable. For more information see
+ status variable. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -2683,7 +2711,7 @@
<para>
For expert advice on security-related issues, subscribe to
- the MySQL Enterprise Monitor. For more information see
+ the MySQL Enterprise Monitor. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -3283,7 +3311,7 @@
<para>
For early notification of possible problems with your MySQL
configuration subscribe to the MySQL Enterprise Monitor. For
- more information see
+ more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -3354,7 +3382,7 @@
<para>
Advisors provided by the MySQL Enterprise Monitor
automatically detect excessive temporary table storage to
- disk. For more information see,
+ disk. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -4123,7 +4151,7 @@
<para>
Ensure that your data is adequately protected by subscribing
- to the MySQL Enterprise Monitor. For more information see
+ to the MySQL Enterprise Monitor. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -4477,7 +4505,7 @@
<para>
For expert advice on configuring MySQL servers for optimal
performance, subscribe to the MySQL Enterprise Monitor. For
- more information see
+ more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -4832,8 +4860,8 @@
<title>Additional Known Issues</title>
<para>
- In addition, the following problems are also known and fixing
- them is also a high priority:
+ The following problems are also known and fixing them is also
+ a high priority:
</para>
<itemizedlist>
Modified: trunk/refman-5.2/dba-core.xml
===================================================================
--- trunk/refman-5.2/dba-core.xml 2007-10-25 18:35:18 UTC (rev 8324)
+++ trunk/refman-5.2/dba-core.xml 2007-10-25 19:26:24 UTC (rev 8325)
Changed blocks: 1, Lines Added: 10, Lines Deleted: 1; 996 bytes
@@ -4218,8 +4218,17 @@
<para>
The number of seconds that the <command>mysqld</command>
server waits for a connect packet before responding with
- <literal>Bad handshake</literal>.
+ <literal>Bad handshake</literal>. The default value is 10
+ seconds.
</para>
+
+ <para>
+ Increasing the <literal>connect_timeout</literal> value
+ might help if clients frequently encounter errors of the
+ form <literal>Lost connection to MySQL server at
+ '<replaceable>XXX</replaceable>', system error:
+ <replaceable>errno</replaceable></literal>.
+ </para>
</listitem>
<listitem>
Modified: trunk/refman-5.2/errors-problems.xml
===================================================================
--- trunk/refman-5.2/errors-problems.xml 2007-10-25 18:35:18 UTC (rev 8324)
+++ trunk/refman-5.2/errors-problems.xml 2007-10-25 19:26:24 UTC (rev 8325)
Changed blocks: 9, Lines Added: 36, Lines Deleted: 8; 4025 bytes
@@ -29,7 +29,7 @@
<para>
The MySQL Enterprise Monitor provides a <quote>Virtual DBA</quote>
- to assist with problem solving. For more information see
+ to assist with problem solving. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -703,6 +703,34 @@
</section>
+ <section id="error-lost-connection">
+
+ <title><literal>Lost connection to MySQL server</literal></title>
+
+ <indexterm>
+ <primary>errors</primary>
+ <secondary>lost connection</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>problems</primary>
+ <secondary>lost connection errors</secondary>
+ </indexterm>
+
+ <indexterm>
+ <primary>lost connection errors</primary>
+ </indexterm>
+
+ <para>
+ An error of the form <literal>Lost connection to MySQL server
+ at '<replaceable>XXX</replaceable>', system error:
+ <replaceable>errno</replaceable></literal> can indicate that
+ the server's <literal>connect_timeout</literal> value is set
+ too low.
+ </para>
+
+ </section>
+
<section id="old-client">
<title><literal>Client does not support authentication protocol</literal></title>
@@ -963,7 +991,7 @@
Subscribers to the MySQL Enterprise Monitor receive advice
on dynamically configuring the
<literal>max_connections</literal> variable — avoiding
- failed connection attempts. For more information see,
+ failed connection attempts. For more information, see
<ulink url="&base-url-enterprise;advisors.html" />.
</para>
@@ -1531,7 +1559,7 @@
For reasons of security and performance the advisors
provided by the MySQL Enterprise Monitor pay special
attention to the <literal>Aborted_connections</literal>
- status variable. For more information see
+ status variable. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -2681,7 +2709,7 @@
<para>
For expert advice on security-related issues, subscribe to
- the MySQL Enterprise Monitor. For more information see
+ the MySQL Enterprise Monitor. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -3281,7 +3309,7 @@
<para>
For early notification of possible problems with your MySQL
configuration subscribe to the MySQL Enterprise Monitor. For
- more information see
+ more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -3352,7 +3380,7 @@
<para>
Advisors provided by the MySQL Enterprise Monitor
automatically detect excessive temporary table storage to
- disk. For more information see,
+ disk. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -4121,7 +4149,7 @@
<para>
Ensure that your data is adequately protected by subscribing
- to the MySQL Enterprise Monitor. For more information see
+ to the MySQL Enterprise Monitor. For more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
@@ -4475,7 +4503,7 @@
<para>
For expert advice on configuring MySQL servers for optimal
performance, subscribe to the MySQL Enterprise Monitor. For
- more information see
+ more information, see
<ulink url="&base-url-enterprise;advisors.html"/>.
</para>
| Thread |
|---|
| • svn commit - mysqldoc@docsrva: r8325 - in trunk: . dynamic-docs/changelog dynamic-docs/command-optvars refman-4.1 refman-5.0 refman-5.1 refman-5.2 | paul | 25 Oct |
