PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/analyze-table.html
ANALYZE TABLE with the UPDATE HISTOGRAM clause generates histogram statistics for the named table columns and stores them in the data dictionary. These histogram operations are available: ANALYZE TABLE with an UPDATE HISTOGRAM clause generates ...
https://dev.mysql.com/doc/refman/8.0/en/option-files.html
Option files provide a convenient way to specify commonly used options so that they need not be entered on the command line each time you run a program. Most MySQL programs can read startup options from option files (sometimes called configuration ...To determine whether a program reads option files, invoke it with the --help ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current timestamp). In addition, if the explicit_defaults_for_timestamp system variable is disabled, you can initialize or update ...For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-windows-binary.html
For management nodes and data nodes, it is not necessary to install the MySQL Server binary; however, each management node requires the management server daemon (ndb_mgmd.exe); each data node requires the data node daemon (ndbd.exe or ndbmtd.exe).
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog-backup.html
By default, mysqlbinlog reads binary log files and displays their contents in text format. This enables you to examine events within the files more easily and to re-execute them (for example, by using the output as input to mysql). mysqlbinlog can ...This capability enables you to easily back up a binary log in its original ...
https://dev.mysql.com/doc/refman/8.0/en/network-namespace-support.html
Each namespace has its own IP addresses, network interfaces, routing tables, and so forth. This can produce phenomena such as a client connection from an address in one namespace appearing to the MySQL server to be coming from a different address, ... A network namespace is a logical copy of the network stack from the host ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For definitions of character string columns (CHAR, VARCHAR, and the TEXT types), MySQL interprets length specifications in character units. For definitions of ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
A table is reported as needing a rebuild if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision) and the avoid_temporal_upgrade system variable is disabled. If ...CHECK TABLE is supported for partitioned tables, and you can use ALTER TABLE ...option: { FOR UPGRADE | QUICK | ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-internals.html
The expire_time_column value is related to the way memcached hashes requests to different servers and caches data in memory. Specify 0 for flags, cas_column, and expire_time_column if they are unused. InnoDB API functions access the InnoDB tables ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-multi-source.html
All SQL nodes acting as sources and replicas are started with the system variable log_replica_updates (beginning with NDB 8.0.26) or log_slave_updates (NDB 8.0.26 and earlier) enabled. You must not start any of the SQL nodes with the system variable ...Each cluster has two SQL nodes, with SQL nodes A and B belonging to Cluster 1, SQL nodes C and D belonging to Cluster 2, and SQL nodes E and F belonging to ...