PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/tuning-trace-purging.html
Thus, if a statement contains substatements (such as invoking stored procedures, stored functions, or triggers), the topmost statement and substatements each generate one trace, but at the end of execution, the trace for only the last substatement ...A user who wants to see the trace of a different substatement can enable or disable tracing for the desired substatement, but this requires editing the routine code, which may not always be ...
https://dev.mysql.com/doc/refman/8.0/en/using-explain.html
The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with SELECT, DELETE, INSERT, REPLACE, and UPDATE statements. That is, MySQL explains how it would process the statement, including information about how ...When EXPLAIN is used with an explainable statement, MySQL displays information from the optimizer about the statement execution ...
https://dev.mysql.com/doc/refman/8.0/en/charset-syntax.html
There are default settings for character sets and collations at four levels: server, database, table, and column. The description in the following sections may appear complex, but it has been found in practice that multiple-level defaulting leads ...CHARACTER SET is used in clauses that specify a character ...
https://dev.mysql.com/doc/refman/8.0/en/database-use.html
Suppose that you have several pets in your home (your menagerie) and you would like to keep track of various types of information about them. You can do so by creating tables to hold your data and loading them with the desired information. A ...
https://dev.mysql.com/doc/refman/8.0/en/function-loading.html
MySQL supports automatic function loading during server startup and manual loading thereafter. Common suffixes are .so for Unix and Unix-like systems, .dll for Windows. It adds the function to the Performance Schema user_defined_functions table that ... Loadable functions, as the name implies, must be loaded into the server before they can be ...
https://dev.mysql.com/doc/refman/8.0/en/gis-linestring-property-functions.html
Unless otherwise specified, functions in this section handle their geometry arguments as follows: If any argument is NULL or any geometry argument is an empty geometry, the return value is NULL. ST_EndPoint() handles its arguments as described in ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-functions-for-communication-protocol.html
The following functions enable you to inspect and configure the Group Replication communication protocol version that is used by a replication group. Versions from MySQL 8.0.27 also allow the group communication engine to operate with a single ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression.html
This section provides information about the InnoDB table compression and InnoDB page compression features. The compression means less data is transferred between disk and memory, and takes up less space on disk and in memory. The page compression ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-shutdown-restart.html
To shut down the cluster, enter the following command in a shell on the machine hosting the management node: $> ndb_mgm -e shutdown The -e option here is used to pass a command to the ndb_mgm client from the shell. The command causes the ndb_mgm, ...On Windows platforms, assuming that you have installed the SQL node as a Windows service, you can use SC STOP service_name or NET STOP ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndb-innodb-workloads.html
NDB Cluster has a range of unique attributes that make it ideal to serve applications requiring high availability, fast failover, high throughput, and low latency. Due to its distributed architecture and multi-node implementation, NDB Cluster also ...