#4 MySQL plugin is broken on 5.0 and newer versions

[Justin Swanhart]

The MySQL plugin (query.c) issues 'SHOW STATUS' instead of 'SHOW GLOBAL STATUS':

FROM THE MYSQL MANUAL: http://dev.mysql.com/doc/refman/5.0/en/show-status.html

Note

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;

Update query.c to use 'SHOW /*!50002 GLOBAL */ STATUS;' instead of 'SHOW STATUS'