Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

One of mysql servers becomes slow recently, and I found that there is a high IO in the server:

$ sudo  pt-ioprofile -cell sizes
Mon Apr 29 22:39:32 CDT 2013
Tracing process ID 16934
     total      pread       read     pwrite      fsync       open      lseek filename
2147483647    1735082      64640     369248          0          0 2147483647 /var/lib/mysql/db1/estate.MYD
 889808476     524176      19420     128436          0          0  889136444 /var/lib/mysql/db2/estate.MYD
 343733731       7231        600          0          0          0  343725900 /var/lib/mysql/db2/cmsuser.MYD
  18334349       3325        180          0          0          0   18330844 /var/lib/mysql/db1/cmsuser.MYD
    104076          0          0     104076          0          0          0 /var/lib/mysql/db1/estate.MYI
     98304          0          0      98304          0          0          0 /var/lib/mysql/ibdata1
     34300          0          0      34300          0          0          0 /var/lib/mysql/db2/estate.MYI
      1024          0          0       1024          0          0          0 /var/lib/mysql/ib_logfile1
       512          0          0        512          0          0          0 /var/lib/mysql/ib_logfile0
         0          0          0          0          0          0          0 /etc/hosts.deny
         0          0          0          0          0          0          0 /etc/hosts.allow

However, when I enter show process in the server, I found no active process!

What's possibly going on here?

share|improve this question
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.