Debian Codegraph @

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

raw
1 connect con1, localhost, root, , ;
2 drop table if exists t1;
3 create table t1(a int) engine = myisam;
4 insert into t1 values (1), (2), (3), (4), (5);
5 connection default;
6 update performance_schema.threads
7 set instrumented = 'NO'
8 where processlist_id = connection_id();
9 truncate table performance_schema.events_statements_history_long;
10 truncate table performance_schema.events_stages_history_long;
11 connection con1;
12 SET DEBUG_SYNC='RESET';
13 SET DEBUG_SYNC='copy_data_between_tables_before SIGNAL found_row WAIT_FOR wait_row EXECUTE 5';
14 ALTER TABLE t1 engine = innodb;;
15 connection default;
16 SET DEBUG_SYNC='now WAIT_FOR found_row';
17 select event_id from performance_schema.events_statements_current
18 where thread_id = @con1_thread_id into @con1_stmt_id;
19 select EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED
20 from performance_schema.events_stages_current
21 where (thread_id = @con1_thread_id);
22 EVENT_NAME WORK_COMPLETED WORK_ESTIMATED
23 stage/sql/copy to tmp table 0 5
24 SET DEBUG_SYNC='now SIGNAL wait_row';
25 SET DEBUG_SYNC='now WAIT_FOR found_row';
26 select EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED
27 from performance_schema.events_stages_current
28 where (thread_id = @con1_thread_id);
29 EVENT_NAME WORK_COMPLETED WORK_ESTIMATED
30 stage/sql/copy to tmp table 1 5
31 SET DEBUG_SYNC='now SIGNAL wait_row';
32 SET DEBUG_SYNC='now WAIT_FOR found_row';
33 select EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED
34 from performance_schema.events_stages_current
35 where (thread_id = @con1_thread_id);
36 EVENT_NAME WORK_COMPLETED WORK_ESTIMATED
37 stage/sql/copy to tmp table 2 5
38 SET DEBUG_SYNC='now SIGNAL wait_row';
39 SET DEBUG_SYNC='now WAIT_FOR found_row';
40 select EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED
41 from performance_schema.events_stages_current
42 where (thread_id = @con1_thread_id);
43 EVENT_NAME WORK_COMPLETED WORK_ESTIMATED
44 stage/sql/copy to tmp table 3 5
45 SET DEBUG_SYNC='now SIGNAL wait_row';
46 SET DEBUG_SYNC='now WAIT_FOR found_row';
47 select EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED
48 from performance_schema.events_stages_current
49 where (thread_id = @con1_thread_id);
50 EVENT_NAME WORK_COMPLETED WORK_ESTIMATED
51 stage/sql/copy to tmp table 4 5
52 SET DEBUG_SYNC='now SIGNAL wait_row';
53 connection con1;
54 select "After payload";
55 After payload
56 After payload
57 connection default;
58 # Dumping ALTER TABLE stages
59 select EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED
60 from performance_schema.events_stages_history_long
61 where (thread_id = @con1_thread_id)
62 and (nesting_event_id = @con1_stmt_id)
63 order by thread_id, event_id;
64 EVENT_NAME WORK_COMPLETED WORK_ESTIMATED
65 stage/sql/starting NULL NULL
66 stage/sql/checking permissions NULL NULL
67 stage/sql/init for update NULL NULL
68 stage/sql/Opening tables NULL NULL
69 stage/sql/After opening tables NULL NULL
70 stage/sql/setup NULL NULL
71 stage/sql/creating table NULL NULL
72 stage/sql/After create NULL NULL
73 stage/sql/System lock NULL NULL
74 stage/sql/table lock NULL NULL
75 stage/sql/After create NULL NULL
76 stage/sql/copy to tmp table 5 5
77 stage/sql/Enabling keys NULL NULL
78 stage/sql/Unlocking tables NULL NULL
79 stage/sql/Enabling keys NULL NULL
80 stage/sql/Apply log event NULL NULL
81 stage/sql/After apply log event NULL NULL
82 stage/sql/Rename result table NULL NULL
83 stage/sql/End of update loop NULL NULL
84 stage/sql/Query end NULL NULL
85 stage/sql/closing tables NULL NULL
86 stage/sql/Query end NULL NULL
87 stage/sql/Starting cleanup NULL NULL
88 stage/sql/Freeing items NULL NULL
89 stage/sql/Reset for next command NULL NULL
90 SET DEBUG_SYNC='RESET';
91 connection con1;
92 drop table t1;
93 disconnect con1;
94 connection default;
95 update performance_schema.threads
96 set instrumented = 'YES'
97 where processlist_id = connection_id();