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/document-store-concepts.html
The most important differences between a document and the tables known from traditional relational databases are that the structure of a document does not have to be defined in advance, and a collection can contain multiple documents with different ... This section explains the concepts introduced as part of using MySQL as a document ...
https://dev.mysql.com/doc/refman/8.0/en/drop-server.html
Dropping a server for a table does not affect any FEDERATED tables that used this connection information when they were created. DROP SERVER [ IF EXISTS ] server_name Drops the server definition for the server named server_name. DROP SERVER is not ...
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/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/expressions.html
The following table shows the expected form of the expr argument for each unit value. This section lists the grammar rules that expressions must follow in MySQL and provides additional information about the types of terms that may appear in ...
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/group-replication-secure-user.html
State transfer from the binary log requires a replication user with the correct permissions so that Group Replication can establish direct member-to-member replication channels. To secure the user credentials, you can require SSL for connections ...