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, 11:57 pm Gordan Bobic, <gordan@shatteredsilicon.net> wrote:
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