[Freeswitch-users] Situation with freeswitch dbh + odbc (mysql) in lua

[Luis Daniel Lucio Quiroz]

I have ven working with MySQL since 3.x

Check the following

A close connections in lua
B rise max connections in my.cnf
C. Make connections time out minutes instead hours
This is in my.cfn
D rise threads
E rise table caching
F use indexes. Correct ones
G add memcached support to your lua script where you can

You will see a better performance.
Le 13 nov. 2015 8:20 AM, "Florent Krieg" <flokrrr at gmail.com> a écrit :

> Hello John,
>
> If you are under heavy load, could this be a db issue? Like the db engine
> taking long to return the data, hence queries are getting queued one after
> the other and finally reach a few hundreds of it?
> Or you are right and your Lua script sometimes doesn't release the handler
> as it just shall... To check this, you could for instance log a debug
> message before and after doing your db query, and check after a few minutes
> if you have the equivalent of 'before' and 'after' query messages... If
> more before than after, then something is happening.
>
> You could do a 'show processlist;' on the MySQL cli too to understand what
> are exactly the few hundreds of open connections.
>
> Also, is your stored procedure complicated? I'm not DBA but if it's too
> tricky, you could imagine to move the load on the Lua processing instead of
> MySQL. I have the same use cases on my environment and I made sure my MySQL
> queries are dumb as possible and I take the benefit of Lua to process the
> data returned.
>
> I'm just dropping some ideas that I'm thinking about now. Nothing very
> precise though (sorry...).
> Florent
>
> 2015-11-13 12:49 GMT+01:00 John Nash <john.nash778 at gmail.com>:
>
>> I am calling a lua script from dialplan which does following steps ...
>>
>> 1- Gets freeswitch dbh handle (odbc mysql)
>> 2- Runs a mysql stored procedure which returns balance remaining amount
>> for the subscriber who made call.
>> 3- Save the amount in session variable and released dbh handle
>> 4- Play sound files as per output received and saved in step 3
>>
>> Now upto 200 calls and first 2-3 hours of start all work fine. I can see
>> in Database that script uses 32 connections approx at a given time (I think
>> connection pooling works) but suddenly connections start increasing and go
>> upto 300+ and because of that database stops responding and i have to kill
>> freeswitch to make production DB responsive again.
>>
>> I am not sure where and what I should check. Can someone give me pointers
>> on what I can check?..Or I am doing something fundamentally wrong.
>>
>> Can there be such a case where lua scripts hang and never release
>> connection?
>>
>>
>>
>>
>>
>>
>> _________________________________________________________________________
>> Professional FreeSWITCH Consulting Services:
>> consulting at freeswitch.org
>> http://www.freeswitchsolutions.com
>>
>> Official FreeSWITCH Sites
>> http://www.freeswitch.org
>> http://confluence.freeswitch.org
>> http://www.cluecon.com
>>
>> FreeSWITCH-users mailing list
>> FreeSWITCH-users at lists.freeswitch.org
>> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
>> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
>> http://www.freeswitch.org
>>
>
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20151113/6d68c418/attachment.html