Plesk for Linux
kb: technical
ABT: Group A
Applicable to:
- Plesk for Linux
Symptoms
Unable to start MySQL/MariaDB service with the following error shown in a loop:
InnoDB: Waiting for the background threads to start.
Cause
MySQL/MariaDB misconfiguration.
Resolution
-
Connect to the server via SSH;
-
Edit configuration file
/etc/my.cnf(for CentOS) or/etc/mysql/my.cnf(for Ubuntu/Debian) using vi editor and add the following option in[mysqld]section:CONFIG_TEXT: innodb_purge_threads=0
Note: if the MySQL/MariaDB version is >=5.6.5, set this value to 1. MySQL/MariaDB version may be found in Tools & Settings > Server Components.
-
Start MySQL/MariaDB service:
For RHEL/CentOS:
# systemctl start mariadb
For Ubuntu/Debian:
# systemctl start mysql
Additional Information
https://dev.mysql.com/doc/refman/5.6/en/innodb-parameters.html#sysvar_innodb_purge_threads
Comments
0 comments
Please sign in to leave a comment.