Sand, по указанному вопросу там имеются эти пункты в решении проблемы
Set innodb_log_checksums = ON on master and slave.
Remove rm /var/lib/mysql/ib_logfile*.
Restart.
Sand, есть такой файл, но это все имеющиеся параметры которые что то говорят об innodb. Или Вам лучше все настройки сообщить?
# InnoDB parameters
innodb_file_per_table
innodb_buffer_pool_size = 32M
innodb_flush_log_at_trx_commit = 2
innodb_log_file_size = 64M
innodb_flush_method = O_DIRECT
innodb_strict_mode = OFF
Или можно добавлять недостающие настройки?
Sand, нашел это: https://dba.stackexchange.com/questions/163445/inn...
но не могу найти файл конфигурации. Нашел только файл ~/.my.cnf но при его просмотре увидел только
# Ansible managed
[client]
user=root
password='Тут пароль'
socket=/var/lib/mysqld/mysqld.sock
2020-12-25T05:19:34.875669Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 24642)
2020-12-25T05:19:34.875998Z 0 [Warning] Changed limits: table_open_cache: 2467 (requested 12288)
2020-12-25T05:19:35.032930Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2020-12-25T05:19:35.033957Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-32) starting as process 22039 ...
2020-12-25T05:19:35.039554Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-12-25T05:19:35.039598Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-12-25T05:19:35.039602Z 0 [Note] InnoDB: Uses event mutexes
2020-12-25T05:19:35.039605Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-12-25T05:19:35.039608Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-12-25T05:19:35.039611Z 0 [Note] InnoDB: Using Linux native AIO
2020-12-25T05:19:35.039798Z 0 [Note] InnoDB: Number of pools: 1
2020-12-25T05:19:35.039883Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-12-25T05:19:35.041640Z 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 8, chunk size = 128M
2020-12-25T05:19:35.097806Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-25T05:19:35.111665Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-12-25T05:19:35.131587Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2020-12-25T05:19:35.169615Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-12-25T05:19:35.178493Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 389077222946
2020-12-25T05:19:35.178533Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 389077230270
2020-12-25T05:19:35.178672Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 389077222946 and the end 389077230270.
2020-12-25T05:19:35.178864Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2020-12-25T05:19:40.304649Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2020-12-25T05:19:40.304702Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2020-12-25T05:19:40.304713Z 0 [ERROR] Failed to initialize builtin plugins.
2020-12-25T05:19:40.304723Z 0 [ERROR] Aborting
2020-12-25T05:19:41.362784Z 0 [Warning] Changed limits: max_open_files: 5000 (requested 24642)
2020-12-25T05:19:41.363125Z 0 [Warning] Changed limits: table_open_cache: 2467 (requested 12288)
2020-12-25T05:19:41.517045Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2020-12-25T05:19:41.518182Z 0 [Note] /usr/sbin/mysqld (mysqld 5.7.29-32) starting as process 22104 ...
2020-12-25T05:19:41.524651Z 0 [Note] InnoDB: PUNCH HOLE support available
2020-12-25T05:19:41.524696Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2020-12-25T05:19:41.524700Z 0 [Note] InnoDB: Uses event mutexes
2020-12-25T05:19:41.524704Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2020-12-25T05:19:41.524708Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
2020-12-25T05:19:41.524711Z 0 [Note] InnoDB: Using Linux native AIO
2020-12-25T05:19:41.524887Z 0 [Note] InnoDB: Number of pools: 1
2020-12-25T05:19:41.524995Z 0 [Note] InnoDB: Using CPU crc32 instructions
2020-12-25T05:19:41.526750Z 0 [Note] InnoDB: Initializing buffer pool, total size = 3G, instances = 8, chunk size = 128M
2020-12-25T05:19:41.596871Z 0 [Note] InnoDB: Completed initialization of buffer pool
2020-12-25T05:19:41.613012Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
2020-12-25T05:19:41.641097Z 0 [Note] InnoDB: Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite
2020-12-25T05:19:41.680034Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2020-12-25T05:19:41.689377Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 389077222946
2020-12-25T05:19:41.689428Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 389077230270
2020-12-25T05:19:41.689582Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 389077222946 and the end 389077230270.
2020-12-25T05:19:41.689791Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error