Hi - I'm having some problems with using MySQL, MyODBC, and Coldfusion together, so I thought I'd post here and see if anyone had any ideas on how to fix the problems. I see other people have had similar issues, so hopefully someone can help me out.
So, we've running on Solaris 2.7, with Mysql 3.23.49 (using InnoDB tables...), Coldfusion 5, unixODBC-2.2.2, and MyODBC (both versions 2.50.39 and 3.51.02). Coldfusion and mySQL are running on the same machine. We've gotten everything to basically work - we can do everything we need to in Coldfusion, but we're having the dreaded "crashing" problem. When we put our Coldfusion application under load, or basically just click a lot of links in the application at once, Coldfusion crashes and restarts. The same application running against Oracle with the oracle native driver doesn't crash - this is code we've run for a long time in a different environment, so we don't think it's a code problem. Anyway - we suspect the problem is some sort of 'thread-safe' problem. Originally we used the binary distributions of MySQL and MyODBC, and then realized the Solaris binary that's available isn't threadsafe. So we built everything from source, following these instructions: http://dbforums.com/showthread.php?threadid=174934 "MySQL ColdFusion unixODBC MyODBC and Solaris - how to succeed!" of course, adding in the InnoDB option to the mysql compilation. But even after going through all this, we still had the crashing problems. So - I've seen other people post about having the crashing problem - are there any obvious things I may have missed? How do I know if MyODBC and mysqld have been compiled to be thread safe? Here are some concrete questions: Is there a way to force Coldfusion and MyODBC to connect to MySQL using network sockets instead of the Unix sockets? I'd like to test that to see if the behavior is different. I tried to follow the mysql documentation about compiling a thread-safe client: http://www.mysql.com/doc/T/h/Threaded_clients.html one thing I don't understand: The documentation states compiling with thread-safe options will create a thread-safe client library libmysqlclient_r - do I need to make certain that libmyodbc links against the libmysqlclient_r.so, instead of the generic libmysqlclient.so? I've seen posts in the past on this mailing list, and other places, about people having problems using mysql + coldfusion together, so if anyone can help, or has any ideas, please respond to the list or directly to me at [EMAIL PROTECTED] Thanks for any help! Thank you- dana ===== Dana Quinn [EMAIL PROTECTED] "Unix-type guy" __________________________________________________ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php