Assembla home | Assembla project page
 

Changeset 14

Show
Ignore:
Timestamp:
08/12/07 19:11:35 (1 year ago)
Author:
major
Message:

Minor divide by zero error in query cache calculations

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • mysqltuner.pl

    r13 r14  
    285285    if ($mysqlvermajor > 3) { 
    286286        $mycalc{'query_cache_efficiency'} = sprintf("%.1f",($mystat{'Qcache_hits'} / ($mystat{'Com_select'} + $mystat{'Qcache_hits'})) * 100); 
    287         $mycalc{'pct_query_cache_used'} = sprintf("%.1f",100 - ($mystat{'Qcache_free_memory'} / $myvar{'query_cache_size'}) * 100); 
    288         if ($mystat{'Qcache_lowmem_prunes'} == 0) { 
     287        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) { 
    289291            $mycalc{'query_cache_prunes_per_day'} = 0; 
    290292        } else {