[rt-users] RT 3.6.4 poor query performance

[Toby Darling]

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.

I should point out that I've nothing to do with the MySQLTuner project, 
I've not even actually run it myself, just looked at the output with the 
guys that look after the mysql/database.

Cheers
Toby

LEGAL NOTICE
Unless expressly stated otherwise, information contained in this
message is confidential. If this message is not intended for you,
please inform postmaster at ccdc.cam.ac.uk and delete the message.
The Cambridge Crystallographic Data Centre is a company Limited
by Guarantee and a Registered Charity.
Registered in England No. 2155347 Registered Charity No. 800579
Registered office 12 Union Road, Cambridge CB2 1EZ.