diff options
Diffstat (limited to 'mysql-test/suite/sysschema')
-rw-r--r-- | mysql-test/suite/sysschema/r/pr_statement_performance_analyzer.result | 7 | ||||
-rw-r--r-- | mysql-test/suite/sysschema/t/pr_statement_performance_analyzer.test | 5 |
2 files changed, 7 insertions, 5 deletions
diff --git a/mysql-test/suite/sysschema/r/pr_statement_performance_analyzer.result b/mysql-test/suite/sysschema/r/pr_statement_performance_analyzer.result index c7bb029da39..34dc57b2659 100644 --- a/mysql-test/suite/sysschema/r/pr_statement_performance_analyzer.result +++ b/mysql-test/suite/sysschema/r/pr_statement_performance_analyzer.result @@ -45,8 +45,8 @@ CALL sys.statement_performance_analyzer('delta', 'test.tmp_digests_ini', 'with_r CALL sys.statement_performance_analyzer('overall', NULL, 'analysis'); Next Output QUERY_INSERT test 2 0 0 LATENCY LATENCY LATENCY LATENCY 0 0 0 0 2 1 0 0 0 0 DIGEST_INSERT FIRST_SEEN LAST_SEEN -QUERY_SELECT test * 2 0 0 LATENCY LATENCY LATENCY LATENCY 3 2 9 5 0 0 0 0 2 0 DIGEST_SELECT FIRST_SEEN LAST_SEEN -QUERY_UPDATE test 2 0 0 LATENCY LATENCY LATENCY LATENCY 0 0 2 1 2 1 0 0 0 0 DIGEST_UPDATE FIRST_SEEN LAST_SEEN +QUERY_SELECT test * 2 0 0 LATENCY LATENCY LATENCY LATENCY 3 2 10 5 0 0 0 0 2 0 DIGEST_SELECT FIRST_SEEN LAST_SEEN +QUERY_UPDATE test * 2 0 0 LATENCY LATENCY LATENCY LATENCY 0 0 2 1 2 1 0 0 0 0 DIGEST_UPDATE FIRST_SEEN LAST_SEEN Top 100 Queries Ordered by Total Latency query db full_scan exec_count err_count warn_count total_latency max_latency avg_latency lock_latency rows_sent rows_sent_avg rows_examined rows_examined_avg rows_affected rows_affected_avg tmp_tables tmp_disk_tables rows_sorted sort_merge_passes digest first_seen last_seen CALL sys.statement_performance_analyzer('delta', 'test.tmp_digests_ini', 'analysis'); @@ -68,7 +68,8 @@ CALL sys.statement_performance_analyzer('overall', NULL, 'with_full_table_scans' Next Output Top 100 Queries with Full Table Scan query db exec_count total_latency no_index_used_count no_good_index_used_count no_index_used_pct rows_sent rows_examined rows_sent_avg rows_examined_avg first_seen last_seen digest -QUERY_SELECT test 2 LATENCY 1 0 50 3 9 2 5 FIRST_SEEN LAST_SEEN DIGEST_SELECT +QUERY_SELECT test 2 LATENCY 2 0 100 3 10 2 5 FIRST_SEEN LAST_SEEN DIGEST_SELECT +QUERY_UPDATE test 2 LATENCY 1 0 50 0 2 0 1 FIRST_SEEN LAST_SEEN DIGEST_UPDATE CALL sys.statement_performance_analyzer('delta', 'test.tmp_digests_ini', 'with_full_table_scans'); Next Output Top 100 Queries with Full Table Scan diff --git a/mysql-test/suite/sysschema/t/pr_statement_performance_analyzer.test b/mysql-test/suite/sysschema/t/pr_statement_performance_analyzer.test index b8932381e52..96b59a55e6d 100644 --- a/mysql-test/suite/sysschema/t/pr_statement_performance_analyzer.test +++ b/mysql-test/suite/sysschema/t/pr_statement_performance_analyzer.test @@ -155,9 +155,10 @@ CALL sys.statement_performance_analyzer('delta', 'test.tmp_digests_ini', 'analys CALL sys.statement_performance_analyzer('overall', NULL, 'with_errors_or_warnings'); CALL sys.statement_performance_analyzer('delta', 'test.tmp_digests_ini', 'with_errors_or_warnings'); ---replace_result $query_select QUERY_SELECT $digest_select DIGEST_SELECT $o_sel_total_latency LATENCY $o_sel_first_seen FIRST_SEEN $o_sel_last_seen LAST_SEEN +--replace_column 4 LATENCY +--replace_result $query_select QUERY_SELECT $digest_select DIGEST_SELECT $o_sel_first_seen FIRST_SEEN $o_sel_last_seen LAST_SEEN $digest_update DIGEST_UPDATE $query_update QUERY_UPDATE $o_upd_first_seen FIRST_SEEN $o_upd_last_seen LAST_SEEN CALL sys.statement_performance_analyzer('overall', NULL, 'with_full_table_scans'); ---replace_result $query_select QUERY_SELECT $digest_select DIGEST_SELECT $d_sel_total_latency LATENCY $o_sel_first_seen FIRST_SEEN $o_sel_last_seen LAST_SEEN +--replace_result $query_select QUERY_SELECT $digest_select DIGEST_SELECT $d_sel_total_latency LATENCY $o_sel_first_seen FIRST_SEEN $o_sel_last_seen LAST_SEEN CALL sys.statement_performance_analyzer('delta', 'test.tmp_digests_ini', 'with_full_table_scans'); --replace_result $query_select QUERY_SELECT $digest_select DIGEST_SELECT $o_sel_total_latency LATENCY $o_sel_first_seen FIRST_SEEN $o_sel_last_seen LAST_SEEN |