PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/stop-replica.html
You can control how long STOP REPLICA waits before timing out by setting the system variable rpl_stop_replica_timeout (from MySQL 8.0.26) or rpl_stop_slave_timeout (before MySQL 8.0.26). When the timeout value is reached, the issuing client returns ...] thread_type: IO_THREAD | SQL_THREAD channel_option: FOR CHANNEL channel Stops the replication ...
https://dev.mysql.com/doc/refman/8.0/en/storage-engines.html
NDB (also known as NDBCLUSTER): This clustered database engine is particularly suited for applications that require the highest possible degree of uptime and availability. Storage engines are MySQL components that handle the SQL operations for ...
https://dev.mysql.com/doc/refman/8.0/en/string-comparison-functions.html
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 function is given a binary string as an argument, the ...
https://dev.mysql.com/doc/refman/8.0/en/subquery-optimization-with-exists.html
Most optimizations cannot deal with predicates that may be turned on and off at query execution time, so they assume any trigcond(X) to be an unknown function and ignore it. Certain optimizations are applicable to comparisons that use the IN (or ...
https://dev.mysql.com/doc/refman/8.0/en/sys-execute-prepared-stmt.html
Thus, this procedure is useful primarily for executing dynamic statements on a one-time basis. Given an SQL statement as a string, executes it as a prepared statement. The prepared statement is deallocated after execution, so it is not subject to ...
https://dev.mysql.com/doc/refman/8.0/en/sys-latest-file-io.html
These views summarize file I/O activity, grouped by file and thread. The latest_file_io and x$latest_file_io views have these columns: thread For foreground threads, the account associated with the thread (and port number for TCP/IP connections).
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-disabled.html
Displays all currently disabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display disabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display disabled threads. Example ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-enabled.html
Displays all currently enabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. Example mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-stack.html
row *************************** thread_stack: {"rankdir": "LR","nodesep": "0.10", "stack_created": "2014-02-19 13:39:03", "mysql_version": "8.0.2-dmr-debug-log", "mysql_user": "root@localhost","events": [{"nesting_event_id": "0", "event_id": "10", ... Returns a JSON formatted stack of all statements, stages, and events within the Performance Schema for a given thread ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-object-overview.html
Note For MySQL instances with a large number of objects, this view might take a long time to execute. This view summarizes the types of objects within each schema. object_type The object type: BASE TABLE, INDEX (index_type), EVENT, FUNCTION, ...