httpd-cvs mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From humbed...@apache.org
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

URL: http://svn.apache.org/viewvc?rev=1308718&view=rev
Log:
Added a note about MySQL's reconnect option and its effects on prepared statements

Modified:
    httpd/httpd/trunk/docs/manual/mod/mod_dbd.xml

Modified: httpd/httpd/trunk/docs/manual/mod/mod_dbd.xml
URL: http://svn.apache.org/viewvc/httpd/httpd/trunk/docs/manual/mod/mod_dbd.xml?rev=1308718&r1=1308717&r2=1308718&view=diff
==============================================================================
--- 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>
 
 <section id="security">



Mime
View raw message