PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
Otherwise, newer log files will have a different format than older files, but they will all have the same base name with nothing to indicate when the format changed. Elements within <AUDIT_RECORD> elements have these characteristics: Some elements ... The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
This is not supported for UNIQUE NOT NULL indexes that have functional key parts. Indexes that contain functional key parts do not have this feature. A multi-valued index can have multiple index records for a single data record (N:1). In other ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
To use CREATE USER, you must have the global CREATE USER privilege, or the INSERT privilege for the mysql system schema. These constraints do not apply if you have the AUTHENTICATION_POLICY_ADMIN privilege. To create an account that uses ... CREATE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
Source and target tables for replication do not have to be identical. A table on the source can have more or fewer columns than the replica's copy of the table. In all cases where the source and target tables do not have identical definitions, the ...In addition, corresponding table columns on the source and the replica can use different data types, subject to certain ...
https://dev.mysql.com/doc/refman/8.0/en/stored-objects-security.html
The following rules determine which accounts you can specify as the DEFINER attribute for a stored object: If you have the SET_USER_ID privilege (or the deprecated SUPER privilege), you can specify any account as the DEFINER attribute. Additionally, ... Stored programs (procedures, functions, triggers, and events) and views are defined prior to use and, when referenced, execute within a security context that determines their ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-status-variables.html
Mysqlx_errors_unknown_message_type The number of unknown message types that have been received. Mysqlx_sessions_fatal_error The number of sessions that have closed with a fatal error. Mysqlx_aborted_clients The number of clients that were ...
https://dev.mysql.com/doc/refman/8.0/en/flush.html
Resetting resource indicators enables clients that have reached their hourly connection, query, or update limits to resume activity immediately. This operation is a very convenient way to get backups if you have a file system such as Veritas or ZFS ...| tables_option } flush_option: { BINARY LOGS | ENGINE LOGS | ERROR LOGS | GENERAL LOGS | HOSTS | LOGS | PRIVILEGES | OPTIMIZER_COSTS | RELAY LOGS [FOR CHANNEL channel] | SLOW LOGS | STATUS | USER_RESOURCES } tables_option: { table_synonym | table_synonym tbl_name [, tbl_name] ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
LOCAL works only if the server and your client both have been configured to permit it. Security Requirements For a non-LOCAL load operation, the server reads a text file located on the server host, so these security requirements must be satisfied: ...The file can be read from the server host or the client host, depending on whether the LOCAL modifier is ...
https://dev.mysql.com/doc/refman/8.0/en/partial-revokes.html
Specifically, for users who have privileges at the global level, partial_revokes enables privileges for specific schemas to be revoked while leaving the privileges in place for other schemas. Privilege restrictions thus imposed may be useful for ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-event-tables.html
The tables have names of the following forms, where xxx indicates the event type (waits, stages, statements, transactions): events_xxx_current: The “current events” table stores the current monitored event for each thread (one row per thread).