[asterisk-users] Help Please - Asterisk MYSQL interface seems to be eating data

[Johansson Olle E]

5 maj 2008 kl. 19.58 skrev Tilghman Lesher:

> On Monday 05 May 2008 11:24, Johansson Olle E wrote:
>> 5 maj 2008 kl. 17.51 skrev Tilghman Lesher:
>>> On Monday 05 May 2008 09:45, Johansson Olle E wrote:
>>>> Another issue that we need to fix with the MYSQL driver is that  
>>>> we're
>>>> lacking a connection pool. Everything seems to be handled over one
>>>> connection to Mysql, which causes issues.
>>>
>>> That's not true.  The MYSQL app generally uses multiple connections,
>>> one
>>> for each channel.  The only way one might use only a single
>>> connection is
>>> by using a global variable to store a single connection id, but that
>>> method
>>> is not documented anywhere, AFAIK.
>>
>> You talk about the Mysql APP, but is this the case with the Realtime
>> driver as well?
>
> No, the native Realtime driver uses a single connection.  The ODBC  
> Realtime
> driver generally uses a single connection but can be configured to  
> use a
> separate connection for each query.

So, we're back to where we started. A developer that can help us with  
a connection
pool or a separate connection for each query would be a Nice Thing (TM).

/O