grooverdan
commented
1 year ago For a 2.2t data size you should have a bigger buffer pool configured and and increase innodb_log_file_size as it looks like it gets frequent updates. Without these settings it can take a long time to start. The increased innodb_log_file_size will help the next restart.
Which mariadb version are you running in this container?
There's also a long thread on the discussion lists, and especially take note of this one - https://lists.launchpad.net/maria-discuss/msg06292.html.
my issue is that when i restarted my docker container it did freeze on
2022-08-04 0:28:28 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions 2022-08-04 0:28:28 0 [Note] mysqld: O_TMPFILE is not supported on /tmp (disabling future attempts) 2022-08-04 0:28:28 0 [Note] InnoDB: Initializing buffer pool, total size = 134217728, chunk size = 134217728 2022-08-04 0:28:28 0 [Note] InnoDB: Completed initialization of buffer pool 2022-08-04 0:28:28 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
i did it a couple of times and still the same any idea on why this is happening,
it stuck and im not receiving any log and i cant connect to the db my database size is 2.2t and i have ro rollback to be made so i dont know why this is happening