Sorry if I wasn't clear about something. As you said, "Maintain connections across client requests" is the default. It's when you turn it off that the mySQL problem goes away with some server/driver configurations. If maintain connections is off, then CF has to recreate the connection for each query which obviously hurts performance and server load.
However, with maintain connections off, the mySQL problem goes away. I think that what's happening is that ColdFusion somehow loses track of the database connection, but then still tries to use the connection. And, the error I've seen is the result. If CF always has to recreate the connection, it can't lose track so everything is fine. Clarke From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Wes Byrd Sent: Friday, July 10, 2009 1:42 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL That's very odd considering I have several Windows 2003 servers all running CF8. These servers host about 200 different websites using CF8 that ALL connect to a separate dedicated MySQL server. Some of the sites connect to a MySQL 4.x service and others MySQL 5.x. All of these sites connect via the provided MySQL 4/5 driver in the CF Admin. The "Maintain connections across client requests" is apparently a default option as this is set on all of my datasources. Perhaps this is why I never see this problem. So, as I have many sites accessing a single database server all with this option configured. where is the problem with this? I don't see any real "performance impact" because of this option being checked. ??? Wes Byrd CIO, Dynapp Inc. 678.528.2952 ext 601 <http://www.dynapp.com/> _____ From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Friday, July 10, 2009 10:20 AM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I still haven't been able to get the host to resolve this problem, and I've decided to just abandon MySQL for SQL Server. The database is simple and I can make the change quickly. To wrap this up, based on what I've learned and what my web research shows: . The problem exists only for MySQL with ColdFusion running under Windows . If you turn off Maintain Connections across client connections in the advanced datasource settings, the problem goes away. Obviously this would impact server performance and isn't a fix. . So, it is sort of a communications problem. It seems that between ColdFusion and the MySQL driver the reference to the database connection gets confused. ColdFusion expects the connection to the database, but doesn't find it and throws the error. . Maybe there's a set of ColdFusion/MySQL/Server configuration settings that will fix this. Or, maybe it's a ColdFusion or MySQL bug. I just don't know. Anyway, thanks for all the great ideas. At least I learned some new tricks! Clarke -----Original Message----- From: ad...@acfug.org [mailto:ad...@acfug.org] On Behalf Of Clarke Bishop Sent: Wednesday, July 08, 2009 5:13 PM To: discussion@acfug.org Subject: RE: [ACFUG Discuss] ColdFusion and MySQL I got another piece of data from using the cfdbinfo tag. Sometimes, it throws this error: So, I think you're right Wes. It is some kind of communication problem. If this new data gives anyone any ideas on where to go next, please let me know. Thanks again for all the help! Clarke ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by FusionLink <http://www.fusionlink.com> ------------------------------------------------------------- ------------------------------------------------------------- To unsubscribe from this list, manage your profile @ http://www.acfug.org?fa=login.edituserform For more info, see http://www.acfug.org/mailinglists Archive @ http://www.mail-archive.com/discussion%40acfug.org/ List hosted by http://www.fusionlink.com -------------------------------------------------------------
<<image001.gif>>