davidreuss · May 25, 2011 09:17 · davidreuss · May 31, 2011
diff --git a/mysql_qps.sql b/mysql_qps.sql
 SELECT MAX(                                         -- use MAX to force aggregation
           IF(variable_name='Questions'             -- no. of queries sent to server
           ,   CAST(variable_value AS unsigned)     -- make integer value
           ,   0                                    -- ignore if not 'Questions'
           )
       )
 /                                                   -- divide by
       MAX(                                         -- use MAX to force aggregation
           IF(variable_name='Uptime'                -- no. of seconds the server is up
           ,   CAST(variable_value AS unsigned)     -- make integer value
           ,   0                                    -- ignore if not 'Uptime'
           )
       ) AS queries_per_second
 FROM   information_schema.GLOBAL_STATUS 
 WHERE  variable_name in ('Questions', 'Uptime');
	SELECT MAX( -- use MAX to force aggregation
	IF(variable_name='Questions' -- no. of queries sent to server
	, CAST(variable_value AS unsigned) -- make integer value
	, 0 -- ignore if not 'Questions'
	)
	)
	/ -- divide by
	MAX( -- use MAX to force aggregation
	IF(variable_name='Uptime' -- no. of seconds the server is up
	, CAST(variable_value AS unsigned) -- make integer value
	, 0 -- ignore if not 'Uptime'
	)
	) AS queries_per_second
	FROM information_schema.GLOBAL_STATUS
	WHERE variable_name in ('Questions', 'Uptime');