I just downloaded your script (rev17) and saw the error in my output, so i wanted to report a bug, but the report was already there ;-)
mysql --version gives:
mysql Ver 14.12 Distrib 5.0.67, for suse-linux-gnu (x86_64) using readline 5.2
commandline:
mysqltuner.pl --config tuner-default_pre_5_1.cnf --recommend
has next line(s) in output:
Total sorts: 0.00
Use of uninitialized value $num in pattern match (m//) at ./mysqltuner.pl line
223 (#1)
(W uninitialized) An undefined value was used as if it were already
defined. It was interpreted as a "" or a 0, but maybe it was a mistake.
To suppress this warning assign a defined value to your variables.
To help you figure out what was undefined, perl will try to tell you the
name of the variable (if any) that was undefined. In some cases it cannot
do this, so it also tells you what operation you used the undefined value
in. Note, however, that perl optimizes your program and the operation
displayed in the warning may not necessarily appear literally in your
program. For example, "that $foo" is usually optimized into "that "
. $foo, and the warning will refer to the concatenation (.) operator,
even though there is no . in your program.
Use of uninitialized value $compval in concatenation (.) or string at ./mysqltuner.pl line 230 (#1)
Use of uninitialized value in string eq at ./mysqltuner.pl line 231 (#1)
% sorts that cause temporary tables:
sort_buffer_size: 2.0 Mb
r
I just downloaded your script (rev17) and saw the error in my output, so i wanted to report a bug, but the report was already there ;-)
mysql --version gives:
mysql Ver 14.12 Distrib 5.0.67, for suse-linux-gnu (x86_64) using readline 5.2
commandline: pre_5_1. cnf --recommend
mysqltuner.pl --config tuner-default_
has next line(s) in output:
Total sorts: 0.00
Use of uninitialized value $num in pattern match (m//) at ./mysqltuner.pl line
223 (#1)
(W uninitialized) An undefined value was used as if it were already
defined. It was interpreted as a "" or a 0, but maybe it was a mistake.
To suppress this warning assign a defined value to your variables.
To help you figure out what was undefined, perl will try to tell you the
name of the variable (if any) that was undefined. In some cases it cannot
do this, so it also tells you what operation you used the undefined value
in. Note, however, that perl optimizes your program and the operation
displayed in the warning may not necessarily appear literally in your
program. For example, "that $foo" is usually optimized into "that "
. $foo, and the warning will refer to the concatenation (.) operator,
even though there is no . in your program.
Use of uninitialized value $compval in concatenation (.) or string at
./mysqltuner. pl line 230 (#1)
Use of uninitialized value in string eq at ./mysqltuner.pl line 231 (#1)
% sorts that cause temporary tables:
sort_buffer_size: 2.0 Mb
r