Resolved Plesk on centos 7 prob with mariaDB

[mr.kh41ry]

Hi,

We having issue with Plesk Onyx that installed on centos 7 . CPU always keep spike to 100% , when we check .. got mysql and mariadb services running on the same time. have to kill services , stop mysql and start mariadb then it will back to normal for awhile but it will happen and keep happen 3rd time on a day. Really no idea why , already disable mysql services but on the next day , it will auto start and clash with mariadb .. anyone can help ?

How to permanently disable MYSQL services and let mariadb running on single services?

 

[Monty]

You may have old init-scripts (SysV) for mysql that cause 2 instances of MySQL/MariaDB to run at the same time.

Try this:

systemctl stop mysql
systemctl stop mariadb
chkconfig --del mysql
systemctl disable mysql
systemctl disable mariadb
systemctl enable mariadb.service
systemctl start mariadb.service

This should cleanup the systemctl service config for MySQL/MariaDB

 

[mr.kh41ry]

You may have old init-scripts (SysV) for mysql that cause 2 instances of MySQL/MariaDB to run at the same time.

Try this:

systemctl stop mysql
systemctl stop mariadb
chkconfig --del mysql
systemctl disable mysql
systemctl disable mariadb
systemctl enable mariadb.service
systemctl start mariadb.service

This should cleanup the systemctl service config for MySQL/MariaDB

Hi,

I has tried that method you gived and so far CPU running as normally. Will monitor it and see how. Thank you shared the knowledge

 

[mr.kh41ry]

Hi,

Today we counter back the issue. it happen again . CPU alway spike up to 100% using by MYSQL but the services is good which is there's no conflict mysql with maria db and only 1 services is running now but CPU spike again. really no idea.

 

[mr.kh41ry]

Hi,

CPU back to normal once i retype command that provided before. hmmm. why the issue back ah.. hahaha. so far CPU back to normal now.

 

[Monty]

If you experience continuous high CPU load on the MySQL/MariaDB process then you should check what the server is doing:

plesk db "SHOW FULL PROCESSLIST"

This will show which queries are currently being processed. Repeat that command several times to see if it's always the same database that is causing the issue.

Also consider using a tool such as "mysqltuner" to get some tuning hints for your database server.

See also: Troubleshooting slow performance of the MySQL on Plesk server