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/signal.html
SIGNAL provides error information to a handler, to an outer portion of the application, or to the client. Also, it provides control over the error's characteristics (error number, SQLSTATE value, message). Without SIGNAL, it is necessary to resort ...
https://dev.mysql.com/doc/refman/8.0/en/stop-group-replication.html
Prior to MySQL 8.0.27, the default component timeout is 31536000 seconds, or 365 days. Beginning with MySQL 8.0.27, the default value is 300 seconds; this means that Group Replication components are stopped after 5 minutes if the situation is not ...
https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html
However, this is not the case: The second query returns 0. Table 14.13 String Comparison Functions and Operators Name Description LIKE Simple pattern matching NOT LIKE Negation of simple pattern matching STRCMP() Compare two strings If a string ...
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html
Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or disabled. This variable has global and session values and can be changed at runtime. To see the current set of ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-save.html
ps_setup_save() takes a timeout parameter to indicate how many seconds to wait if the lock already exists (which indicates that some other session has a saved configuration outstanding). Parameters in_timeout INT: How many seconds to wait to obtain ...This enables you to alter the configuration temporarily for debugging or other purposes, then restore it to the previous state by invoking the ps_setup_reload_saved() ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-statement-digest.html
in_interval DECIMAL(2,2): The analysis interval in seconds (which can be fractional) at which to try to take snapshots. Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the ...
https://dev.mysql.com/doc/refman/8.0/en/system-schema.html
Time Zone System Tables These system tables contain time zone information: time_zone: Time zone IDs and whether they use leap seconds. It contains tables that store information required by the MySQL server as it runs. A broad categorization is that ...
https://dev.mysql.com/doc/refman/8.0/en/tracing-example.html
Now we can examine the trace, whose first column (QUERY), containing the original statement to be traced, is shown here: SELECT * FROM INFORMATION_SCHEMA.OPTIMIZER_TRACE\G *************************** 1. row *************************** QUERY: SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html
The default value of group_replication_member_expel_timeout changed from 0 to 5, meaning that a member suspected of having lost contact with the group is liable for expulsion 5 seconds after the 5-second detection period. Before upgrading to MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...