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.

how to check inactive databases on sever

Discussion in 'Workarounds and Optimization' started by ullalla, Aug 4, 2010.

  1. ullalla

    ullalla Well-Known Member

    Joined:
    Jan 20, 2006
    Messages:
    192
    Likes Received:
    0
    Trophy Points:
    16
    How we would come to know exact which databases are inactive at /var/lib/mysql?
     
  2. Infopro

    Infopro cPanel Sr. Product Evangelist
    Staff Member

    Joined:
    May 20, 2003
    Messages:
    14,468
    Likes Received:
    196
    Trophy Points:
    63
    Location:
    Pennsylvania
    cPanel Access Level:
    Root Administrator
    Twitter:
    I suppose the date on the database itself in /var/lib/mysql/ would let you know this. There is no tool in cPanel that I'm aware of to check inactive databases, only inactive active accounts. (via WHM > Account Functions > Show Active and Inactive accounts.)
     
  3. B12Org

    B12Org Well-Known Member

    Joined:
    Jul 15, 2003
    Messages:
    692
    Likes Received:
    1
    Trophy Points:
    18
    Location:
    Seattle Washington
    cPanel Access Level:
    Root Administrator
    you could also parse the mysql log to see which databases have had conections or which users in mysql table have connected.
     
Loading...
Similar Threads - check inactive databases
  1. ziGuy
    Replies:
    4
    Views:
    1,342

Share This Page