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, <[email protected]> wrote: > On Fri, 21 Mar 2025 at 20:17, Jaswanth Kumar <[email protected]> > 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 >
Error Log Snippet.docx
Description: MS-Word 2007 document
_______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
