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/savepoint.html
SAVEPOINT identifier ROLLBACK [WORK] TO [SAVEPOINT] identifier RELEASE SAVEPOINT identifier InnoDB supports the SQL statements SAVEPOINT, ROLLBACK TO SAVEPOINT, RELEASE SAVEPOINT and the optional WORK keyword for ROLLBACK. Modifications that the ...
https://dev.mysql.com/doc/refman/8.0/en/uninstall-plugin.html
plugin_name must be the name of some plugin that is listed in the mysql.plugin table. It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. The server executes the ...
https://dev.mysql.com/doc/refman/8.0/en/obtaining-plugin-information.html
The table contains only plugin names and library file names, so it does not provide as much information as the PLUGINS table or the SHOW PLUGINS statement. There are several ways to determine which plugins are installed in the server: The ...Any ...
https://dev.mysql.com/doc/refman/8.0/en/index-merge-optimization.html
AND key_partN = constN Any range condition over the primary key of an InnoDB table. If one of the merged conditions is a condition over the primary key of an InnoDB table, it is not used for row retrieval, but is used to filter out rows retrieved ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-miscellaneous-tables.html
The following sections describe tables that do not fall into the table categories discussed in the preceding sections: component_scheduler_tasks: The current status of each scheduled task. user_defined_functions: Loadable functions registered by a ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-network-partitioning.html
A member with extra transactions cannot rejoin the group, and the attempt results in an error with the message This member has more executed transactions than those present in the group. A member with extra transactions cannot rejoin the group, and ... The group needs to achieve consensus whenever a change that needs to be replicated ...
https://dev.mysql.com/doc/refman/8.0/en/explain.html
You should be aware that while this makes the output easier to read, it also renders the JSON invalid, causing JSON functions to raise an error. If the value of explain_format is JSON, EXPLAIN ANALYZE returns an error unless FORMAT=TREE is specified ...In practice, the DESCRIBE keyword is more often used to obtain information about table structure, whereas EXPLAIN is used to obtain a query execution plan (that is, an explanation of how MySQL would execute a ... {EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | ...
https://dev.mysql.com/doc/refman/8.0/en/gis-wkt-functions.html
If the options argument is invalid, an error occurs to indicate why. For geographic SRS geometry arguments, if any argument has a longitude or latitude that is out of range, an error occurs: If a longitude value is not in the range (−180, 180], an ... These functions take as arguments a Well-Known Text (WKT) representation and, optionally, a spatial reference system identifier ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transaction-inconsistencies.html
If the error is in a mixed transaction, that transaction is half-applied. When using a multithreaded replica, workers which have not received an error complete their queues, so it may take time to stop all threads. This ensures it never leaves gaps ... Inconsistencies in the sequence of transactions that have been executed from the relay log can occur depending on your replication ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-recover.html
Details of the error and the last applied transaction are recorded in the Performance Schema replication_applier_status_by_worker table. Follow this procedure to recover from the error: Identify the replicated event that caused the error and verify ... If a privilege check against the PRIVILEGE_CHECKS_USER account fails, the transaction is not executed and replication stops for the ...