diff options
Diffstat (limited to 'mysql-test/suite/perfschema/include/show_aggregate.inc')
| -rw-r--r-- | mysql-test/suite/perfschema/include/show_aggregate.inc | 26 |
1 files changed, 13 insertions, 13 deletions
diff --git a/mysql-test/suite/perfschema/include/show_aggregate.inc b/mysql-test/suite/perfschema/include/show_aggregate.inc index a637e7b54dd..4489cf7a37b 100644 --- a/mysql-test/suite/perfschema/include/show_aggregate.inc +++ b/mysql-test/suite/perfschema/include/show_aggregate.inc @@ -12,7 +12,7 @@ UPDATE test.status_results sr, performance_schema.global_status sg SET sr.stop = sg.variable_value WHERE sr.variable_name = sg.variable_name AND sg.variable_name IN ('handler_delete', 'handler_rollback'); ---echo +--echo # --echo # Global deltas: END - START. UPDATE test.status_results sr SET sr.delta = sr.stop - sr.start; @@ -30,21 +30,21 @@ UPDATE test.status_results sr, performance_schema.status_by_thread sbt WHERE sr.variable_name = sbt.variable_name AND sbt.variable_name IN ('handler_delete', 'handler_rollback') AND sbt.thread_id = @con1_id; ---echo +--echo # --echo # Thread results from CON2. UPDATE test.status_results sr, performance_schema.status_by_thread sbt SET sr.t2 = sbt.variable_value WHERE sr.variable_name = sbt.variable_name AND sbt.variable_name IN ('handler_delete', 'handler_rollback') AND sbt.thread_id = @con2_id; ---echo +--echo # --echo # Thread results from CON3. UPDATE test.status_results sr, performance_schema.status_by_thread sbt SET sr.t3 = sbt.variable_value WHERE sr.variable_name = sbt.variable_name AND sbt.variable_name IN ('handler_delete', 'handler_rollback') AND sbt.thread_id = @con3_id; ---echo +--echo # --echo # Thread totals for 3 connections. UPDATE test.status_results sr SET sr.thread = sr.t1 + sr.t2 + sr.t3; @@ -58,21 +58,21 @@ UPDATE test.status_results sr, performance_schema.status_by_user sbu WHERE sr.variable_name = sbu.variable_name AND sbu.variable_name IN ('handler_delete', 'handler_rollback') AND sbu.user IN ('user1'); ---echo +--echo # --echo # User2 UPDATE test.status_results sr, performance_schema.status_by_user sbu SET sr.u2 = sbu.variable_value WHERE sr.variable_name = sbu.variable_name AND sbu.variable_name IN ('handler_delete', 'handler_rollback') AND sbu.user IN ('user2'); ---echo +--echo # --echo # User3 UPDATE test.status_results sr, performance_schema.status_by_user sbu SET sr.u3 = sbu.variable_value WHERE sr.variable_name = sbu.variable_name AND sbu.variable_name IN ('handler_delete', 'handler_rollback') AND sbu.user IN ('user3'); ---echo +--echo # --echo # Status totals for 3 users. UPDATE test.status_results sr SET sr.user = sr.u1 + sr.u2 + sr.u3; @@ -80,14 +80,14 @@ UPDATE test.status_results sr --echo #=========================== --echo # Status by host (localhost) --echo #=========================== ---echo +--echo # --echo # host1 = localhost UPDATE test.status_results sr, performance_schema.status_by_host sbh SET sr.h1 = sbh.variable_value WHERE sr.variable_name = sbh.variable_name AND sbh.variable_name IN ('handler_delete', 'handler_rollback') AND sbh.host IN ('localhost'); ---echo +--echo # --echo # Status totals for 'localhost' only. UPDATE test.status_results sr SET sr.host = sr.h1 + sr.h2 + sr.h3; @@ -101,22 +101,22 @@ UPDATE test.status_results sr, performance_schema.status_by_account sba WHERE sr.variable_name = sba.variable_name AND sba.variable_name IN ('handler_delete', 'handler_rollback') AND sba.user IN ('user1'); ---echo +--echo # --echo # User2@localhost UPDATE test.status_results sr, performance_schema.status_by_account sba SET sr.a2 = sba.variable_value WHERE sr.variable_name = sba.variable_name AND sba.variable_name IN ('handler_delete', 'handler_rollback') AND sba.user IN ('user2'); ---echo +--echo # --echo # User3@localhost UPDATE test.status_results sr, performance_schema.status_by_account sba SET sr.a3 = sba.variable_value WHERE sr.variable_name = sba.variable_name AND sba.variable_name IN ('handler_delete', 'handler_rollback') AND sba.user IN ('user3'); ---echo ---echo +--echo # +--echo # --echo # Status totals for 3 accounts. UPDATE test.status_results sr SET sr.acct = sr.a1 + sr.a2 + sr.a3; |