I have a magento on dedicated server but from the past few days the website is giving me hard times. The host provider says its because of Database & asks me to optimize the data. Which i have also optimized. Further this following command on process manager show high consumption of CPU.
"/usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/log/mysqld.log --open-files-limit=10000 --pid-file=/var/lib/mysql/xxx-xxx-xxx-xxx.webhostbox.net.pid"
Please let me know what is this command doing & where could be it is coming from. Eagerly waiting for some advise on this.