diff options
Diffstat (limited to 'mysql-test/suite/perfschema_stress/t/read.test')
| -rw-r--r-- | mysql-test/suite/perfschema_stress/t/read.test | 40 |
1 files changed, 40 insertions, 0 deletions
diff --git a/mysql-test/suite/perfschema_stress/t/read.test b/mysql-test/suite/perfschema_stress/t/read.test new file mode 100644 index 00000000..c963adeb --- /dev/null +++ b/mysql-test/suite/perfschema_stress/t/read.test @@ -0,0 +1,40 @@ +# The include statement below is a temp one for tests that are yet to +#be ported to run with InnoDB, +#but needs to be kept for tests that would need MyISAM in future. +--source include/force_myisam_default.inc + +--source include/not_embedded.inc +--source include/have_perfschema.inc + +SELECT * FROM performance_schema.setup_instruments +WHERE ENABLED='NO' AND TIMED='NO'; + +SELECT * FROM performance_schema.events_waits_current +WHERE (TIMER_END - TIMER_START != TIMER_WAIT); + +SELECT * FROM performance_schema.events_waits_history +WHERE SPINS != NULL; + +SELECT * FROM performance_schema.processlist p, + performance_schema.events_waits_current e +WHERE p.THREAD_ID = e.THREAD_ID + AND TIMER_START = 0 +ORDER BY e.EVENT_ID; + +SELECT * FROM performance_schema.events_waits_current +WHERE THREAD_ID IN (SELECT THREAD_ID + FROM performance_schema.processlist + ORDER BY THREAD_ID) + AND TIMER_END = 0 + AND TIMER_WAIT != NULL +ORDER BY EVENT_ID; + +--disable_result_log +SELECT SUM(COUNT_READ) AS sum_count_read, + SUM(COUNT_WRITE) AS sum_count_write, + SUM(SUM_NUMBER_OF_BYTES_READ) AS sum_num_bytes_read, + SUM(SUM_NUMBER_OF_BYTES_WRITE) AS sum_num_bytes_write +FROM performance_schema.file_summary_by_instance +WHERE FILE_NAME LIKE CONCAT('%', @@tmpdir, '%') ORDER BY NULL; +--enable_result_log + |