Right now, am using 10.6.21 version.
I am getting
MariaDB 10.6.21 Signal 11 Crash (Segmentation Fau
MariaDB Configuration:
[mysqld]
lower_case_table_names=1
innodb_buffer_pool_size=10G
innodb_log_file_size=2G
innodb_log_buffer_size=256M
innodb_flush_log_at_trx_commit=2
innodb_flush_method=O_DIRECT
table_definition_cache=8000
table_open_cache=8000
port=3319
user=root
sort_buffer_size=16M
join_buffer_size=16M
max_heap_table_size=1G
tmp_table_size=1G
max_connections=500
max_sp_recursion_depth=255
slow-query-log=1
slow-query-log-file=/home/admin/log/mariadb/query/db_slow_query_log.txt
long-query-time=0
Attached is the error log...
On Fri, 21 Mar 2025 at 20:17, Jaswanth Kumar <jaswanth.at.work@gmail.com> wrote:
>
> Hi Gordan,
>
> In my case, we have a process where it is doing multiple concurrent requests to mariadb database. Sometimes with the default configuration mariadb is randomly crashing and doing a recovery again. We are seeing lost connection to mariadb errors sometimes not everytime. To avoid these type of issues, we thought of tuning mariadb parameters. But we are not sure which parameters needs to change and what percentage or values we need give for them.
You probably want to start with identifying the actual cause of the
crash. The most common one is out-of-memory errors, but there are bugs
that can cause a crash. What version of MariaDB are you using?
--
Gordan Bobic
Database Specialist, Shattered Silicon Ltd.
https://shatteredsilicon.net