The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
14 views

A lot of DB process go to sleep state

I am using mytop to monitor my MariaDB. I see a lot of process go to sleep state.My DB is very high load.How can i troubleshoot this problem.We use a Phalcon framework and i think it should file with ...
0
votes
2answers
329 views

Idle connection plus schema-modifying query causing locked database

As part of our automated deployment process for a web app running on a LAMP stack, we drop all our triggers and stored procedures and recreate them from source control. It turns out there was a hidden ...
0
votes
1answer
107 views

Sleep Processes are Running Longer Than Allowed

From time to time my mysql server will run into a "too many connections" error. I believe part of the problem is large amount of sleep processes that are running, some over 1000 seconds. When ...
1
vote
2answers
567 views

MySQL: many Sleep processes

I've queried SHOW processlist as root after a server restert, and got a long list of Sleep threads: +-----+-------------+-----------------+---------+---------+------+-------+------------------+ | Id ...