← Back to branch summary

~percona-dev/percona-server/release-5.1.51-11-fixbug658274

« back to all changes in this revision

Viewing changes to mysql-test/percona_query_response_time_show.inc

  • Committer: Oleg Tsarev
  • Date: 2010-09-18 13:42:37 UTC
  • mfrom: (108.1.3 percona-server)
  • Revision ID: oleg.tsarev@percona.com-20100918134237-8hntlno9k9eaypob
propogate feature response-time-distribuion (2.0)

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/percona_query_response_time_show.inc
1
 
SELECT c.count,
 
1
SELECT d.count,
2
2
(SELECT SUM(a.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as a WHERE a.count != 0) as query_count,
3
 
(SELECT COUNT(*)     FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as b WHERE b.count != 0) as not_zero_region_count,
 
3
(SELECT SUM((b.total * 1000000) DIV 1000000) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as b WHERE b.count != 0) as query_total,
 
4
(SELECT COUNT(*)     FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as c WHERE c.count != 0) as not_zero_region_count,
4
5
(SELECT COUNT(*)     FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME) as region_count
5
 
FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as c WHERE c.count > 0;
 
6
FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as d WHERE d.count > 0;
6
7
SELECT COUNT(*) as region_count FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
7
8
SELECT time FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;