PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/x-plugin-status-variables.html
If the bind has failed, or if the skip_networking option has been used, the value shows UNDEFINED. Mysqlx_errors_unknown_message_type The number of unknown message types that have been received. Mysqlx_notice_other_sent The number of other types of ...
https://dev.mysql.com/doc/refman/5.7/en/index-extensions.html
Consider this table definition: CREATE TABLE t1 ( i1 INT NOT NULL DEFAULT 0, i2 INT NOT NULL DEFAULT 0, d DATE DEFAULT NULL, PRIMARY KEY (i1, i2), INDEX k_d (d) ) ENGINE = InnoDB; This table defines the primary key on columns (i1, i2). The optimizer ... InnoDB automatically extends each secondary index by appending the primary key columns to ...
https://dev.mysql.com/doc/refman/5.7/en/starting-server-troubleshooting.html
You can create a my.cnf file and specify startup options for the engines that you plan to use. For example, if the data directory is /usr/local/mysql/var, use this command: $> ls -la /usr/local/mysql/var If the data directory or its files or ...
https://dev.mysql.com/doc/refman/5.7/en/miscellaneous-functions.html
Given this statement: CREATE TABLE t AS SELECT INET6_NTOA(expr) AS c1; The resulting table would have this definition: CREATE TABLE t (c1 VARCHAR(39) CHARACTER SET utf8 DEFAULT NULL); The return string uses lowercase letters for IPv6 addresses. The ...The function return value and type are the same as the return value and type of its argument, but the function result is not checked for the ONLY_FULL_GROUP_BY SQL ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-rolling-restart.html
Create a backup using the ndb_mgm client START BACKUP command prior to performing the restart. Use mysqldump to create a backup prior to the upgrade; afterward, restore the dump using LOAD DATA. This also applies to any MySQL Server version change ... This section discusses how to perform a rolling restart of an NDB Cluster installation, so called because it involves stopping and starting (or restarting) each node in turn, so that the cluster itself remains ...
https://dev.mysql.com/doc/refman/5.7/en/ansi-diff-comments.html
In this case, the generated statement looks like this: UPDATE account SET balance=balance--1 WHERE account_id=5752; balance--1 is valid standard SQL, but -- is interpreted as the start of a comment, and part of the expression is discarded. The ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
Condition filtering enables the optimizer to use other relevant conditions in the WHERE clause not taken into account by the access method, and thus improve its prefix row count estimates. It was not already taken into account by the access method.
https://dev.mysql.com/doc/refman/5.7/en/unix-signal-response.html
On Unix and Unix-like systems, a process can be the recipient of signals sent to it by the root system account or the system account that owns the process. This is like executing a SHUTDOWN statement without having to connect to the server (which ...Some command interpreters associate certain key sequences with signals, such as Control+C to send a SIGINT ...
https://dev.mysql.com/doc/refman/5.7/en/host-cache.html
The server handles entries in the host cache like this: When the first TCP client connection reaches the server from a given IP address, a new cache entry is created to record the client IP, host name, and client lookup validation flag. Only ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-api-definition.html
Decreasing this parameter online after any tables have been created or modified with DefaultHashMapSize equal to 3840 is not currently supported. Time elapsed during node connection attempts is not taken into account when calculating elapsed time ...