Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL on a FreeBSD ... how to know "who" is using what ?

Discussion in 'General Discussion' started by cass, Oct 9, 2003.

  1. cass

    cass Well-Known Member

    Jul 17, 2002
    Likes Received:
    Trophy Points:
    One of our servers is a FreeBSD ...
    that is running very nice ...
    but we would like to know, how can we track % usage of mysql on a per user or per db basis ?
    There are just a few domains on the server, and some is eating mysql ... everytime :)

    54246 mysql 42 0 52208K 24636K RUN 888:11 43.16% 43.16% mysqld

    it's average 38% now, max 45% maybe ... but It could be more soon... so I just would like to know ...
    is there ANY way I can monitor how much of this "40%" or so is every user or every database using ?

    Btw... the WHM mysql usage ... show very very little connects, just 2 ... 3 (it's very different than linux) ... so I think anything is wrong or maybe it don work as expected.

    Anyone ?

    Regards. Support Ticket Number:
  2. mickeymouse

    mickeymouse Well-Known Member

    Sep 16, 2003
    Likes Received:
    Trophy Points:
    RE: MySQL on a FreeBSD ... how to know \"who\" is using what ?

    Dear cass,

    You can use a script to track the usage of Mysql statistics. You can download a sample script from

    Customize this script as per your need. Hope this might help you to solve your problem.


Share This Page