Debian Codegraph @

mysql-test/suite/perfschema/r/func_file_io.result

raw
1 UPDATE performance_schema.setup_instruments SET enabled = 'NO', timed = 'YES';
2 UPDATE performance_schema.setup_instruments SET enabled = 'YES'
3 WHERE name LIKE 'wait/io/file/%';
4 update performance_schema.threads SET instrumented = 'YES'
5 WHERE PROCESSLIST_ID=connection_id();
6 truncate table performance_schema.events_statements_summary_by_digest;
7 flush status;
8 DROP TABLE IF EXISTS t1;
9 CREATE TABLE t1 (id INT PRIMARY KEY, b CHAR(100) DEFAULT 'initial value')
10 ENGINE=MyISAM;
11 INSERT INTO t1 (id) VALUES (1), (2), (3), (4), (5), (6), (7), (8);
12 TRUNCATE TABLE performance_schema.events_waits_history_long;
13 TRUNCATE TABLE performance_schema.events_waits_history;
14 TRUNCATE TABLE performance_schema.events_waits_current;
15 SELECT * FROM t1 WHERE id = 1;
16 id b
17 1 initial value
18 SET @before_count = (SELECT SUM(TIMER_WAIT)
19 FROM performance_schema.events_waits_history_long
20 WHERE (EVENT_NAME = 'wait/io/file/myisam/dfile')
21 AND (OBJECT_NAME LIKE '%t1.MYD'));
22 SELECT (@before_count >= 0) as have_before_count;
23 have_before_count
24 1
25 SELECT IF(@before_count > 0, 'Success', 'Failure') has_instrumentation;
26 has_instrumentation
27 Success
28 SELECT * FROM t1 WHERE id < 4;
29 id b
30 1 initial value
31 2 initial value
32 3 initial value
33 SET @after_count = (SELECT SUM(TIMER_WAIT)
34 FROM performance_schema.events_waits_history_long
35 WHERE (EVENT_NAME = 'wait/io/file/myisam/dfile')
36 AND (OBJECT_NAME LIKE '%t1.MYD') AND (1 = 1));
37 SELECT (@after_count >= 0) as have_after_count;
38 have_after_count
39 1
40 SELECT IF((@after_count - @before_count) > 0, 'Success', 'Failure') test_ff1_timed;
41 test_ff1_timed
42 Success
43 UPDATE performance_schema.setup_instruments SET enabled='NO';
44 SET @before_count = (SELECT SUM(TIMER_WAIT)
45 FROM performance_schema.events_waits_history_long
46 WHERE (EVENT_NAME = 'wait/io/file/myisam/dfile')
47 AND (OBJECT_NAME LIKE '%t1.MYD') AND (2 = 2));
48 SELECT (@before_count >= 0) as have_before_count;
49 have_before_count
50 1
51 SELECT * FROM t1 WHERE id < 6;
52 id b
53 1 initial value
54 2 initial value
55 3 initial value
56 4 initial value
57 5 initial value
58 SET @after_count = (SELECT SUM(TIMER_WAIT)
59 FROM performance_schema.events_waits_history_long
60 WHERE (EVENT_NAME = 'wait/io/file/myisam/dfile')
61 AND (OBJECT_NAME LIKE '%t1.MYD') AND (3 = 3));
62 SELECT (@after_count >= 0) as have_after_count;
63 have_after_count
64 1
65 SELECT IF((COALESCE(@after_count, 0) - COALESCE(@before_count, 0)) = 0, 'Success', 'Failure') test_ff2_timed;
66 test_ff2_timed
67 Success
68 UPDATE performance_schema.setup_instruments SET enabled = 'YES'
69 WHERE name LIKE 'wait/io/file/%';
70 UPDATE performance_schema.setup_instruments SET timed = 'NO';
71 TRUNCATE TABLE performance_schema.events_waits_history_long;
72 TRUNCATE TABLE performance_schema.events_waits_history;
73 TRUNCATE TABLE performance_schema.events_waits_current;
74 SELECT * FROM t1 WHERE id > 4;
75 id b
76 5 initial value
77 6 initial value
78 7 initial value
79 8 initial value
80 SELECT * FROM performance_schema.events_waits_history_long
81 WHERE TIMER_WAIT != NULL
82 OR TIMER_START != NULL
83 OR TIMER_END != NULL;
84 THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT SPINS OBJECT_SCHEMA OBJECT_NAME INDEX_NAME OBJECT_TYPE OBJECT_INSTANCE_BEGIN NESTING_EVENT_ID NESTING_EVENT_TYPE OPERATION NUMBER_OF_BYTES FLAGS
85 SELECT * FROM performance_schema.events_waits_history
86 WHERE TIMER_WAIT != NULL
87 OR TIMER_START != NULL
88 OR TIMER_END != NULL;
89 THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT SPINS OBJECT_SCHEMA OBJECT_NAME INDEX_NAME OBJECT_TYPE OBJECT_INSTANCE_BEGIN NESTING_EVENT_ID NESTING_EVENT_TYPE OPERATION NUMBER_OF_BYTES FLAGS
90 SELECT * FROM performance_schema.events_waits_current
91 WHERE TIMER_WAIT != NULL
92 OR TIMER_START != NULL
93 OR TIMER_END != NULL;
94 THREAD_ID EVENT_ID END_EVENT_ID EVENT_NAME SOURCE TIMER_START TIMER_END TIMER_WAIT SPINS OBJECT_SCHEMA OBJECT_NAME INDEX_NAME OBJECT_TYPE OBJECT_INSTANCE_BEGIN NESTING_EVENT_ID NESTING_EVENT_TYPE OPERATION NUMBER_OF_BYTES FLAGS
95 UPDATE performance_schema.setup_instruments SET timed = 'YES';
96 SELECT * FROM t1 WHERE id < 4;
97 id b
98 1 initial value
99 2 initial value
100 3 initial value
101 DROP TABLE t1;
102 SELECT SUM(COUNT_READ) AS sum_count_read,
103 SUM(COUNT_WRITE) AS sum_count_write,
104 SUM(SUM_NUMBER_OF_BYTES_READ) AS sum_num_bytes_read,
105 SUM(SUM_NUMBER_OF_BYTES_WRITE) AS sum_num_bytes_write
106 FROM performance_schema.file_summary_by_instance
107 WHERE FILE_NAME LIKE CONCAT('%', @@tmpdir, '%') ORDER BY NULL;
108 SELECT EVENT_NAME, COUNT_STAR, AVG_TIMER_WAIT, SUM_TIMER_WAIT
109 FROM performance_schema.events_waits_summary_global_by_event_name
110 WHERE COUNT_STAR > 0
111 ORDER BY SUM_TIMER_WAIT DESC
112 LIMIT 10;
113 SELECT p.processlist_user, SUM(TIMER_WAIT) SUM_WAIT
114 # ((TIME_TO_SEC(TIMEDIFF(NOW(), i.startup_time)) * 1000) / SUM(TIMER_WAIT)) * 100 WAIT_PERCENTAGE
115 FROM performance_schema.events_waits_history_long h
116 INNER JOIN performance_schema.threads p USING (THREAD_ID)
117 GROUP BY p.processlist_user
118 ORDER BY SUM_WAIT DESC
119 LIMIT 20;
120 SELECT h.EVENT_NAME, SUM(h.TIMER_WAIT) TOTAL_WAIT
121 FROM performance_schema.events_waits_history_long h
122 INNER JOIN performance_schema.threads p USING (THREAD_ID)
123 WHERE p.PROCESSLIST_ID = 1
124 GROUP BY h.EVENT_NAME
125 HAVING TOTAL_WAIT > 0;
126 SELECT p.processlist_user, h.operation, SUM(NUMBER_OF_BYTES) bytes
127 FROM performance_schema.events_waits_history_long h
128 INNER JOIN performance_schema.threads p USING (THREAD_ID)
129 GROUP BY p.processlist_user, h.operation
130 HAVING BYTES > 0
131 ORDER BY p.processlist_user, h.operation;
132 UPDATE performance_schema.setup_instruments SET enabled = 'YES', timed = 'YES';
133 show global status like "performance_schema_file_%_lost";
134 Variable_name Value
135 Performance_schema_file_classes_lost 0
136 Performance_schema_file_handles_lost 0
137 Performance_schema_file_instances_lost 0