Hi Jonas Kellens, Like everybody else, I also recommend to upgrade your Asterisk version, and replace mysql driver with odbc. the one big advantage of odbc driver is its pooling feature, you can configure odbc to create a reusable pool of active connections, so Asterisk does't needs to reconnect for each query.
For example with following odbc settings you can achieve 500+ concurrent channels (approx 2500 queries / minute) without any performance issue. pooling => yes limit => 16 pre-connect => yes Regards Nasir Iqbal ICTBroadcast - an Auto Dialer software for ITSP <https://www.ictbroadcast.com/how-become-internet-telephony-service-provider-itsp-using-ictbroadcast-sp-edition> SMS, Fax and Voice broadcasting & Inbound / Outbound Campaigns http://www.ictbroadcast.com/ On Fri, Oct 5, 2018 at 4:26 AM John Novack <[email protected]> wrote: > As others have said, clearly it ISN'T "just working" or you would not have > posted the question > > To state again, I am using Version 13, though a few minor revisions > behind, with MySql, on CentOS 6 and have no rebooting or other MySql > related issues > > Clearly you need to state in more detail what issues remain, once you > migrate to AT LEAST 13.xx, and state your OS after becoming current with > Asterisk, MySql and the OS > > I use MySql on every incoming call, and also maintain call detail records > in MySql for every call, and it just simply works, and has for some time. > > Although I may be using it quite differently that you, it simply works. > Is this a newly developing issue, or has it persisted for some time > What if any changes have been made to the dialplan etc? > > Have you considered a strictly hardware issue? Memory? HD? MB?? > > The crystal ball is very cloudy on this one! > > John Novack > > > Jonas Kellens wrote: > > Hello > > thank you for your answer. > > If I read your (and others) reaction correctly I can conclude that this is > an Asterisk problem and not a problem of MySQL or dialplan logic ? > > > You should know that the MySQL database is heavily questioned : > > > mysql> show status like '%onn%'; > +--------------------------+--------+ > | Variable_name | Value | > +--------------------------+--------+ > | Aborted_connects | 469 | > | Connections | 132762 | > | Max_used_connections | 8 | > | Ssl_client_connects | 0 | > | Ssl_connect_renegotiates | 0 | > | Ssl_finished_connects | 0 | > | Threads_connected | 3 | > +--------------------------+--------+ > 7 rows in set (0.00 sec) > > > > I stick to 1.8 because it just works. I had some issues with version 11 > and 13 in the past. > > > Regards > > Jonas. > > Op 04-10-18 om 17:49 schreef John Novack: > > Woefully out of date. > You really need to put your efforts into at least a modest upgrade > I use version 13 with MySql queries built into the dialplan on CentOs 6 > and have NO such issues, either performance or any restart or reboot. It > simply works > > I never used either 1.6 or 1.8, going from 1.4 to version 11, which did > require some syntax changes to the dialplan. > > Given that even version 11 is EOL, you really need to put your efforts > into doing the migration rather than tracking this one down > > JMO > > John Novack > > > > Jonas Kellens wrote: > > Hello > > using Asterisk 1.8.32. > > I notice that there is a spontaneous reboot of the Asterisk system from > time to time. > > When I look in the logs (verbose file) I noticed that every time this > occurs it's at a moment that there is a MySQL action, be it a lookup or an > insert/update/delete. > > I must say I do have some MySQL queries that occur in my dialplan when a > call comes in, to look up different actions to perform on this call. > > > An idea how to overcome this problem ? Seems a "performance" issue, no ?! > > Is it better to have these MySQL queries to be done by an external script > (like a php script that I call with the System()-command or a > SHELL()-command) ? > > > Here are some examples from the verbose file. > > > > [Aug 22 15:19:10] VERBOSE[2977] pbx.c: [Aug 22 15:19:10] -- Executing > [s@sub-GetAlertInfo:3] MYSQL("SIP/SipAgenT01-0000317d", "Connect connid > localhost myuser mypwd myDB") in new stack > [Aug 22 15:19:10] VERBOSE[2977] pbx.c: [Aug 22 15:19:10] -- Executing > [s@sub-GetAlertInfo:5] MYSQL("SIP/SipAgenT01-0000317d", "Query resultid 1 > SELECT uri, callinfo FROM distringtone WHERE onoff='1'") in new stack > [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18] == Parsing > '/etc/asterisk/logger.conf': [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug > 22 15:19:18] == Found > [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18] == Parsing > '/etc/asterisk/asterisk.conf': [Aug 22 15:19:18] VERBOSE[3306] config.c: > [Aug 22 15:19:18] == Found > [Aug 22 15:19:18] VERBOSE[3306] manager.c: [Aug 22 15:19:18] == Manager > registered action DataGet > [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18] == Parsing > '/etc/asterisk/codecs.conf': [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug > 22 15:19:18] == Found > [Aug 22 15:19:18] VERBOSE[3306] loader.c: [Aug 22 15:19:18] Asterisk > Dynamic Loader Starting: > [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18] == Parsing > '/etc/asterisk/modules.conf': [Aug 22 15:19:18] VERBOSE[3306] config.c: > [Aug 22 15:19:18] == Found > [Aug 22 15:19:18] VERBOSE[3306] config.c: [Aug 22 15:19:18] == Parsing > '/etc/asterisk/res_config_mysql.conf': [Aug 22 15:19:18] VERBOSE[3306] > config.c: [Aug 22 15:19:18] == Found > [Aug 22 15:19:18] VERBOSE[3306] res_config_mysql.c: [Aug 22 15:19:18] == > MySQL RealTime driver loaded. > [Aug 22 15:19:18] VERBOSE[3306] loader.c: [Aug 22 15:19:18] > res_config_mysql.so => (MySQL RealTime Configuration Driver) > > > > [Aug 22 16:23:25] VERBOSE[24283] pbx.c: [Aug 22 16:23:25] -- Executing > [s@sub-GetSipAccountdetails:3] MYSQL("SIP/SipAgenT01-00004184", "Connect > connid localhost myuser mypwd myDB") in new stack > [Aug 22 16:23:25] VERBOSE[24283] pbx.c: [Aug 22 16:23:25] -- Executing > [s@sub-GetSipAccountdetails:4] MYSQL("SIP/SipAgenT01-00004184", "Query > resultid 1 SELECT SIPusername, currstatus, available FROM tbl_SIP WHERE > ID="800"") in new stack > [Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22 16:23:32] == Parsing > '/etc/asterisk/logger.conf': [Aug 22 16:23:32] VERBOSE[24309] config.c: > [Aug 22 16:23:32] == Found > [Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22 16:23:32] == Parsing > '/etc/asterisk/asterisk.conf': [Aug 22 16:23:32] VERBOSE[24309] config.c: > [Aug 22 16:23:32] == Found > [Aug 22 16:23:32] VERBOSE[24309] manager.c: [Aug 22 16:23:32] == Manager > registered action DataGet > [Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22 16:23:32] == Parsing > '/etc/asterisk/codecs.conf': [Aug 22 16:23:32] VERBOSE[24309] config.c: > [Aug 22 16:23:32] == Found > [Aug 22 16:23:32] VERBOSE[24309] loader.c: [Aug 22 16:23:32] Asterisk > Dynamic Loader Starting: > [Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22 16:23:32] == Parsing > '/etc/asterisk/modules.conf': [Aug 22 16:23:32] VERBOSE[24309] config.c: > [Aug 22 16:23:32] == Found > [Aug 22 16:23:32] VERBOSE[24309] config.c: [Aug 22 16:23:32] == Parsing > '/etc/asterisk/res_config_mysql.conf': [Aug 22 16:23:32] VERBOSE[24309] > config.c: [Aug 22 16:23:32] == Found > [Aug 22 16:23:32] VERBOSE[24309] res_config_mysql.c: [Aug 22 16:23:32] > == MySQL RealTime driver loaded. > [Aug 22 16:23:32] VERBOSE[24309] loader.c: [Aug 22 16:23:32] > res_config_mysql.so => (MySQL RealTime Configuration Driver) > > > > [Oct 4 10:11:25] VERBOSE[4944] pbx.c: [Oct 4 10:11:25] -- Executing > [s@sub-settings:16] MYSQL("SIP/SipAgenT01-000008cb", "Connect connid > localhost myuser mypwd myDB") in new stack > [Oct 4 10:11:25] VERBOSE[4944] pbx.c: [Oct 4 10:11:25] -- Executing > [s@sub-settings:17] MYSQL("SIP/SipAgenT01-000008cb", "Query resultid 1 > SELECT blockID from DID where DID=987654321") in new stack > [Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4 10:11:29] == Parsing > '/etc/asterisk/asterisk.conf': [Oct 4 10:11:29] VERBOSE[4961] config.c: > [Oct 4 10:11:29] == Found > [Oct 4 10:11:29] VERBOSE[4961] manager.c: [Oct 4 10:11:29] == Manager > registered action DataGet > [Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4 10:11:29] == Parsing > '/etc/asterisk/codecs.conf': [Oct 4 10:11:29] VERBOSE[4961] config.c: > [Oct 4 10:11:29] == Found > [Oct 4 10:11:29] VERBOSE[4961] loader.c: [Oct 4 10:11:29] Asterisk > Dynamic Loader Starting: > [Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4 10:11:29] == Parsing > '/etc/asterisk/modules.conf': [Oct 4 10:11:29] VERBOSE[4961] config.c: > [Oct 4 10:11:29] == Found > [Oct 4 10:11:29] VERBOSE[4961] config.c: [Oct 4 10:11:29] == Parsing > '/etc/asterisk/res_config_mysql.conf': [Oct 4 10:11:29] VERBOSE[4961] > config.c: [Oct 4 10:11:29] == Found > [Oct 4 10:11:29] VERBOSE[4961] res_config_mysql.c: [Oct 4 10:11:29] == > MySQL RealTime driver loaded. > [Oct 4 10:11:29] VERBOSE[4961] loader.c: [Oct 4 10:11:29] > res_config_mysql.so => (MySQL RealTime Configuration Driver) > > > > > Kind regards > > Jonas. > > > > > > -- > > Dog is my Co-pilot > > > > > > -- > > Dog is my Co-pilot > > -- > _____________________________________________________________________ > -- Bandwidth and Colocation Provided by http://www.api-digital.com -- > > Astricon is coming up October 9-11! Signup is available at: > https://www.asterisk.org/community/astricon-user-conference > > Check out the new Asterisk community forum at: > https://community.asterisk.org/ > > New to Asterisk? Start here: > https://wiki.asterisk.org/wiki/display/AST/Getting+Started > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- Astricon is coming up October 9-11! Signup is available at: https://www.asterisk.org/community/astricon-user-conference Check out the new Asterisk community forum at: https://community.asterisk.org/ New to Asterisk? Start here: https://wiki.asterisk.org/wiki/display/AST/Getting+Started asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
