mysql connections in sleep state

Question

Hi, i have a debian system with 2.6.32-5-amd64 kernel and motion version 3.2.12-3, and have the motion set to log images, mpegs, and timelapse files to mysql version 5.1.58-1. The motion detection is based on 3 netcams, and one v4l webcam. The detection is working fine, but leaves the sql connections open, so after a while the maximum sql connections are exceeded, so no more logging. Only restarting the motion daemon or killing the sql connections via mysql admin are freeing the connections.

sql_log_image on
sql_log_snapshot off
sql_log_mpeg on
sql_log_timelapse on
sql_query insert into motion(camera, filename, frame, file_type, time_stamp, event_time_stamp) values('%t', '%f', '%q', '%n', '%Y-%m-%d %T', '%C')
mysql_db motion
mysql_host localhost
mysql_user motion
mysql_password pw

Environment

Motion version:	3.2.12
ffmpeg version:	5:0.6.1+svn20101128-0.2
Libraries:	ffmpeg, mysql
Server OS:	debian kernel 2.6.32

-- PeterTar - 29 Sep 2011

Answer