PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/plugin-loading.html
In the descriptions, plugin_name stands for a plugin name such as innodb, csv, or validate_password. The argument format is the same as for --plugin-load, but multiple instances of --plugin-load-add can be used to avoid specifying a large set of ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
This UPDATE statement uses a nondeterministic function to select rows to be modified: UPDATE t SET col_a = some_expr WHERE id = FLOOR(1 + RAND() * 49); Presumably the intent is to update at most a single row for which the primary key matches the ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log-mixed.html
The following system variables, when used with session scope (only), do not cause the logging format to switch: auto_increment_increment auto_increment_offset character_set_client character_set_connection character_set_database character_set_server ...(Bug #12092, Bug #30244) When USER(), CURRENT_USER(), or CURRENT_USER is ... When running in MIXED logging format, the server automatically switches from statement-based to row-based logging ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-metrics-table.html
Module names can be used to enable, disable, or reset all counters for a particular subsystem. mysql> SET GLOBAL innodb_monitor_reset = dml_inserts; Query OK, 0 rows affected (0.00 sec) mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_METRICS WHERE ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-general-options.html
--defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read this option file after the global option file but (on Unix) before the user option file. The options described in this section can be used for ...The sections following this one describe options that pertain only to specific operations, such as table checking or ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-shell-userguide.html
For documentation on the concepts and usage of X DevAPI, which is implemented in MySQL Shell, see X DevAPI User Guide. The AdminAPI enables database administrators to work with InnoDB Cluster, which provides an integrated solution for high ... MySQL ...MySQL Shell includes the following APIs implemented in JavaScript and Python which you can use to develop code that interacts with ...
https://dev.mysql.com/doc/refman/5.7/en/keywords.html
Certain keywords, such as SELECT, DELETE, or BIGINT, are reserved and require special treatment for use as identifiers such as table and column names. This may also be true for the names of built-in functions. For further details on recognition of ...Reserved words are permitted as identifiers if you quote them as described in Section 9.2, “Schema Object Names”: mysql> CREATE TABLE interval (begin INT, end INT); ERROR 1064 (42000): You have an error in your SQL syntax ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-system-variables.html
Thus, for any other region, this variable must be set explicitly. (It is permissible to rename or move the file, as long as you change the value of keyring_encrypted_file_data to match.) keyring_encrypted_file_password Command-Line Format ...These ...