What is long-query-time?
Mostly unuptimized filters or joins with most/all data in memory (no IO). e.g. LIKE '%xxx%', or condtions without index, joins without index. EXPLAIN will help on the querys, other stats data will help find the cpu spikes
Set 0 and repeat the check in a couple of hours
Yes I done explain and queries are fine .we are getting cpu spike at particular time
It can be but not necessarily. In general, 1) mySQL is intended to be used like this, so it is prepared. 2) there is no way and reason to avoid this style of working with a DB.
In general, this is quite normal
Обсуждают сегодня