diff options
Diffstat (limited to 'mysql-test/suite/sysschema/r/pr_statement_performance_analyzer.result')
| -rw-r--r-- | mysql-test/suite/sysschema/r/pr_statement_performance_analyzer.result | 7 |
1 files changed, 4 insertions, 3 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 |