| 1 |
CREATE USER test@localhost; |
| 2 |
SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='performance_schema' ORDER BY table_name; |
| 3 |
TABLE_NAME |
| 4 |
global_status |
| 5 |
global_variables |
| 6 |
persisted_variables |
| 7 |
processlist |
| 8 |
session_account_connect_attrs |
| 9 |
session_status |
| 10 |
session_variables |
| 11 |
variables_info |
| 12 |
GRANT SELECT ON performance_schema.cond_instances TO test@localhost; |
| 13 |
GRANT SELECT ON performance_schema.setup_consumers TO test@localhost; |
| 14 |
GRANT SELECT ON performance_schema.accounts TO test@localhost; |
| 15 |
GRANT SELECT ON performance_schema.setup_objects TO test@localhost; |
| 16 |
SELECT table_name FROM information_schema.TABLES WHERE TABLE_SCHEMA='performance_schema' ORDER BY table_name; |
| 17 |
TABLE_NAME |
| 18 |
accounts |
| 19 |
cond_instances |
| 20 |
global_status |
| 21 |
global_variables |
| 22 |
persisted_variables |
| 23 |
processlist |
| 24 |
session_account_connect_attrs |
| 25 |
session_status |
| 26 |
session_variables |
| 27 |
setup_consumers |
| 28 |
setup_objects |
| 29 |
variables_info |
| 30 |
SELECT TABLE_SCHEMA, TABLE_NAME, COLUMN_NAME, ORDINAL_POSITION |
| 31 |
FROM INFORMATION_SCHEMA.COLUMNS |
| 32 |
WHERE TABLE_SCHEMA='performance_schema' |
| 33 |
AND TABLE_NAME IN ('accounts', 'cond_instances', 'setup_consumers', |
| 34 |
'setup_objects', 'processlist', 'global_status') |
| 35 |
ORDER BY TABLE_SCHEMA, TABLE_NAME, ORDINAL_POSITION, COLUMN_NAME; |
| 36 |
TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION |
| 37 |
performance_schema accounts USER 1 |
| 38 |
performance_schema accounts HOST 2 |
| 39 |
performance_schema accounts CURRENT_CONNECTIONS 3 |
| 40 |
performance_schema accounts TOTAL_CONNECTIONS 4 |
| 41 |
performance_schema accounts MAX_SESSION_CONTROLLED_MEMORY 5 |
| 42 |
performance_schema accounts MAX_SESSION_TOTAL_MEMORY 6 |
| 43 |
performance_schema cond_instances NAME 1 |
| 44 |
performance_schema cond_instances OBJECT_INSTANCE_BEGIN 2 |
| 45 |
performance_schema setup_consumers NAME 1 |
| 46 |
performance_schema setup_consumers ENABLED 2 |
| 47 |
performance_schema setup_objects OBJECT_TYPE 1 |
| 48 |
performance_schema setup_objects OBJECT_SCHEMA 2 |
| 49 |
performance_schema setup_objects OBJECT_NAME 3 |
| 50 |
performance_schema setup_objects ENABLED 4 |
| 51 |
performance_schema setup_objects TIMED 5 |
| 52 |
REVOKE ALL PRIVILEGES, GRANT OPTION FROM test@localhost; |
| 53 |
DROP USER test@localhost; |