Debian Codegraph @

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

raw
1 # Restart server with keyring_file plugin
2 # restart:--early-plugin-load=keyring_file.so --loose-keyring_file_data=MYSQL_TMP_DIR/keyring/perf_schema
3 CREATE DATABASE WL_11543_PERF_SCHEMA_KEYRING;
4 USE WL_11543_PERF_SCHEMA_KEYRING;
5 SELECT count(*) FROM performance_schema.keyring_keys;
6 count(*)
7 0
8 CREATE TABLE t1(c1 INT, c2 char(20)) ENGINE = InnoDB ENCRYPTION="Y";
9 SELECT count(*) FROM performance_schema.keyring_keys;
10 count(*)
11 1
12 ALTER INSTANCE ROTATE INNODB MASTER KEY;
13 SELECT count(*) FROM performance_schema.keyring_keys;
14 count(*)
15 2
16 SELECT * FROM performance_schema.keyring_keys;
17 KEY_ID KEY_OWNER BACKEND_KEY_ID
18 SOME_KEY_ID
19 SOME_KEY_ID
20 # cleanup
21 DROP TABLE t1;
22 UNINSTALL PLUGIN keyring_file;
23 DROP DATABASE WL_11543_PERF_SCHEMA_KEYRING;
24 # restart: