MySQL high cpu/memory usage

preview_player
Показать описание
In case your MySQL service is running constantly at high cpu or memory, something could be wrong. It could be as much as a single query causing a problem.

The best way to find and resolve the problem is to check what MySQL processes are running and depending on what they are doing, the time they are running for, etc. you can find the issue.

In this instance, I'm running MySQL installed through cPanel/WHM on Linux (CentOS) and running on /usr/sbin/mysqld.
Рекомендации по теме
Комментарии
Автор

This is an excellent tutorial for beginners for mysql memory management

navidmustafa
Автор

slow queries:5 . How to check which function is in php?

forumtradecoinviet