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/transport-protocols.html
However, the named_pipe_full_access_group system variable is available to control which MySQL users are permitted to use named-pipe connections. For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-files.html
For the first one found to be set, MySQL uses it and does not check those remaining. If the MySQL server is acting as a replica, you can set the slave_load_tmpdir system variable to specify a separate directory for holding temporary files when ...If ... On Unix, MySQL uses the value of the TMPDIR environment variable as the path name of the directory in which to store temporary ...
https://dev.mysql.com/doc/refman/5.7/en/slow-query-log.html
Queries are only added to the replica's slow query log when they are logged in statement format in the binary log, that is, when binlog_format=STATEMENT is set, or when binlog_format=MIXED is set and the statement is logged in statement format. Slow ...The slow query log can be used to find queries that take a long time to execute and are therefore candidates for ... The slow query log consists of SQL statements ...
https://dev.mysql.com/doc/refman/5.7/en/selinux-troubleshooting.html
In this case, a “denial” message is logged to /var/log/audit/audit.log: $> grep "denied" /var/log/audit/audit.log type=AVC msg=audit(1587133719.786:194): avc: denied { write } for pid=7133 comm="mysqld" name="mysql" dev="dm-0" ino=51347078 ...
https://dev.mysql.com/doc/refman/5.7/en/introduction.html
The MySQL software delivers a very fast, multithreaded, multi-user, and robust SQL (Structured Query Language) database server. Users can choose to use the MySQL software as an Open Source product under the terms of the GNU General Public License ...MySQL Server is intended for mission-critical, heavy-load production systems as well as for embedding into mass-deployed ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
--database=name, -d name Command-Line Format --database=name Type String Default Value [none] Minimum Value Maximum Value The name of the database that contains the table being queried. --ndb-connectstring Command-Line Format ... ndb_index_stat ...
https://dev.mysql.com/doc/refman/5.7/en/insert.html
SET forms of the statement insert rows based on explicitly specified values. For example, if you specify a column list that does not name all the columns in the table, unnamed columns are set to their default values. If both the column list and the ...[ON DUPLICATE KEY UPDATE assignment_list] INSERT [LOW_PRIORITY | DELAYED | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] SET assignment_list [ON DUPLICATE KEY UPDATE assignment_list] INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] SELECT ...
https://dev.mysql.com/doc/refman/5.7/en/json-modification-functions.html
For a comparison of JSON_INSERT(), JSON_REPLACE(), and JSON_SET(), see the discussion of JSON_SET(). \ Please use JSON_MERGE_PRESERVE/JSON_MERGE_PATCH instead 1 row in set (0.00 sec) For additional examples, see the entry for JSON_MERGE_PRESERVE().
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-tcp-definition.html
Normally it is not necessary to define TCP/IP connections; NDB Cluster automatically sets up such connections for all data nodes, management nodes, and SQL or API nodes. It is also possible to change the default values for these parameters by ...To ...
https://dev.mysql.com/doc/refman/5.7/en/replace-third-party-yum.html
For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can replace a third-party distribution of MySQL with the latest GA release (from the MySQL 5.7 series currently) ...Adding the MySQL Yum Repository Add the MySQL Yum repository to your system's repository list by following the instructions given in Adding the MySQL Yum ...