Не стартует mysql с ошибкой в логе:
[System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.25) starting as process 219
[System] [MY-013576] [InnoDB] InnoDB initialization has started.
[Warning] [MY-012582] [InnoDB] io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
[Warning] [MY-012583] [InnoDB] io_setup() attempt 1.
[Warning] [MY-012583] [InnoDB] io_setup() attempt 2.
[Warning] [MY-012583] [InnoDB] io_setup() attempt 3.
[Warning] [MY-012583] [InnoDB] io_setup() attempt 4.
[Warning] [MY-012583] [InnoDB] io_setup() attempt 5.
[ERROR] [MY-012584] [InnoDB] io_setup() failed with EAGAIN after 5 attempts.
[ERROR] [MY-012954] [InnoDB] Cannot initialize AIO sub-system
[ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
[ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
[ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
[ERROR] [MY-010119] [Server] Aborting
[System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.25) MySQL Community Server - GPL.
Это связано с лимитом aio-max-nr. Увеличиваем его временно командой:
sysctl -w fs.aio-max-nr=524288
Если после этого mysql запускается (systemctl restart mysql) то можем применить лимит. Для этого в файле /etc/sysctl.conf добавляем строку fs.aio-max-nr=524288
vim /etc/sysctl.conf
fs.aio-max-nr=524288
Сохраняем изменения, применяем их в системе и перезагружаем mysql
sysctl -p /etc/sysctl.conf
systemctl restart mysql
Готово 🙂