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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/linux-installation-juju.html
The Juju deployment framework supports easy installation and configuration of MySQL servers.
https://dev.mysql.com/doc/refman/8.0/en/platform-support.html
MySQL platform support evolves over time; please refer to https://www.mysql.com/support/supportedplatforms/database.html for the latest updates.
https://dev.mysql.com/doc/refman/8.0/en/channels-with-prev-replication.html
Warning Use RESET REPLICA with caution as this statement deletes all existing channels, purges their relay log files, and recreates only the default channel. In this case, error 1964 Multiple channels exist on the replica. For example, the following ... When a replica has multiple channels and a FOR CHANNEL channel option is not specified, a valid statement generally acts on all available channels, with some specific ...
https://dev.mysql.com/doc/refman/8.0/en/user-resources.html
Only statements that modify databases or tables count against the update limit. Use of this option on the command line or in an option file in MySQL 8.0.30 or later causes the server to raise a warning. One means of restricting client use of MySQL ...In addition, setting max_user_connections does not enable management of individual ...
https://dev.mysql.com/doc/refman/8.0/en/show-engines.html
For information about MySQL storage engines, see Chapter 17, The InnoDB Storage Engine, and Chapter 18, Alternative Storage Engines. In the latter case, the error log should contain a reason indicating why the option is disabled. SHOW [STORAGE] ...
https://dev.mysql.com/doc/refman/8.0/en/declare-cursor.html
The number of columns retrieved by the SELECT statement must match the number of output variables specified in the FETCH statement. DECLARE cursor_name CURSOR FOR select_statement This statement declares a cursor and associates it with a SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-upgrading-member.html
Once the MySQL upgrade procedure has been performed on the member, group_replication_start_on_boot must be set to 1 to ensure Group Replication starts correctly after restart. The Group Replication metadata is in place on the upgraded server, ...