PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/grant.html
[REQUIRE {NONE | tls_option [[AND] tls_option] ...}] [WITH {GRANT OPTION | resource_option} ...] GRANT PROXY ON user TO user [, user] ... To grant a privilege with GRANT, you must have the GRANT OPTION privilege, and you must have the privileges ...
https://dev.mysql.com/doc/refman/5.7/en/grant-tables.html
The mysql system database includes several grant tables that contain information about user accounts and the privileges held by them. The discussion here describes the underlying structure of the grant tables and how the server uses their contents ...For information about other tables in the system database, see Section 5.3, “The mysql System ...
https://dev.mysql.com/doc/refman/5.7/en/show-grants.html
SHOW GRANTS [FOR user] This statement displays the privileges that are assigned to a MySQL user account, in the form of GRANT statements that must be executed to duplicate the privilege assignments. SHOW GRANTS requires the SELECT privilege for the ...Note To display nonprivilege information for MySQL accounts, use the SHOW CREATE USER ...
https://dev.mysql.com/doc/refman/5.7/en/enterprise-encryption-usage.html
Limit CPU usage by key-generation operations The create_asymmetric_priv_key() and create_dh_parameters() encryption functions take a key-length parameter, and the amount of CPU resources required by these functions increases as the key length ... To ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-usage-advice-and-limitations-of-distributed-recovery.html
It is based on classic asynchronous replication and as such it may be slow if the server joining the group is not provisioned at all or is provisioned with a very old backup image. This means that if the data to transfer is too big at phase 1, the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndb-innodb-usage.html
When comparing application feature requirements to the capabilities of InnoDB with NDB, some are clearly more compatible with one storage engine than the other. The following table lists supported application features according to the storage ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-tracing-typical-usage.html
To perform optimizer tracing entails the following steps: Enable tracing by executing SET optimizer_trace="enabled=ON". See Section 8.15.3, “Traceable Statements”, for a listing of statements which can be traced. To examine traces for multiple ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-usage.html
MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format logging. The type of binary log used impacts the size and efficiency of logging. Therefore the choice between row-based replication (RBR) or statement-based ...
https://dev.mysql.com/doc/refman/5.7/en/tracing-memory-usage.html
Each stored trace is a string, which is extended (using realloc()) as optimization progresses by appending more data to it. The optimizer_trace_max_mem_size server system variable sets a limit on the total amount of memory used by all traces ...
https://dev.mysql.com/doc/refman/5.7/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 8.8.1, “Optimizing Queries with EXPLAIN”.