I looked, but couldn't find the message you mentioned. Please resend
it.
I'm about to conclude that I just need to switch hosts due to security
concerns, so that may fix the problem, too.
Clarke
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Cameron
Childress
Sent: Friday, July 10, 2009 2:10 PM
To: [email protected]
Subject: Re: [ACFUG Discuss] ColdFusion and MySQL
Clarke- Did you see the message I forwarded to the list a few days
ago regarding compression in the driver?
Also - I'm not sure what the load profile of this website is, but the
"performance hit" from turning maintain connections off is not usually
visible till you are under relatively high load. When you turned it
off, did you see a performance degrade? If not, it may be an easier
(and less expensive) fix than changing DB platforms.
-Cameron
On Fri, Jul 10, 2009 at 1:59 PM, Clarke Bishop<[email protected]
>
wrote:
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: [email protected] [mailto:[email protected]] On Behalf Of Wes Byrd
Sent: Friday, July 10, 2009 1:42 PM
To: [email protected]
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
________________________________
From: [email protected] [mailto:[email protected]] On Behalf Of Clarke
Bishop
Sent: Friday, July 10, 2009 10:20 AM
To: [email protected]
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: [email protected] [mailto:[email protected]] On Behalf Of Clarke
Bishop
Sent: Wednesday, July 08, 2009 5:13 PM
To: [email protected]
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
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------
--
Cameron Childress
Sumo Consulting Inc
http://www.sumoc.com
---
cell: 678.637.5072
aim: cameroncf
email: [email protected]
-------------------------------------------------------------
To unsubscribe from this list, manage your profile @
http://www.acfug.org?fa=gin.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
-------------------------------------------------------------
-------------------------------------------------------------
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
-------------------------------------------------------------
