PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/kerberos-pluggable-authentication.html
Note Neither MySQL Shell nor MySQL Router currently support creating internally managed MySQL accounts for use with Kerberos. Kerberos pluggable authentication provides these capabilities: External authentication: Kerberos authentication enables ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log.html
The binary log contains “events” that describe database changes such as table creation operations or changes to table data. This is done to ensure that you can re-create an exact copy of your tables by applying the log during a backup operation. The number increases each time the server creates a new log file, thus creating an ordered series of ...It also contains events for statements that ...
https://dev.mysql.com/doc/refman/8.0/en/charset-column.html
CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci ) CHARACTER SET latin1 COLLATE latin1_bin; The character set and collation are specified for the column, so they are used. CREATE TABLE t1 ( col1 CHAR(10) CHARACTER SET ...To see the default collation for each character set, use the SHOW CHARACTER SET statement or query the INFORMATION_SCHEMA CHARACTER_SETS ... Every ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldump-delimited-text.html
The .sql file contains a CREATE TABLE statement for the table. The server sends the CREATE definitions for dumped tables to mysqldump, which writes them to .sql files. This section describes how to use mysqldump to create delimited-text dump files.
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-transactions.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. For similar discussion ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-understanding-innodb-locking.html
Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL 8.0. For similar discussion ...At ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-logs.html
Rollback segments reside in undo tablespaces and in the global temporary tablespace. Undo logs that reside in the global temporary tablespace are used for transactions that modify data in user-defined temporary tables. Each undo tablespace and the ... An undo log is a collection of undo log records associated with a single read-write ...
https://dev.mysql.com/doc/refman/8.0/en/order-by-optimization.html
Whether the optimizer actually does so depends on whether reading the index is more efficient than a table scan if columns not in the index must also be read. In that case, scanning an entire index and looking up table rows to find columns not in ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-restrictions.html
If you save event information in another table, you should not assume that the original events remain available later. For example, if you select events from a performance_schema table into a temporary table, intending to join that table with the ...
https://dev.mysql.com/doc/refman/8.0/en/privilege-changes.html
If the mysqld server is started without the --skip-grant-tables option, it reads all grant table contents into memory during its startup sequence. The in-memory tables become effective for access control at that point. If you modify the grant ...