get_vars_from_server() uses GLOBAL in incorrect versions

Bug #530285 reported by Ryan Lowe
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
mysqltuner
Undecided
Sheeri K. Cabral
2.0
Undecided
Sheeri K. Cabral

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.

Changed in mysqltuner:
assignee: nobody → Sheeri K. Cabral (awfief)
Changed in mysqltuner:
milestone: none → mysqltuner-2.1-rev17
Revision history for this message
Sheeri K. Cabral (awfief) wrote :

Thanx for the bug report! This has been fixed in version 17, which can be downloaded here:

http://launchpad.net/mysqltuner/2.0/mysqltuner-2.1-rev17/+download/mysqltuner-2.1-rev17.tar.gz

To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers