Debian Codegraph @

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

raw
1 select * from performance_schema.setup_threads;
2 select * from performance_schema.setup_threads
3 order by name limit 12;
4 NAME ENABLED HISTORY PROPERTIES VOLATILITY DOCUMENTATION
5 thread/innodb/buf_dump_thread YES YES singleton 0 NULL
6 thread/innodb/buf_pool_create_thread YES YES singleton 0 NULL
7 thread/innodb/buf_resize_thread YES YES singleton 0 NULL
8 thread/innodb/clone_ddl_thread YES YES singleton 0 NULL
9 thread/innodb/clone_gtid_thread YES YES singleton 0 NULL
10 thread/innodb/ddl_thread YES YES 0 NULL
11 thread/innodb/dict_stats_thread YES YES singleton 0 NULL
12 thread/innodb/fts_optimize_thread YES YES singleton 0 NULL
13 thread/innodb/fts_parallel_merge_thread YES YES 0 NULL
14 thread/innodb/fts_parallel_tokenization_thread YES YES 0 NULL
15 thread/innodb/io_ibuf_thread YES YES singleton 0 NULL
16 thread/innodb/io_read_thread YES YES 0 NULL
17 select * from performance_schema.setup_threads
18 where enabled='YES';
19 insert into performance_schema.setup_threads
20 set name='FOO', enabled='YES', history='YES';
21 ERROR 42000: INSERT command denied to user 'root'@'localhost' for table 'setup_threads'
22 update performance_schema.setup_threads
23 set name='FOO';
24 ERROR HY000: Invalid performance_schema usage.
25 update performance_schema.setup_threads
26 set properties='user';
27 ERROR HY000: Invalid performance_schema usage.
28 update performance_schema.setup_threads
29 set volatility=666;
30 ERROR HY000: Invalid performance_schema usage.
31 update performance_schema.setup_threads
32 set documentation='Bar';
33 ERROR HY000: Invalid performance_schema usage.
34 update performance_schema.setup_threads
35 set enabled='NO';
36 update performance_schema.setup_threads
37 set history='NO';
38 update performance_schema.setup_threads
39 set enabled='YES', history='YES';
40 delete from performance_schema.setup_threads;
41 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_threads'
42 delete from performance_schema.setup_threads
43 where name like 'thread/%';
44 ERROR 42000: DELETE command denied to user 'root'@'localhost' for table 'setup_threads'
45 LOCK TABLES performance_schema.setup_threads READ;
46 UNLOCK TABLES;
47 LOCK TABLES performance_schema.setup_threads WRITE;
48 UNLOCK TABLES;
49 UPDATE performance_schema.setup_threads SET history='NO'
50 ORDER BY RAND();
51 update performance_schema.setup_threads
52 set enabled='YES', history='YES';