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-wkb-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 BLOB containing a Well-Known Binary (WKB) representation and, optionally, a spatial reference system identifier ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-server-states.html
ERROR The member is in an error state and is not functioning correctly as a group member. A member can enter error state either while applying transactions or during the recovery phase. Note that a server in offline mode following the OFFLINE_MODE ... The state of a Group Replication group member shows its current role in the ...
https://dev.mysql.com/doc/refman/8.0/en/x-plugin-status-variables.html
Mysqlx_aborted_clients The number of clients that were disconnected because of an input or output error. Mysqlx_cursor_close The number of cursor-close messages received Mysqlx_cursor_fetch The number of cursor-fetch messages received ...
https://dev.mysql.com/doc/refman/8.0/en/set-password.html
For accounts that use a plugin that performs authentication against a credentials system that is external to MySQL, password management must be handled externally against that system as well. The clause must be given if password changes for the ...
https://dev.mysql.com/doc/refman/8.0/en/commands-out-of-sync.html
If you get Commands out of sync; you can't run this command now in your client code, you are calling client functions in the wrong order. It can also happen if you try to execute two queries that return data without calling mysql_use_result() or ...
https://dev.mysql.com/doc/refman/8.0/en/replication-asynchronous-connection-failover-replica.html
When the feature is active and correctly configured, if the primary that is replicating goes offline or into an error state, the new primary starts replication on the same channel when it is elected. To configure this feature, the replication ... In ...Ensure that SOURCE_RETRY_COUNT and SOURCE_CONNECT_RETRY are set to minimal numbers that just allow a few retry attempts, for example 3 and ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-functions.html
As of MySQL 8.0.16, MySQL includes built-in SQL functions that format or retrieve Performance Schema data, and that may be used as equivalents for the corresponding sys schema stored functions. If the Performance Schema itself is disabled, ...The ...FORMAT_BYTES(count) Given a numeric byte count, converts it to human-readable format and returns a string consisting of a value and a units ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-views.html
Care should therefore be taken to ensure that views do not replicate table data that would normally be filtered for security reasons. Views are filtered by their own name, not by the tables they refer to. This means that a view can be replicated to ...Replication from a table to a same-named view is supported using statement-based logging, but not when using row-based ...
https://dev.mysql.com/doc/refman/8.0/en/string-functions-charset.html
For operations that convert to character data, the character set and collation of the strings that result from the operations are defined by the character_set_connection and collation_connection system variables that determine the default connection ...This section answers the question: What is the character set and collation of such a string? For simple functions that take string input and return a string result as output, the output's character set and collation are the same as those of the principal input ...
https://dev.mysql.com/doc/refman/8.0/en/version-tokens.html
An SQL statement sent by the application to a server not in the required state produces an error. MySQL includes Version Tokens, a feature that enables creation of and synchronization around server tokens that applications can use to prevent ...