Assembla home | Assembla project page
 

Changeset 30

Show
Ignore:
Timestamp:
02/01/08 00:55:34 (10 months ago)
Author:
major
Message:

Corrected the total key buffer calculation when symlinks are used
Went to traditional versioning scheme starting at 0.8.0

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • mysqltuner.pl

    r29 r30  
    11#!/usr/bin/perl -w 
    2 # mysqltuner.pl - Version 20080115 
     2# mysqltuner.pl - Version 0.8.0 
    33# High Performance MySQL Tuning Script 
    44# Copyright (C) 2006-2008 Major Hayden - major@mhtx.net 
     
    372372                $mycalc{'pct_keys_from_mem'} = sprintf("%.1f",(100 - (($mystat{'Key_reads'} / $mystat{'Key_read_requests'}) * 100))); 
    373373        } 
    374         $mycalc{'total_myisam_indexes'} = `find $myvar{'datadir'} -name '*.MYI' 2>&1 | xargs du $duflags '{}' 2>&1 | awk '{ s += \$1 } END { print s }'`; 
     374        $mycalc{'total_myisam_indexes'} = `find $myvar{'datadir'} -name '*.MYI' 2>&1 | xargs du -L $duflags '{}' 2>&1 | awk '{ s += \$1 } END { print s }'`; 
    375375        if ($mycalc{'total_myisam_indexes'} =~ /^0\n$/) { $mycalc{'total_myisam_indexes'} = "fail"; } 
    376376        chomp($mycalc{'total_myisam_indexes'});