Search Results
https://dev.mysql.com/doc/mysql-router/9.4/en/mysql-router-conf-options.html
Example usage: keyring_path = /opt/myrouter/data/keyring master_key_path = /opt/myrouter/mysqlrouter.key master_key_path Type String Default Value (Windows) %PROGRAMDATA%\MySQL\MySQL Router\mysqlrouter.key Default Value (Other) ... When started, ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-adding-instances.html
At this point, the group has one member in it, server s1, which has some data in it. It is now time to expand the group by adding the other two servers configured previously. 20.2.1.6.1 Adding a Second Instance In order to add a second instance, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-column-privileges-table.html
The COLUMN_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the column level; see Section 15.7.1.6, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-schema-privileges-table.html
The SCHEMA_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the schema level; see Section 15.7.1.6, ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the table level; see Section 15.7.1.6, “GRANT ...TABLE_CATALOG The name of the catalog to which the table ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-user-privileges-table.html
The USER_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the global level; see Section 15.7.1.6, “GRANT ...
https://dev.mysql.com/doc/refman/8.4/en/keyring-functions-general-purpose.html
Grant the EXECUTE privilege for specific stored programs to the individual users who should be able to invoke them. This technique enables keys to be shared among users and provides to DBAs more fine-grained control over who can do what with keys, ... MySQL Server supports a keyring service that enables internal components and plugins to store sensitive information securely for later ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
The Performance Schema exposes metadata lock information through the metadata_locks table: Locks that have been granted (shows which sessions own which current metadata locks). Locks that have been requested but not yet granted (shows which sessions ... MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 10.11.4, “Metadata ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
Data Dictionary Tables Grant System Tables Object Information System Tables Log System Tables Server-Side Help System Tables Time Zone System Tables Replication System Tables Optimizer System Tables Miscellaneous System Tables The remainder of this ...It contains tables that store information required by the MySQL server as it ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/agenthealth-advisor-ref.html
The Agent Health Advisor monitors the monitoring agent's resource usage, communication status, backlog and memory usage. The Agent Health Advisor configuration dialog is divided into the following functional areas: General Communication Backlog ...