Here is the patch to fix this issue. For some reason the fedora patch
listed fails so I did this by hand. Here is my patch:
268c268
< my @variables = Hashes("show variables");
---
> my @variables = Hashes("show /*!50002 global */ variables");
713c713
< my @recs = Hashes("show status");
---
> my @recs = Hashes("show /*!50002 global */ status");
758c758
< ## mysql> show status like 'qcache%';
---
> ## mysql> show /*!50002 global */ status like 'qcache%';
1067c1067
< my($data) = Hashes('SHOW STATUS LIKE "Questions"');
---
> my($data) = Hashes('SHOW /*!50002 GLOBAL */ STATUS LIKE "Questions"');
1129c1129
< my @data = Hashes("SHOW STATUS LIKE 'Com_%'");
---
> my @data = Hashes("SHOW /*!50002 GLOBAL */ STATUS LIKE 'Com_%'");
1200c1200
< my @rows = Hashes("SHOW VARIABLES");
---
> my @rows = Hashes("SHOW /*!50002 GLOBAL */ VARIABLES");
1219c1219
< my @rows = Hashes("SHOW STATUS");
---
> my @rows = Hashes("SHOW /*!50002 GLOBAL */ STATUS");
I am going to wrap up a .deb and host it and maybe the folks at Canonical can
include it as an update. Stay tuned.
--
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
https://bugs.launchpad.net/bugs/628998
Title:
Mytop doesn't show global statistics for MySQL 5
--
ubuntu-bugs mailing list
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
