|
From: <cl...@hy...> - 2007-03-28 23:42:58
|
Author: clee Date: 2007-03-28 15:42:55 -0800 (Wed, 28 Mar 2007) New Revision: 3946 URL: http://svn.hyperic.org/?view=rev&root=Hyperic+HQ&revision=3946 Modified: branches/HQ_3_0/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. [merge from HEAD] Modified: branches/HQ_3_0/plugins/mysql/src/org/hyperic/hq/plugin/mysql/MySQLMeasurementPlugin.java =================================================================== --- branches/HQ_3_0/plugins/mysql/src/org/hyperic/hq/plugin/mysql/MySQLMeasurementPlugin.java 2007-03-28 22:47:14 UTC (rev 3945) +++ branches/HQ_3_0/plugins/mysql/src/org/hyperic/hq/plugin/mysql/MySQLMeasurementPlugin.java 2007-03-28 23:42:55 UTC (rev 3946) @@ -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"; |