| 1 |
insert into performance_schema.setup_actors values ("host1","user1","%",'YES','YES'); |
| 2 |
insert into performance_schema.setup_actors values ("host2","user1","%",'YES','YES'); |
| 3 |
insert into performance_schema.setup_actors values ("host3","user1","%",'YES','YES'); |
| 4 |
############ Explain for Query #################################### |
| 5 |
explain select HOST, USER, `ROLE` |
| 6 |
from performance_schema.setup_actors |
| 7 |
where HOST = 'host1'; |
| 8 |
id select_type table partitions type possible_keys key key_len ref rows filtered Extra |
| 9 |
1 SIMPLE setup_actors NULL ref PRIMARY PRIMARY 255 const # 100.00 NULL |
| 10 |
Warnings: |
| 11 |
Note 1003 /* select#1 */ select `performance_schema`.`setup_actors`.`HOST` AS `HOST`,`performance_schema`.`setup_actors`.`USER` AS `USER`,`performance_schema`.`setup_actors`.`ROLE` AS `ROLE` from `performance_schema`.`setup_actors` where (`performance_schema`.`setup_actors`.`HOST` = 'host1') |
| 12 |
############ Explain for Query #################################### |
| 13 |
explain select * |
| 14 |
from performance_schema.setup_actors |
| 15 |
where HOST = 'host1' and USER = 'user1'; |
| 16 |
id select_type table partitions type possible_keys key key_len ref rows filtered Extra |
| 17 |
1 SIMPLE setup_actors NULL ref PRIMARY PRIMARY 383 const,const # 100.00 NULL |
| 18 |
Warnings: |
| 19 |
Note 1003 /* select#1 */ select `performance_schema`.`setup_actors`.`HOST` AS `HOST`,`performance_schema`.`setup_actors`.`USER` AS `USER`,`performance_schema`.`setup_actors`.`ROLE` AS `ROLE`,`performance_schema`.`setup_actors`.`ENABLED` AS `ENABLED`,`performance_schema`.`setup_actors`.`HISTORY` AS `HISTORY` from `performance_schema`.`setup_actors` where ((`performance_schema`.`setup_actors`.`USER` = 'user1') and (`performance_schema`.`setup_actors`.`HOST` = 'host1')) |
| 20 |
############ Explain for Query #################################### |
| 21 |
explain select * |
| 22 |
from performance_schema.setup_actors |
| 23 |
where HOST = 'host1' and USER = 'user1' |
| 24 |
and `ROLE` = 'norole'; |
| 25 |
id select_type table partitions type possible_keys key key_len ref rows filtered Extra |
| 26 |
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table |
| 27 |
Warnings: |
| 28 |
Note 1003 /* select#1 */ select NULL AS `HOST`,NULL AS `USER`,NULL AS `ROLE`,NULL AS `ENABLED`,NULL AS `HISTORY` from `performance_schema`.`setup_actors` where (multiple equal('host1', NULL) and multiple equal('user1', NULL) and multiple equal('norole', NULL)) |
| 29 |
############ Explain for Query #################################### |
| 30 |
explain select HOST, USER, `ROLE` |
| 31 |
from performance_schema.setup_actors |
| 32 |
where HOST = 'nohost' and USER = 'user1' |
| 33 |
and `ROLE` = '%'; |
| 34 |
id select_type table partitions type possible_keys key key_len ref rows filtered Extra |
| 35 |
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table |
| 36 |
Warnings: |
| 37 |
Note 1003 /* select#1 */ select NULL AS `HOST`,NULL AS `USER`,NULL AS `ROLE` from `performance_schema`.`setup_actors` where (multiple equal('nohost', NULL) and multiple equal('user1', NULL) and multiple equal('%', NULL)) |
| 38 |
############ Explain for Query #################################### |
| 39 |
explain select HOST, USER, `ROLE` |
| 40 |
from performance_schema.setup_actors |
| 41 |
where HOST = 'host1' and USER = 'nouser' |
| 42 |
and `ROLE` = '%'; |
| 43 |
id select_type table partitions type possible_keys key key_len ref rows filtered Extra |
| 44 |
1 SIMPLE NULL NULL NULL NULL NULL NULL NULL # NULL no matching row in const table |
| 45 |
Warnings: |
| 46 |
Note 1003 /* select#1 */ select NULL AS `HOST`,NULL AS `USER`,NULL AS `ROLE` from `performance_schema`.`setup_actors` where (multiple equal('host1', NULL) and multiple equal('nouser', NULL) and multiple equal('%', NULL)) |
| 47 |
############ Explain for Query #################################### |
| 48 |
explain select HOST, USER, `ROLE` |
| 49 |
from performance_schema.setup_actors |
| 50 |
where HOST = 'host1' and USER = 'user1' |
| 51 |
and `ROLE` = '%'; |
| 52 |
id select_type table partitions type possible_keys key key_len ref rows filtered Extra |
| 53 |
1 SIMPLE setup_actors NULL const PRIMARY PRIMARY 511 const,const,const # 100.00 NULL |
| 54 |
Warnings: |
| 55 |
Note 1003 /* select#1 */ select 'host1' AS `HOST`,'user1' AS `USER`,'%' AS `ROLE` from `performance_schema`.`setup_actors` where true |
| 56 |
############# Explain End ######################################### |
| 57 |
flush status; |
| 58 |
select ENABLED, HISTORY |
| 59 |
from performance_schema.setup_actors |
| 60 |
where HOST = 'TBALE' and USER = 'user1' |
| 61 |
and `ROLE` = '%'; |
| 62 |
ENABLED HISTORY |
| 63 |
show session status like "handler_read%"; |
| 64 |
Variable_name Value |
| 65 |
Handler_read_first 0 |
| 66 |
Handler_read_key 1 |
| 67 |
Handler_read_last 0 |
| 68 |
Handler_read_next 0 |
| 69 |
Handler_read_prev 0 |
| 70 |
Handler_read_rnd 0 |
| 71 |
Handler_read_rnd_next 0 |
| 72 |
select ENABLED, HISTORY |
| 73 |
from performance_schema.setup_actors |
| 74 |
where HOST = 'host1' and USER = 'user1' |
| 75 |
and `ROLE` = '%'; |
| 76 |
ENABLED HISTORY |
| 77 |
YES YES |
| 78 |
show session status like "handler_read%"; |
| 79 |
Variable_name Value |
| 80 |
Handler_read_first 0 |
| 81 |
Handler_read_key 2 |
| 82 |
Handler_read_last 0 |
| 83 |
Handler_read_next 0 |
| 84 |
Handler_read_prev 0 |
| 85 |
Handler_read_rnd 0 |
| 86 |
Handler_read_rnd_next 0 |
| 87 |
delete from performance_schema.setup_actors where user = 'user1'; |