httpd-cvs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
Subject svn commit: r1308718 - /httpd/httpd/trunk/docs/manual/mod/mod_dbd.xml
Date Tue, 03 Apr 2012 06:44:36 GMT
Author: humbedooh
Date: Tue Apr  3 06:44:36 2012
New Revision: 1308718

Added a note about MySQL's reconnect option and its effects on prepared statements


Modified: httpd/httpd/trunk/docs/manual/mod/mod_dbd.xml
--- httpd/httpd/trunk/docs/manual/mod/mod_dbd.xml (original)
+++ httpd/httpd/trunk/docs/manual/mod/mod_dbd.xml Tue Apr  3 06:44:36 2012
@@ -112,6 +112,14 @@ APR_DECLARE_OPTIONAL_FN(void, ap_dbd_pre
     <p>It is up to dbd user modules to use the prepared statements
     and document what statements can be specified in httpd.conf,
     or to provide their own directives and use <code>ap_dbd_prepare</code>.</p>
+	<note type="warning"><title>Caveat</title>
+	When using prepared statements with a MySQL database, it is preferred to set
+	<code>reconnect</code> to 0 in the connection string as to avoid errors that
+	arise from the MySQL client reconnecting without properly resetting the
+	prepared statements. If set to 1, any broken connections will be attempted
+	fixed, but as mod_dbd is not informed, the prepared statements will be invalidated.
+	</note>
 <section id="security">

View raw message