Mysql query tracking

Discussion in 'Traffic Analysis' started by mcgurrin, Jun 10, 2011.

0
  1. #1
    I have seen some hosts proved a count of how many connections and how many queries have been made per database and I was wondering how I could do this for my own mysql servers and maybe even cap it at a certain level so that I could limit an account or database (either or both if fine) to x queries a month on a monthly scale instead of the hourly limits built in.
     
    mcgurrin, Jun 10, 2011 IP
  2. stardust.x7

    stardust.x7 Active Member

    Messages:
    369
    Likes Received:
    3
    Best Answers:
    1
    Trophy Points:
    90
    #2
    If you are using cPanel servers, you might use WatchMySQL plugin to cap/see the mysql query per account holders.
     
    stardust.x7, Jun 16, 2011 IP
  3. mcgurrin

    mcgurrin Greenhorn

    Messages:
    30
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    16
    #3
    I am not using cpanel but I might consider it if I have to and it does not cost to much for this. I would vastly prefer a free solution, preferably open source.
     
    mcgurrin, Jun 17, 2011 IP