PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/distinct-optimization.html
DISTINCT combined with ORDER BY needs a temporary table in many cases. If you do not use columns from all tables named in a query, MySQL stops scanning any unused tables as soon as it finds the first match. Because DISTINCT may use GROUP BY, learn ...
https://dev.mysql.com/doc/refman/8.0/en/drop-trigger.html
DROP TRIGGER requires the TRIGGER privilege for the table associated with the trigger. Triggers for a table are also dropped if you drop the table. DROP TRIGGER [IF EXISTS] [schema_name.]trigger_name This statement drops a trigger. If the schema is ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
In this case, you cannot establish MySQL connections that use TLSv1 or TLSv1.1, even though MySQL is configured to permit them, because the host system does not permit them. If MySQL configuration permits TLSv1, TLSv1.1, and TLSv1.2, but your host ... MySQL supports multiple TLS protocols and ciphers, and enables configuring which protocols and ciphers to permit for encrypted ...
https://dev.mysql.com/doc/refman/8.0/en/error-log.html
For example, if mysqld notices that a table needs to be automatically checked or repaired, it writes a message to the error log. Depending on error log configuration, error messages may also populate the Performance Schema error_log table, to ...
https://dev.mysql.com/doc/refman/8.0/en/execution-plan-information.html
Depending on the details of your tables, columns, indexes, and the conditions in your WHERE clause, the MySQL optimizer considers many techniques to efficiently perform the lookups involved in an SQL query. A query on a huge table can be performed ...The set of operations that the optimizer chooses to perform the most efficient query is called the “query execution plan”, also known as the EXPLAIN ...
https://dev.mysql.com/doc/refman/8.0/en/federated-storage-engine.html
Querying a local FEDERATED table automatically pulls the data from the remote (federated) tables. The FEDERATED storage engine lets you access data from a remote MySQL database without using replication or cluster technology. To include the ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-member-actions.html
The Performance Schema table replication_group_member_actions lists the member actions that are available in the configuration, the events that trigger them, and whether or not they are currently enabled. The ... From MySQL 8.0.26, Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-rejoin.html
While an auto-rejoin procedure is taking place, the Performance Schema table events_stages_current shows the event “Undergoing auto-rejoin procedure”, with the number of retries that have been attempted so far during this instance of the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/index-preloading.html
Preloading enables you to put the table index blocks into a key cache buffer in the most efficient way: by reading the index blocks from disk sequentially. If there are enough blocks in a key cache to hold blocks of an entire index, or at least the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached.html
The InnoDB memcached plugin (daemon_memcached) provides an integrated memcached daemon that automatically stores and retrieves data from InnoDB tables, turning the MySQL server into a fast “key-value store”. You can also access the same InnoDB ... Important The InnoDB memcached plugin was removed in MySQL 8.3.0, and was deprecated in MySQL ...