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/user-variables.html
A value having the JSON data type is converted to a string with a character set of utf8mb4 and a collation of utf8mb4_bin. This does not currently include contexts that explicitly require a literal value, such as in the LIMIT clause of a SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/rebuilding-tables.html
If you need to rebuild an InnoDB table because a CHECK TABLE operation indicates that a table upgrade is required, use mysqldump to create a dump file and mysql to reload the file. For example, an error in a collation might have been corrected, ...
https://dev.mysql.com/doc/refman/8.0/en/postinstallation.html
For other platforms and installation types, you must initialize the data directory manually. This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables.
https://dev.mysql.com/doc/refman/8.0/en/replication-security.html
Encrypt the binary log files and relay log files on sources and replicas, which protects this data at rest, and also any data in use in the binary log cache. To protect against unauthorized access to data that is stored on and transferred between ...See Section 19.3.2, “Encrypting Binary Log Files and Relay Log ...Privilege checks are implemented by setting up a PRIVILEGE_CHECKS_USER account, which MySQL uses to ...
https://dev.mysql.com/doc/refman/8.0/en/environment-variables.html
Options on the command line take precedence over values specified in option files and environment variables, and values in option files take precedence over values in environment variables. In many cases, it is preferable to use an option file ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mysql-database.html
The contents of the grant tables in the mysql database can be modified directly (for example, with INSERT or DELETE) or indirectly (for example, with GRANT or CREATE USER). Statements that affect mysql database tables are written to the binary log ...This pertains to statements such as INSERT, UPDATE, DELETE, REPLACE, DO, LOAD DATA, SELECT, and TRUNCATE ...This ...
https://dev.mysql.com/doc/refman/8.0/en/foreign-key-optimization.html
If a table has many columns, and you query many different combinations of columns, it might be efficient to split the less-frequently used data into separate tables with a few columns each, and relate them back to the main table by duplicating the ...(To maximize performance, queries try to read as few data blocks as possible from disk; tables with only a few columns can fit more rows in each data ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-st-spatial-reference-systems-table.html
The ST_SPATIAL_REFERENCE_SYSTEMS table provides information about available spatial reference systems (SRSs) for spatial data. Entries in the ST_SPATIAL_REFERENCE_SYSTEMS table are based on the European Petroleum Survey Group (EPSG) data set, ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-processes.html
The processes table contains the following columns: node_id The node's unique node ID in the cluster node_type Type of node (management, data, or API node; see text) node_version Version of the NDB software program running on this node. This table ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-shell-tutorial-javascript-documents-in-tables.html
You can combine traditional data with JSON documents by storing the documents in columns having a native JSON data type. See Section 13.5, “The JSON Data Type” for a detailed description of the data type. In MySQL, a table may contain ...