0

Any idea of what is happening? It's swapping, but why the 30 mysql instances?

enter image description here

Improve this question
3
  • What OS / version? I suspect those are threads of a single MYSQL process. Commented Feb 18, 2013 at 16:35
  • 2
    Also see if you have some long running queries. e.g. mysqladmin processlist Commented Feb 18, 2013 at 16:49
  • thank you for the long queries suggestion, i will check that once that the load returns to abnormal. I don't really think mysql to be the bottleneck, but i will try to debug that. Commented Feb 18, 2013 at 17:41

1 Answer 1

Reset to default
0

As htop indicates, you system seems to hang into huge iowait. The 30 mysql instances are probably because you got 30 connections to your mysql server.

Improve this answer
2
  • It's a ssd only server, I don't understand how that is possible. Commented Feb 18, 2013 at 16:08
  • 1
    Can you maybe post output of iotop and/or vmstat, iostat? Commented Feb 18, 2013 at 16:16

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.