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

Tilghman Lesher tilghman at mail.jeffandtilghman.com
Mon May 5 12:58:42 CDT 2008


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.

> >> Any MySQL developers out there that can help us fix this? We need
> >> someone that has been developing towards the Mysql api.
> >>
> >> And please do not always refer to "Digium developers" when you have
> >> problems in Asterisk. There are developers that are not employees of
> >> Digium...
> >
> > There used to be more outside developers, but Digium is a great
> > place to work... ;-)
>
> Hmm. Haven't found any Digium Stockholm office to discuss with ;-)

That hasn't stopped any of the Canadian employees.  :-)

-- 
Tilghman



More information about the asterisk-users mailing list