Asterisk with Mariadb


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.

Description	= ODBC for MySQL
Driver		= /usr/lib/
Setup		= /usr/lib/
Driver64	= /usr/lib64/
Setup64		= /usr/lib64/
FileUsage	= 1

Driver64 = /usr/local/lib64/
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?



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


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