Asterisk with Mariadb


#1

I am having performance issue with Asterisk 14.7.7 and MariaDB 10.3.13. I get the following asterisk log
WARNING[5042][C-000001a6] taskprocessor.c: The ‘subm:cdr_engine-00000003’ task processor queue reached 5000 scheduled tasks. Currently I am using Centos 7 with unixODBC 2.3.1 and mariadb-connector-odbc 3.0.7.

[MySQL]
Description	= ODBC for MySQL
Driver		= /usr/lib/libmyodbc5.so
Setup		= /usr/lib/libodbcmyS.so
Driver64	= /usr/lib64/libmyodbc5.so
Setup64		= /usr/lib64/libodbcmyS.so
FileUsage	= 1

[MariaDB]
Driver64 = /usr/local/lib64/libmaodbc.so
Description = asterisk-pg-connector
Trace = No
FileUsage = 1
Pooling = No

This is my odbcinst file. I am using mariadb configuration, If I use mariadb 5.5 with Mysql driver everything is ok. But if I switch to mariadb 10.3.13 and use MariaDB driver from above I have a performance issue with task processor.

I think it is a mariadb-connector-odbc problem. What version should I use?


#2

Hi,

It’s not always easy to find the right info about this but here’s what I use in Asterisk 16 PJSIP in a production system which is very stable (over 1000 endpoints):

Centos 7.5
MariaDB Ver 5.5.60
UnixODBC 2.3.7
Mysql-connector-odbc :8.0.11


#3

thank you for your response, i have teste with mariadb 5.5.6 and unixodbc 2.3.1 and it is very stable. But I want to use asterisk 14.7.7 with mariadb 10.3.13 because I have them in a cluster, using mariadb galera cluster. with this version of DB i have performance issue with 20 calls per second