new too mysql_stat()

Discussion in 'MySQL' started by Dirty-Rockstar, Dec 11, 2008.

  1. #1
    
    $link=mysql_connect($host, $username, $password)or die('cannot connect'); 
    mysql_select_db($db_name)or die('cannot select DB');
    $status = explode('  ', mysql_stat($link));
    print_r($status);
    
    PHP:
    
    /*
    Array ( 
    [0] => Uptime: 1987352 
    [1] => Threads: 1 
    [2] => Questions: 51015 
    [3] => Slow queries: 0 
    [4] => Opens: 962 
    [5] => Flush tables: 1 
    [6] => Open tables: 1 
    [7] => Queries per second avg: 0.026
     ) 
    */
    
    PHP:
    learning off php.net I came across this cool function. but some I do not understand. can someone please explain what "open tables" are? it was 1, then as i kept clicking it jumped to 4. even when i logged out of the session, it stayed 4? what does opens mean? and threads? and questions? im assuming uptime is time(); that works out to be 23 days. If you dont want to answer directly, can you forward me to where this information is given. I dont mind reading but google didnt tell me much

    Thankies :)
     
    Dirty-Rockstar, Dec 11, 2008 IP
  2. Dirty-Rockstar

    Dirty-Rockstar Guest

    Messages:
    252
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    0
    #2
    I am assuming I asked a really dumb "captain obvious" question here, but if someone could take the time to answer something it would really be appreciated. I just have no clue what i am looking at.

    sorry to bump this, but i waited 24 hours.

    I hope this is ok in bumping.
     
    Dirty-Rockstar, Dec 11, 2008 IP