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-cols-table.html
The INNODB_FOREIGN_COLS table provides status information about InnoDB foreign key columns. The INNODB_FOREIGN_COLS table has these columns: ID The foreign key index associated with this index key field; the same value as INNODB_FOREIGN.ID. POS The ...For related usage information and examples, see Section 17.15.3, “InnoDB INFORMATION_SCHEMA Schema Object ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-troubleshoot.html
loose-daemon_memcached_option='-vvv' If columns specified to hold memcached values are the wrong data type, such as a numeric type instead of a string type, attempts to store key-value pairs fail with no specific error code or message. As the length ... This section describes issues that you may encounter when using the InnoDB memcached ...
https://dev.mysql.com/doc/refman/8.0/en/insert-select.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... TABLE as well: Specify IGNORE to ignore rows that would cause duplicate-key violations. ON DUPLICATE ... INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { SELECT ...
https://dev.mysql.com/doc/refman/8.0/en/is-null-optimization.html
This optimization can handle one IS NULL for any key part. In the following query, MySQL uses key lookups only on the expression (t1.a=t2.a AND t2.a IS NULL) and is not able to use the key part on b: SELECT * FROM t1, t2 WHERE (t1.a=t2.a AND t2.a IS ... MySQL can perform the same optimization on col_name IS NULL that it can use for col_name = ...
https://dev.mysql.com/doc/refman/8.0/en/json-function-reference.html
Table 14.22 JSON Functions Name Description Introduced Deprecated -> Return value from JSON column after evaluating path; equivalent to JSON_EXTRACT(). ->> Return value from JSON column after evaluating path and unquoting the result; equivalent to ...
https://dev.mysql.com/doc/refman/8.0/en/kerberos-pluggable-authentication.html
Security: Kerberos uses tickets together with symmetric-key cryptography, enabling authentication without sending passwords over the network. KDC: The key distribution center, comprising the AS and TGS: AS: The authentication server; provides the ...
https://dev.mysql.com/doc/refman/8.0/en/keyring-plugin-installation.html
Keyring service consumers require that a keyring component or plugin be installed: To use a keyring plugin, begin with the instructions here. (Also, for general information about installing plugins, see Section 7.6.1, “Installing and Uninstalling ...To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk-memory.html
For example, if you have more than 512MB RAM available, you could use options such as these (in addition to any other options you might specify): myisamchk --myisam_sort_buffer_size=256M \ --key_buffer_size=512M \ --read_buffer_size=64M \ ...
https://dev.mysql.com/doc/refman/8.0/en/myisamchk.html
The myisamchk utility gets information about your database tables or checks, repairs, or optimizes them. myisamchk works with MyISAM tables (tables that have .MYD and .MYI files for storing data and indexes). You can also use the CHECK TABLE and ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-importing-data.html
When importing data from an SQL file, it is often not necessary to enforce transactions or foreign keys, and temporarily disabling these features can speed up the import process greatly. Within a mysql client session, you can perform the import ...