Results 1 to 6 of 6
  1. #1

    view what script is doing what live in mysql

    how do i get a live reading of what script is doing what in mysql, the mysql usage feature in whm gives an average for the day.

    i saw someone post something once along the lines of

    Top Process %CPU 9.9 httpd [www.domain.com] [/script.php?idusername&stimg]


    how do i get a breakdown like that?

    also i just looked at top and had 180 sleeping processes, that's not right is it?

  2. #2
    Join Date
    Oct 2002
    Posts
    702
    ServerMatingProject.com
    The World's first server mating experiment
    We give new meaning to I/O intensive and hot swap

  3. #3
    thankyou

  4. #4
    is it bad to have sleeping processes? i see some that have been sleeping for ages and ages?

  5. #5
    Join Date
    Oct 2002
    Posts
    702
    No thats not a problem. Just how mysql does its business. Press "i" on your keyboard for it not to show the sleeping processes.
    ServerMatingProject.com
    The World's first server mating experiment
    We give new meaning to I/O intensive and hot swap

  6. #6
    You need to setup mysql low timeout values in mysql config file, so then mysql processes will not sleep too much and will be finished quickly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •