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/sys-ps-thread-trx-info.html
Configuration Options ps_thread_trx_info() operation can be modified using the following configuration options or their corresponding user-defined variables (see Section 26.4.2.1, “The sys_config Table”): ps_thread_trx_info.max_length, ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
This means, for example, that you cannot set the default for a date column to be the value of a function such as NOW() or CURRENT_DATE. If strict mode is not enabled, MySQL sets the column to the implicit default value for the column data type.
https://dev.mysql.com/doc/refman/5.7/en/rebuilding-tables.html
This section describes how to rebuild or repair tables or indexes, which may be necessitated by: Changes to how MySQL handles data types or character sets. For example, an error in a collation might have been corrected, necessitating a table ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-key.html
Partitioning by key is similar to partitioning by hash, except that where hash partitioning employs a user-defined expression, the hashing function for key partitioning is supplied by the MySQL server. NDB Cluster uses MD5() for this purpose; for ...PARTITION BY KEY are similar to those for creating a table that is partitioned by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-error-reporter.html
Optionally, you can supply the name of a user that is able to access the cluster's data nodes using SSH, to copy the data node log files. ndb_error_reporter also accepts the options listed here: --connection-timeout=timeout Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/pluggable-storage.html
Plugging in a Storage Engine Before a storage engine can be used, the storage engine plugin shared library must be loaded into MySQL using the INSTALL PLUGIN statement. Ensure that there are no tables using a storage engine before you unplug the ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-views.html
The sys schema contains many views that summarize Performance Schema tables in various ways. The view with the x$ prefix that displays the same values in raw form is intended more for use with other tools that perform their own processing on the ...
https://dev.mysql.com/doc/refman/5.7/en/general-tablespaces.html
As with file-per-table tablespaces, the ability to place data files outside of the MySQL data directory allows you to manage performance of critical tables separately, setup RAID or DRBD for specific tables, or bind tables to particular disks, for ...The server keeps tablespace metadata in memory for the lifetime of a ... A general tablespace is ...
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/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 ...