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/innodb-compression-tuning.html
Whether the workload is more like a data warehouse (primarily queries) or an OLTP system (mix of queries and DML). Data Characteristics and Compression A key determinant of the efficiency of compression in reducing the size of data files is the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-programs-ndb-import.html
--ai-increment=# Command-Line Format --ai-increment=# Type Integer Default Value 1 Minimum Value 1 Maximum Value 4294967295 For a table with a hidden primary key, specify the autoincrement increment, like the auto_increment_increment system variable ... ndb_import imports CSV-formatted data, such as that produced by mysqldump --tab, directly into NDB using the NDB ...
https://dev.mysql.com/doc/refman/8.0/en/using-encrypted-connections.html
Several configuration parameters are available to indicate whether to use encrypted connections, and to specify the appropriate certificate and key files. Instructions for creating any required certificate and key files are available in Section ...
https://dev.mysql.com/doc/refman/8.0/en/explain-extended.html
row *************************** id: 1 select_type: PRIMARY table: t1 type: index possible_keys: NULL key: PRIMARY key_len: 4 ref: NULL rows: 4 filtered: 100.00 Extra: Using index *************************** 2. row *************************** id: 2 ... The EXPLAIN statement produces extra (“extended”) information that is not part of EXPLAIN output but can be viewed by issuing a SHOW WARNINGS statement following ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-indexes-table.html
Examples: PRIMARY for a primary key index, GEN_CLUST_INDEX for the index representing a primary key when one is not specified, and ID_IND, FOR_IND, and REF_IND for foreign key constraints. For related usage information and examples, see Section ...
https://dev.mysql.com/doc/refman/8.0/en/limit-optimization.html
In this case, as we can see from the EXPLAIN output, it uses the table's primary key. row *************************** id: 1 select_type: SIMPLE table: t partitions: NULL type: range possible_keys: i key: i key_len: 8 ref: NULL rows: 14 filtered: ...
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks.html
The REQUIRE_TABLE_PRIMARY_KEY_CHECK option (available from MySQL 8.0.20) makes the replication channel use its own policy for primary key checks. Setting ON means that primary keys are always required, and setting OFF means that primary keys are ...
https://dev.mysql.com/doc/refman/8.0/en/load-data.html
Unless REPLACE is also specified, LOCAL has the same effect as the IGNORE modifier on the interpretation of input file contents and error handling; see Duplicate-Key and Error Handling, and Column Value Assignment. With IGNORE, new rows that ...The ...
https://dev.mysql.com/doc/refman/8.0/en/connection-options.html
Command Options for Encrypted Connections This section describes options for client programs that specify whether to use encrypted connections to the server, the names of certificate and key files, and other parameters related to ... This section ...
https://dev.mysql.com/doc/refman/8.0/en/server-status-variables.html
The optional GLOBAL keyword aggregates the values over all connections, and SESSION shows the values for the current connection. Caching_sha2_password_rsa_public_key The public key used by the caching_sha2_password authentication plugin for RSA key ... The MySQL server maintains many status variables that provide information about its ...