If you do not need to use InnoDB storage for your site databases, you can disable this type of storage to save server resources.
Open the file /etc/mysql/my.cnf and add the following lines:
innodb = OFF default-storage-engine = MyISAM
Then we save the changes and restart the mysql server.
service mysql restart
Next, look at the log / var / log / syslog for errors.
tail -200 / var / log / syslog | grep mysql
We are looking for errors, like this:
[Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1286: Unknown storage engine 'InnoDB'
If there are such errors, then turn InnoDB back. Go to the mysql server, select the database mysql> use mysql; , and change the repository for it to myisam mysql> ALTER TABLE `mysql.gtid_slave_pos` ENGINE=MyISAM; .
We do the same with everyone. After changing the storage type, you can disable innodb and restart mysql again.
How do you rate the article?
( 1 rating, average: 4.00 out of 5)
Loading...
( 1 rating, average: 4.00 out of 5) Loading...