Search Results
https://dev.mysql.com/doc/refman/8.4/en/verifying-index-usage.html
Always check whether all your queries really use the indexes that you have created in the tables. Use the EXPLAIN statement, as described in Section 10.8.1, “Optimizing Queries with EXPLAIN”.
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-issues-usage.html
The limitations discussed in this section occur by intention or design in MySQL Cluster Manager 8.4.6. Some of these items may become obsolete in future versions; we will update this section accordingly if and as those changes come about.
https://dev.mysql.com/doc/refman/8.4/en/roles.html
For example: mysql> SHOW GRANTS FOR 'dev1'@'localhost'; +-------------------------------------------------+ | Grants for dev1@localhost | +-------------------------------------------------+ | GRANT USAGE ON *.* TO `dev1`@`localhost` | | GRANT ...The ...
https://dev.mysql.com/doc/refman/8.4/en/partial-revokes.html
It is possible to grant privileges that apply globally if the partial_revokes system variable is enabled. Using Partial Revokes Partial Revokes Versus Explicit Schema Grants Disabling Partial Revokes Partial Revokes and Replication Note For ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-role-column-grants-table.html
The ROLE_COLUMN_GRANTS table provides information about the column privileges for roles that are available to or granted by the currently enabled roles. The ROLE_COLUMN_GRANTS table has these columns: GRANTOR The user name part of the account that ...TABLE_CATALOG The name of the catalog to which the role ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-role-routine-grants-table.html
The ROLE_ROUTINE_GRANTS table provides information about the routine privileges for roles that are available to or granted by the currently enabled roles. The ROLE_ROUTINE_GRANTS table has these columns: GRANTOR The user name part of the account ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-role-table-grants-table.html
The ROLE_TABLE_GRANTS table provides information about the table privileges for roles that are available to or granted by the currently enabled roles. The ROLE_TABLE_GRANTS table has these columns: GRANTOR The user name part of the account that ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
USAGE This privilege specifier stands for “no privileges.” It is used at the global level with GRANT to specify clauses such as WITH GRANT OPTION without naming specific account privileges in the privilege list. SHOW GRANTS displays USAGE to ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-usage.html
Assigning Firewall Privileges With the firewall installed, grant the appropriate privileges to the MySQL account or accounts to be used for administering it. The privileges depend on which firewall operations an account should be permitted to ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-top.html
ndb_top displays running information in the terminal about CPU usage by NDB threads on an NDB Cluster data node. Usage ndb_top [-h hostname] [-t port] [-u user] [-p pass] [-n node_id] ndb_top connects to a MySQL Server running as an SQL node of the ...Each thread is represented by two rows in the output, the first showing system statistics, the second showing the measured statistics for the ...