|
From: <cl...@hy...> - 2007-03-28 22:47:21
|
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"; |