Assembla home | Assembla project page
 

Changeset 16

Show
Ignore:
Timestamp:
08/15/07 12:30:08 (1 year ago)
Author:
major
Message:

Minor fix if no selects have been run (Thanks Kevin)

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • mysqltuner.pl

    r15 r16  
    148148} 
    149149 
    150 my (%mystat,%myvar); 
     150my (%mystat,%myvar,$dummyselect); 
    151151sub get_all_vars { 
     152    $dummyselect = `mysql $mysqllogin -Bse "SELECT VERSION();"`; 
    152153    my @mysqlvarlist = `mysql $mysqllogin -Bse "SHOW /*!50000 GLOBAL */ VARIABLES;"`; 
    153154    foreach my $line (@mysqlvarlist) { 
    …… 
    286287        $mycalc{'query_cache_efficiency'} = sprintf("%.1f",($mystat{'Qcache_hits'} / ($mystat{'Com_select'} + $mystat{'Qcache_hits'})) * 100); 
    287288        if ($myvar{'query_cache_size'}) { 
    288                $mycalc{'pct_query_cache_used'} = sprintf("%.1f",100 - ($mystat{'Qcache_free_memory'} / $myvar{'query_cache_size'}) * 100); 
    289         } 
    290        if ($mystat{'Qcache_lowmem_prunes'} == 0) { 
     289            $mycalc{'pct_query_cache_used'} = sprintf("%.1f",100 - ($mystat{'Qcache_free_memory'} / $myvar{'query_cache_size'}) * 100); 
     290        } 
     291    if ($mystat{'Qcache_lowmem_prunes'} == 0) { 
    291292            $mycalc{'query_cache_prunes_per_day'} = 0; 
    292293        } else {