Resolved Mysql uses high CPU resources

[ismail el moussati]

Hi all, I got an issue that MYSQL uses very high CPU. Even website sometimes down due unavailable cpu free space.
Check this please :
mysql 20 0 1278M 140M 5788 S (this is cpu in per cent) 189. 1.8 5h14:59 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --pid-file=/var/run/mysqld/mysqld

 

[IgorG]

Try to use this KB article Plesk and websites are not accessible due to high CPU load by MySQL processes

 

[ismail el moussati]

I find out that my website db, sends from this table a lot of info. every 2-3s

How i can reduce the number of info sent by this table to 3 or 2 minutes ?

Yours,

 

[Bitpalast]

You probably can't. The software has a reason why it stores data frequently. This is not a problem of the database, but of the software design.

 

[ismail el moussati]

Hi Peter, thank you got it