Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/en/linux-installation-yum-repo.html
Install the RPM you downloaded for your system, for example: $> sudo yum localinstall mysql84-community-release-{platform}-{version-number}.noarch.rpm The installation command adds the MySQL Yum repository to your system's repository list and ...
https://dev.mysql.com/doc/refman/8.4/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.4/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. You can specify this option twice to force myisamchk to modify the original data file in ...--correct-checksum Command-Line Format --correct-checksum Correct the checksum information for the ...
https://dev.mysql.com/doc/refman/8.4/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.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-handling-nulls.html
NULL is handled somewhat differently for tables partitioned by HASH or KEY. For tables that are partitioned by HASH or KEY, this result is treated for determining the correct partition as 0. Partitioning in MySQL does nothing to disallow NULL as ...
https://dev.mysql.com/doc/refman/8.4/en/partitioning-maintenance.html
Example: ALTER TABLE t1 REPAIR PARTITION p0,p1; Normally, REPAIR PARTITION fails when the partition contains duplicate key errors. You can use ALTER IGNORE TABLE with this option, in which case all rows that cannot be moved due to the presence of ...
https://dev.mysql.com/doc/refman/8.4/en/rename-table.html
RENAME TABLE tbl_name TO new_tbl_name changes internally generated foreign key constraint names and user-defined foreign key constraint names that begin with the string “tbl_name_ibfk_” to reflect the new table name. InnoDB interprets foreign ...