[rt-users] RT 3.6.4 poor query performance

[Graham Dunn]

Toby Darling wrote:
> Hi Richard
> 
>> That crashes out with a divide by zero error in the scripting, but it 
>> looks really cool.
>>
>> [--] Status: +Archive -BDB -Federated +InnoDB -ISAM -NDBCluster
>> [--] Data in MyISAM tables: 2M (Tables: 39)
>> [--] Data in InnoDB tables: 1015M (Tables: 20)
>> Use of uninitialized value in division (/) at ./mysqltuner.pl line 362 (#1)
>>
>> Illegal division by zero at ./mysqltuner.pl line 362 (#2)
>>    (F) You tried to divide a number by 0.  Either something was wrong in
>>    your logic, or you need to put a conditional in to guard against
>>    meaningless input.
> 
> That indicates something went wrong earlier in getting $physical_memory 
> (assuming you're using v0.8.6). Any error messages or warnings at the 
> start?. Try chucking some print statements in the os_setup function to 
> see where it's going wrong.

If you're running under FreeBSD < 7 (I think), change:

         } elsif ($os =~ /BSD/) {^M
                 $physical_memory = `sysctl -n hw.realmem`;^M
                 $swap_memory = `swapinfo | grep '^/' | awk '{ s+= \$2 } 
END { print s }'`;^M

to

         } elsif ($os =~ /BSD/) {^M
                 $physical_memory = `sysctl -n hw.physmem`;^M
                 $swap_memory = `swapinfo | grep '^/' | awk '{ s+= \$2 } 
END { print s }'`;^M