Ross Vandegrift wrote:
Hello everyone,
I've got a particularly perplexing case of SQLAlchemy losing SQL
connections to a MySQL 4.1 database.
Before you roll your eyes, I am familiar with both wait_timeout and
pool_recycle!
On the MySQL server, this is set to eight hours:
mysql show variables like 'wait_timeout';
+---+---+
| Variable_name | Value |
+---+---+
| wait_timeout | 28800 |
+---+---+
In my production.ini on the web server, I have tried a few settings:
sqlalchemy.default.pool_recycle = 3600
and even:
sqlalchemy.default.pool_recycle = 600
Neither seems to help though. Anyone have any ideas? Perhaps I'm
doing something wrong in configuring production.ini?
MySQL can throw a 2013 and hang up if the resources needed by a SELECT
exceed the server's configuration. I'd check the server logs for clues,
then adjust the key_buffer, sort_buffer, etc. as required. The ORM can
generate some pretty intense SQL with extreme ease.
--~--~-~--~~~---~--~~
You received this message because you are subscribed to the Google Groups
sqlalchemy group.
To post to this group, send email to sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~--~~~~--~~--~--~---