mysqltuner

get_vars_from_server() uses GLOBAL in incorrect versions

Series 2.0
Bug #530285

Bug #530285 reported by Ryan Lowe on 2010-03-01

This bug affects 1 person

Affects		Status	Importance	Assigned to	Milestone
	mysqltuner	New	Undecided	Sheeri K. Cabral	mysqltuner mysqltuner-2.1-rev17
	2.0	New	Undecided	Sheeri K. Cabral	mysqltuner mysqltuner-2.1-rev17

Bug Description

    150 sub get_vars_from_server() {
    151 if ($opt{debug}) { print "using SHOW commands on the live database\n"; }
    152 push (@mysqlvarlist,`mysql $mysqllogin -Bse "SHOW /*!50000 GLOBAL */ VARIABLES;"`);
    153 push (@mysqlvarlist,`mysql $mysqllogin -Bse "SHOW /*!50000 GLOBAL */ STATUS;"`);
    154 }

should be:

    150 sub get_vars_from_server() {
    151 if ($opt{debug}) { print "using SHOW commands on the live database\n"; }
    152 push (@mysqlvarlist,`mysql $mysqllogin -Bse "SHOW /*!40003 GLOBAL */ VARIABLES;"`);
    153 push (@mysqlvarlist,`mysql $mysqllogin -Bse "SHOW /*!50002 GLOBAL */ STATUS;"`);
    154 }

as stated in http://dev.mysql.com/doc/refman/4.1/en/show-variables.html and http://dev.mysql.com/doc/refman/5.0/show-status.html, respectively.