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/atomic-ddl.html
Account management statements either succeed for all named users or roll back and have no effect if an error occurs. Viewing DDL Logs To view DDL logs that are written to the mysql.innodb_ddl_log data dictionary table during atomic DDL operations ...
https://dev.mysql.com/doc/refman/8.0/en/audit-api-message-emit.html
Messages posted by audit_api_message_emit_udf() have an event class of MYSQL_AUDIT_MESSAGE_CLASS and a subclass of MYSQL_AUDIT_MESSAGE_USER. (Internally generated audit messages have the same class and a subclass of MYSQL_AUDIT_MESSAGE_INTERNAL; ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-installation.html
$> mysql -u root -p -D database-name < audit_log_filter_linux_install.sql Enter password: (enter root password here) Note Some MySQL versions have introduced changes to the structure of the MySQL Enterprise Audit tables. As of MySQL 8.0.12, for new ... This section describes how to install or uninstall MySQL Enterprise Audit, which is implemented using the audit log plugin and related elements described in Section 8.4.5.1, “Elements of MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-reference.html
The tables can be accessed only by users who have privileges for that database. To have the name suffix correspond to the format, set the name explicitly, choosing a different suffix (for example, audit.xml for XML format, audit.json for JSON ...
https://dev.mysql.com/doc/refman/8.0/en/backup-strategy-example.html
The InnoDB data files might not contain consistent data due to the crash, but InnoDB reads its logs and finds in them the list of pending committed and noncommitted transactions that have not been flushed to the data files. Then it is necessary to ...You should include such options as necessary to enable client programs to connect to the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/binary-varbinary.html
This means they have the binary character set and collation, and comparison and sorting are based on the numeric values of the bytes in the values. This differs from BINARY(5), which stores 5-byte binary strings that have the binary character set ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
Any operations performed on a table using BLACKHOLE have no effect. There are at least two cases where it is not desirable to copy the columns to the replica: If the data is confidential, so the replica server should not have access to it. The ...
https://dev.mysql.com/doc/refman/8.0/en/bnl-bka-optimization.html
After all rows of the table to be joined have been examined, the join buffer is scanned. Each row from the buffer that does not have its match flag enabled is extended by NULL complements (NULL values for each column in the second operand) and sent ... In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join ...
https://dev.mysql.com/doc/refman/8.0/en/char.html
MySQL collations have a pad attribute of PAD SPACE, other than Unicode collations based on UCA 9.0.0 and higher, which have a pad attribute of NO PAD. The CHAR and VARCHAR types are similar, but differ in the way they are stored and retrieved. They ...
https://dev.mysql.com/doc/refman/8.0/en/charset-applications.html
However, this may yield inconsistent results because the init_connect value is not executed for users who have the CONNECTION_ADMIN privilege (or the deprecated SUPER privilege). For applications that store data using the default MySQL character ...