Can anybody let me know exactly what the information below means or states? I am a fantasy acquainted with MySQL. This info is originating from my hosting provider. I am particularly thinking about exactly what the command and time comment means or perhaps is letting them know.

Considering the present mysql process list, we now have observed following threads related for your requirements:

 Id  User   Host  db  Command  Time  Condition  Info 

 4655267  abc  localhost  abc  Sleep    111  

 4655961  abc  localhost  abc  Sleep    8    

 4654241  abc  localhost  abc  Sleep    126  

 4655961  abc  localhost  abc  Sleep    38   

Here's more detailed information on the problem:

I have lately encounter a scenario with my hosting that is shared provider regarding my MySQL usage. The page in reference continues to be ready to go for pretty much 24 months without problem until 2 days ago once they stated it had been utilizing excessive assets and putting strain on server, which makes it unstable. Our website traffic and stats happen to be exactly the same going back 9 several weeks and most likely longer.

They have provide me with a few information after dragging it of these, but my questions are:

  1. is excessive resource usage?
  2. why after 24 months will it be an problem out of the blue?
  3. despite the page was disabled going back 2.five days the resource usage on MySQL either continued to be exactly the same or increased, same with the problem really associated with my page or something like that else?
  4. exactly what does the procedure list let me know?
  5. what might I actually do to solve this problem?

Here's some info they've provided:

CPU: .06 %

Memory: .17 %

Mysql: 1.two percent

Top Process   %CPU 3.   /usr/php4/bin/php / specific file title

Top Process   %CPU 1.5   /usr/php4/bin/php / specific file title

The problem together with your account is of high MySQL usage. The typical using other account is .2% of MySQL whereas your bank account is consuming a lot more than 1%.

Considering the present mysql process list, we now have observed following threads related for your requirements:

+ Id  User   Host  db  Command  Time  Condition  Info 

 4655267  abc  localhost  abc  Sleep    111  

 4655961  abc  localhost  abc  Sleep    8    

 4654241  abc  localhost  abc  Sleep    126  

 4655961  abc  localhost  abc  Sleep    38   

Please make certain that the account is getting only 2-3 synchronised mysql connections in a single some time and you still optimize your connection strings for connection pooling also make certain that all the connections are correctly ended after their utilization with no connections remain as "idle-open".

I have checked the resource usage during the last 7 days and this is exactly what it states for MySQL. Strange the usage went up or continued to be exactly the same because the page is no more active and has not been going back 2.five days.

1/21/11 : Quantity of MySQL procs (average) - 1.19

1/20/11 : Quantity of MySQL procs (average) - 1.24

1/19/11 : Quantity of MySQL procs (average) - 1.20

1/18/11 : Quantity of MySQL procs (average) - 1.18

1/17/11 : Quantity of MySQL procs (average) - 1.13

1/16/11 : Quantity of MySQL procs (average) - 1.08

1/15/11 : Quantity of MySQL procs (average) - 1.09