Pooling with MySQL - Urgent Matter

Dear All,
In order to speedup Asterisk , we need to be able to enable pooling on MySQL;
The default configuration with mysql permit about 36 to 40 SQL queries/Inserts in second with only one active connection.
My target is to use Asterisk with 300 to 400 simultaneous connections with realtime on MySQL.

I tried to enable pooling in res_odbc.conf - I’m using unixODBC; however the pooling works forfew seconds and then both odbc.ini and odbcinst.ini are erased. :cry:

I tried the scenario on Solaris 10 x86 and sparc, the same result was obtained.
I’m wondering why Asterisk is erasing these files.

Any Help? Please…

1 Like