On Jul 1, 2005, at 11:23 AM, Xantia38 wrote: [snip]
3: When using the MySQL database, the SlimServer loses the database connection after some time. I traced this back to the connection timeout of MySQL, indicating that the SlimServer does not ping the database to keep the connection alive. While the workaround is trivial - increase the connection timeout value such that it is unlikely to ever reach its limit (such as 7 days) - it is not the right solution. The SlimServer should send a keep-alive signal every 15 minutes or so.
This change is trivial as perl's DBI interface provides a ping() function for mysql that can be inserted into the main loop. The tricky part though is to be careful if the code uses any prepared statements. See more details and code examples:
http://www.mysqlusers.com/msg/19248.html Victor _______________________________________________ Discuss mailing list Discuss@lists.slimdevices.com http://lists.slimdevices.com/lists/listinfo/discuss