← Back to branch summary

~percona-dev/percona-server/release-5.1.51-11-fix-bug-661354

« back to all changes in this revision

Viewing changes to mysql-test/response-time-distribution.patch/percona_query_response_time_show.inc

  • Committer: Aleksandr Kuzminsky
  • Date: 2010-10-09 06:15:31 UTC
  • Revision ID: aleksandr.kuzminsky@percona.com-20101009061531-eu06zwg7qi0061u5
mysql-tests are are adjusted for XtraDB version 11

Show diffs side-by-side

added added

removed removed

Lines of Context:
mysql-test/response-time-distribution.patch/percona_query_response_time_show.inc
1
 
SELECT d.count,
2
 
(SELECT SUM(a.count) FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as a WHERE a.count != 0) as query_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,
5
 
(SELECT COUNT(*)     FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME) as region_count
6
 
FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME as d WHERE d.count > 0;
7
 
SELECT COUNT(*) as region_count FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;
8
 
SELECT time FROM INFORMATION_SCHEMA.QUERY_RESPONSE_TIME;