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/pattern-matching.html
MySQL provides standard SQL pattern matching as well as a form of pattern matching based on extended regular expressions similar to those used by Unix utilities such as vi, grep, and sed. SQL pattern matching enables you to use _ to match any ...Do ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-variables-info-table.html
If a variable with a VARIABLE_SOURCE value other than DYNAMIC is set at runtime, VARIABLE_SOURCE becomes DYNAMIC and VARIABLE_PATH becomes the empty string. The variables_info table shows, for each system variable, the source from which it was most ...COMPILED is the value used for variables not set any other ...
https://dev.mysql.com/doc/refman/8.0/en/using-log-files.html
You can also try the command EXPLAIN on all SELECT statements that takes a long time to ensure that mysqld is using indexes properly. You can find the queries that take a long time to execute by starting mysqld with the slow query log enabled. If ...
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 ...