I have two server.
One has Maria DB 10.5.5 and other has 10.5.8.
10.5.8 occur this error.
[ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 second. We Intentionally crash the server because it appears to be hung.
[ERROR] mysqld got exception 0x80000003
Even if 10.5.5 server save more data, but 10.5.5 not occur error.
Both innodb_buffer_pool_size
is 12G.
So I compare environment variables, and 10.5.8 has innodb_lru_flush_size
variable.
It value is default 32.
What value innodb_lru_flush_size
before 10.5.8?
If I increase innodb_lru_flush_size
, MariaDB 10.5.8 has no more semaphore error?
User contributions licensed under CC BY-SA 3.0