Debian Codegraph @

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

raw
1 drop table if exists t1;
2 create table t1(a int) engine = myisam;
3 insert into t1 values (1), (2), (3), (4), (5);
4 alter table t1 force;
5 update performance_schema.threads
6 set instrumented = 'NO'
7 where processlist_id = connection_id();
8 truncate table performance_schema.events_statements_history_long;
9 truncate table performance_schema.events_stages_history_long;
10 SET DEBUG_SYNC='RESET';
11 SET DEBUG_SYNC='copy_data_between_tables_before SIGNAL found_row WAIT_FOR wait_row EXECUTE 5';
12 ALTER TABLE t1 engine = innodb;;
13 SET DEBUG_SYNC='now WAIT_FOR found_row';
14 select event_id from performance_schema.events_statements_current
15 where thread_id = @con1_thread_id into @con1_stmt_id;
16 select EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED
17 from performance_schema.events_stages_current
18 where (thread_id = @con1_thread_id);
19 EVENT_NAME WORK_COMPLETED WORK_ESTIMATED
20 stage/sql/copy to tmp table 0 5
21 SET DEBUG_SYNC='now SIGNAL wait_row';
22 SET DEBUG_SYNC='now WAIT_FOR found_row';
23 select EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED
24 from performance_schema.events_stages_current
25 where (thread_id = @con1_thread_id);
26 EVENT_NAME WORK_COMPLETED WORK_ESTIMATED
27 stage/sql/copy to tmp table 1 5
28 SET DEBUG_SYNC='now SIGNAL wait_row';
29 SET DEBUG_SYNC='now WAIT_FOR found_row';
30 select EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED
31 from performance_schema.events_stages_current
32 where (thread_id = @con1_thread_id);
33 EVENT_NAME WORK_COMPLETED WORK_ESTIMATED
34 stage/sql/copy to tmp table 2 5
35 SET DEBUG_SYNC='now SIGNAL wait_row';
36 SET DEBUG_SYNC='now WAIT_FOR found_row';
37 select EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED
38 from performance_schema.events_stages_current
39 where (thread_id = @con1_thread_id);
40 EVENT_NAME WORK_COMPLETED WORK_ESTIMATED
41 stage/sql/copy to tmp table 3 5
42 SET DEBUG_SYNC='now SIGNAL wait_row';
43 SET DEBUG_SYNC='now WAIT_FOR found_row';
44 select EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED
45 from performance_schema.events_stages_current
46 where (thread_id = @con1_thread_id);
47 EVENT_NAME WORK_COMPLETED WORK_ESTIMATED
48 stage/sql/copy to tmp table 4 5
49 SET DEBUG_SYNC='now SIGNAL wait_row';
50 select "After payload";
51 After payload
52 After payload
53 Dumping ALTER TABLE stages
54 select EVENT_NAME, WORK_COMPLETED, WORK_ESTIMATED
55 from performance_schema.events_stages_history_long
56 where (thread_id = @con1_thread_id)
57 and (nesting_event_id = @con1_stmt_id)
58 order by thread_id, event_id;
59 EVENT_NAME WORK_COMPLETED WORK_ESTIMATED
60 stage/sql/starting NULL NULL
61 stage/sql/Executing hook on transaction begin. NULL NULL
62 stage/sql/starting NULL NULL
63 stage/sql/checking permissions NULL NULL
64 stage/sql/checking permissions NULL NULL
65 stage/sql/init NULL NULL
66 stage/sql/Opening tables NULL NULL
67 stage/sql/setup NULL NULL
68 stage/sql/creating table NULL NULL
69 stage/sql/After create NULL NULL
70 stage/sql/System lock NULL NULL
71 stage/sql/copy to tmp table 5 5
72 stage/sql/rename result table NULL NULL
73 stage/sql/waiting for handler commit NULL NULL
74 stage/sql/waiting for handler commit NULL NULL
75 stage/sql/waiting for handler commit NULL NULL
76 stage/sql/waiting for handler commit NULL NULL
77 stage/sql/waiting for handler commit NULL NULL
78 stage/sql/waiting for handler commit NULL NULL
79 stage/sql/waiting for handler commit NULL NULL
80 stage/sql/waiting for handler commit NULL NULL
81 stage/sql/end NULL NULL
82 stage/sql/query end NULL NULL
83 stage/sql/closing tables NULL NULL
84 stage/sql/waiting for handler commit NULL NULL
85 stage/sql/freeing items NULL NULL
86 stage/sql/cleaning up NULL NULL
87 SET DEBUG_SYNC='RESET';
88 drop table t1;
89 update performance_schema.threads
90 set instrumented = 'YES'
91 where processlist_id = connection_id();