summaryrefslogtreecommitdiffstats
path: root/mysql-test/include/check_key_reads.inc
diff options
context:
space:
mode:
Diffstat (limited to 'mysql-test/include/check_key_reads.inc')
-rw-r--r--mysql-test/include/check_key_reads.inc6
1 files changed, 6 insertions, 0 deletions
diff --git a/mysql-test/include/check_key_reads.inc b/mysql-test/include/check_key_reads.inc
new file mode 100644
index 00000000..cfb754bc
--- /dev/null
+++ b/mysql-test/include/check_key_reads.inc
@@ -0,0 +1,6 @@
+# include file for checking if variable key_reads is zero
+let $key_reads= query_get_value(SHOW STATUS LIKE 'key_reads',Value,1);
+--disable_query_log
+eval SELECT IF($key_reads = 0, "Yes!", "No!") as 'Zero key reads?';
+FLUSH STATUS;
+--enable_query_log