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/encrypted-connection-protocols-ciphers.html
The negotiation process depends on factors such as the SSL library used to compile the server and client, the TLS protocol and encryption cipher configuration, and which key size is used: For a connection attempt to succeed, the server and client ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-session-temp-tablespaces-table.html
The INNODB_SESSION_TEMP_TABLESPACES table provides metadata about session temporary tablespaces used for internal and user-created temporary tables. The INNODB_SESSION_TEMP_TABLESPACES table has these columns: ID The process or session ID. A range ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-optimize-tablespace-page-allocation.html
When pages are allocated using posix_fallocate() calls, the extension size is small by default and pages are often allocated only a few at a time, which can cause fragmentation and increase random I/O. To avoid this issue, increase the tablespace ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-logs.html
The number of undo slots in a rollback segment differs according to InnoDB page size. An undo log is a collection of undo log records associated with a single read-write transaction. An undo log record contains information about how to undo the ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-service.html
Syntax: bool my_key_fetch(const char *key_id, const char **key_type, const char* user_id, void **key, size_t *key_len) Arguments: key_id, user_id: Null-terminated strings that as a pair form a unique identifier indicating which key to fetch. MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-hexdump.html
For more information about binary log format, see MySQL Internals: The Binary Log. In the example shown, '9d fc 5c 43' is the representation of '051024 17:24:13' in hexadecimal. Master ID: The server ID of the replication source server that created ...
https://dev.mysql.com/doc/refman/8.0/en/preventing-use-of-optimizer-trace.html
If, for some reason, you wish to prevent users from seeing traces of their queries, start the server with the options shown here: --maximum-optimizer-trace-max-mem-size=0 --optimizer-trace-max-mem-size=0 This sets the maximum size to 0 and prevents ...
https://dev.mysql.com/doc/refman/8.0/en/program-variables.html
For example, mysql has a max_allowed_packet variable that controls the maximum size of its communication buffer. Both set the size of the server's key buffer to 512MB: [mysqld] key_buffer_size=512M [mysqld] key-buffer-size=512M Suffixes for ... Many ...
https://dev.mysql.com/doc/refman/8.0/en/hash-joins.html
Beginning with MySQL 8.0.18, join buffers for hash joins are allocated incrementally; thus, you can set join_buffer_size higher without small queries allocating very large amounts of RAM, but outer joins allocate the entire buffer. row ... By ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
For complex statements, the JSON output can be quite large; in particular, it can be difficult when reading it to pair the closing bracket and opening brackets; to cause the JSON structure's key, if it has one, to be repeated near the closing ...