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/version-tokens-usage.html
Suppose that a management application communicates with a set of servers that are queried by clients to access employee and product databases (named emp and prod, respectively). Before using Version Tokens, install it according to the instructions ...
https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html
The MySQL server authenticates connection attempts for each account listed in the mysql.user system table using the authentication plugin named in the plugin column. If the plugin column is empty, the server authenticates the account as follows: ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-partition-operations.html
Partitioning-related clauses for ALTER TABLE can be used with partitioned tables for repartitioning, to add, drop, discard, import, merge, and split partitions, and to perform partitioning maintenance. Simply using a partition_options clause with ...
https://dev.mysql.com/doc/refman/5.7/en/alter-tablespace.html
ALTER TABLESPACE tablespace_name {ADD | DROP} DATAFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement is used either to add a new data file, or to drop a data file from a tablespace. The ADD DATAFILE variant ...
https://dev.mysql.com/doc/refman/5.7/en/analyze-table.html
In the few cases that ANALYZE TABLE does not produce values good enough for your particular tables, you can use FORCE INDEX with your queries to force the use of a particular index, or set the max_seeks_for_key system variable to ensure that MySQL ...ANALYZE TABLE performs a key distribution analysis and stores the distribution for the named table or ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-filtering.html
Note As of MySQL 5.7.13, for audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and functions must be installed. If the plugin is installed without the accompanying audit tables and functions ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-legacy-filtering.html
It takes a value of ALL (log all events; this is the default), LOGINS (log connection events), QUERIES (log statement events), or NONE (do not log events). Startup audit_log_policy Value Resulting audit_log_connection_policy Value Resulting ... Note ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
audit_log_policy Command-Line Format --audit-log-policy=value System Variable audit_log_policy Scope Global Dynamic No Type Enumeration Default Value ALL Valid Values ALLLOGINSQUERIESNONE Note This variable applies only to legacy mode audit log ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log.html
Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes MySQL Enterprise Audit, implemented using a server plugin named audit_log. MySQL Enterprise Audit uses the ...
https://dev.mysql.com/doc/refman/5.7/en/binary-varbinary.html
The BINARY and VARBINARY types are similar to CHAR and VARCHAR, except that they store binary strings rather than nonbinary strings. This means they have the binary character set and collation, and comparison and sorting are based on the numeric ...