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/information-schema-innodb-foreign-table.html
The INNODB_FOREIGN table has these columns: ID The name (not a numeric value) of the foreign key index, preceded by the schema (database) name (for example, test/products_fk). FOR_NAME The name of the child table in this foreign key relationship.
https://dev.mysql.com/doc/refman/8.0/en/merge-table-problems.html
MySQL ensures that unique key values remain unique within that MyISAM table, but not over all the underlying tables in the collection. The two key facts are: REPLACE can detect unique key violations only in the underlying table to which it is going ... The following are known problems with MERGE tables: MERGE child tables are locked through the parent ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-other-options.html
myisamchk supports the following options for actions other than table checks and repairs: --analyze, -a Command-Line Format --analyze Analyze the distribution of key values. To obtain information about the key distribution, use a myisamchk ...This ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-repair-options.html
--keys-used=val, -k val Command-Line Format --keys-used=val Type Numeric For myisamchk, the option value is a bit value that indicates which indexes to update. Use the same technique as -r and -n, but create all the keys in parallel, using different ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-params-ndbd.html
MaxFKBuildBatchSize: Maximum scan batch size to use for building foreign keys. Increasing this value may speed up builds of foreign keys but impacts ongoing traffic as well. MaxUIBuildBatchSize: Maximum scan batch size to use for building unique ...
https://dev.mysql.com/doc/refman/8.0/en/MySQLInstallerConsole.html
option_value_pair: A single option (for example, --silent) or a tuple of a key and a corresponding value with an options prefix. Passing in a product keyword alone selects the latest version of the product. Alternatively, you can pass in the exact ... MySQLInstallerConsole.exe provides command-line functionality that is similar to MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-management.html
For a discussion of managing HASH and KEY partitions, see Section 26.3.2, “Management of HASH and KEY Partitions”. To change a table's partitioning scheme, it is necessary only to use the ALTER TABLE statement with a partition_options option, ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table-optimization.html
Also, in addition to setting memory-allocation variables, increasing the myisam_max_sort_file_size system variable increases the likelihood that the repair uses the faster filesort method and avoids the slower repair by key cache method. Changing a ... REPAIR TABLE for MyISAM tables is similar to using myisamchk for repair operations, and some of the same performance optimizations apply: myisamchk has variables that control memory ...
https://dev.mysql.com/doc/refman/8.0/en/replication-encrypted-connections.html
(ssl_capath is similar but specifies the path name of a directory of CA certificate files.) ssl_cert: The path name of the server public key certificate file. To use an encrypted connection for the transfer of the binary log required during ...
https://dev.mysql.com/doc/refman/8.0/en/engine-condition-pushdown-optimization.html
row *************************** id: 1 select_type: SIMPLE table: x partitions: p0,p1 type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4 filtered: 100.00 Extra: NULL *************************** 2. row *************************** ... This optimization improves the efficiency of direct comparisons between a nonindexed column and a ...