[Hyperic-hq-discuss] hq r3945 - trunk/plugins/mysql/src/org/hyperic/hq/plugin/mysql

[<cl...@hy...>]

Author: clee
Date: 2007-03-28 14:47:14 -0800 (Wed, 28 Mar 2007)
New Revision: 3945
URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3945

Modified:
   trunk/plugins/mysql/src/org/hyperic/hq/plugin/mysql/MySQLMeasurementPlugin.java
Log:
The GLOBAL and SESSION  options are new in MySQL 5.0.2. With the GLOBAL modifier,
SHOW STATUS displays the status values for all connections to MySQL.
With SESSION, it displays the status values for the current connection.
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.

Modified: trunk/plugins/mysql/src/org/hyperic/hq/plugin/mysql/MySQLMeasurementPlugin.java
===================================================================
--- trunk/plugins/mysql/src/org/hyperic/hq/plugin/mysql/MySQLMeasurementPlugin.java	2007-03-28 21:41:37 UTC (rev 3944)
+++ trunk/plugins/mysql/src/org/hyperic/hq/plugin/mysql/MySQLMeasurementPlugin.java	2007-03-28 22:47:14 UTC (rev 3945)
@@ -53,7 +53,7 @@
     static final String JDBC_DRIVER = "com.mysql.jdbc.Driver";
 
     // Measurement Queries
-    private static final String STATUSQUERY = "SHOW STATUS LIKE ";
+    private static final String STATUSQUERY = "SHOW /*!50002 GLOBAL */ STATUS LIKE ";
     private static final String TABLEQUERY  = "SHOW TABLE STATUS LIKE %table%";
     private static final String INDEXQUERY  = "SHOW INDEX FROM %table%";
     private static final String DBQUERY     = "SHOW TABLE STATUS";