Package: mtop
Version: 0.6.6-1.2
Severity: important

Mtop uses show status instead of show global status.
It's ok till mysql 5.0, but in mysql 5.1 statistics are reported 
only for current connection. For example QPS is a constant value of 2.
As noted on: http://dev.mysql.com/doc/refman/5.0/en/show-status.html

Before MySQL 5.0.2, SHOW STATUS returned global status values. 
Because the default as of 5.0.2 is to return session values, 
this is incompatible with previous versions. 
To issue a SHOW STATUS statement 
that will retrieve global status values 
for all versions of MySQL, write it like this:

SHOW /*!50002 GLOBAL */ STATUS;

Please correct this by changing from:
539 my $st_status  = $dbh->prepare("show status");
to:
539 my $st_status  = $dbh->prepare("SHOW /*!50002 GLOBAL */ STATUS");

Thank you.
  Pawel



-- 
To UNSUBSCRIBE, email to debian-bugs-dist-requ...@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmas...@lists.debian.org

Reply via email to