[asterisk-users] slow ODBC reconnect

[Klaus Darilion]

Hi!

I use unixodbc to connect to mysql. When the connection to the DB is 
lost (e.g. restarting the Mysql server) the reconnect takes 5 seconds:

[Jan  9 13:22:15] WARNING[13899]: res_odbc.c:113 
ast_odbc_prepare_and_execute: SQL Execute error -1! Attempting a 
reconnect...
[Jan  9 13:22:20] NOTICE[13899]: res_odbc.c:541 odbc_obj_connect: 
Connecting asterisk


Does somebody know where the 5 seconds delay come from and how I can 
tune it? Is is also possible to configure asterisk to automatically 
reconnect instead of waiting for the first query to reconnect?

thanks
klaus