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/kerberos-pluggable-authentication.html
Kerberos pluggable authentication provides these capabilities: External authentication: Kerberos authentication enables MySQL Server to accept connections from users defined outside the MySQL grant tables who have obtained the proper Kerberos ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-search-mecab.html
Creating a FULLTEXT Index that uses the MeCab Parser To create a FULLTEXT index that uses the mecab parser, specify WITH PARSER ngram with CREATE TABLE, ALTER TABLE, or CREATE INDEX. For InnoDB tables, minimum token size is defined by the ... The ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-filtering.html
The audit_log plugin operates in legacy mode if it is installed but the accompanying audit tables and functions are not created. Note For audit log filtering to work as described here, the audit log plugin and the accompanying audit tables and ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
Why do I get Incorrect string value error messages? To see the problem, create a table with one Unicode (ucs2) column and one Chinese (gb2312) column. mysql> CREATE TABLE ch (ucs2 CHAR(3) CHARACTER SET ucs2, gb2312 CHAR(3) CHARACTER SET gb2312); In ...Does MySQL permit CJK characters to be used in database and table names? ... This set of Frequently Asked Questions derives from the experience of MySQL's Support and ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-hash.html
To partition a table using HASH partitioning, it is necessary to append to the CREATE TABLE statement a PARTITION BY HASH (expr) clause, where expr is an expression that returns an integer. In addition, you most likely want to follow this with ...
https://dev.mysql.com/doc/refman/8.0/en/docker-mysql-more-topics.html
Warning Any software updates or installations users perform to the Docker container (including those for MySQL components) may conflict with the optimized MySQL installation created by the Docker image. Oracle does not provide support for MySQL ...A ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-space-requirements.html
Temporary log files: A temporary log file records concurrent DML when an online DDL operation creates an index or alters a table. Temporary sort files: Online DDL operations that rebuild the table write temporary sort files to the MySQL temporary ...
https://dev.mysql.com/doc/refman/8.0/en/show-columns.html
The data types may differ from what you expect them to be based on a CREATE TABLE statement because MySQL sometimes changes data types when you create or alter a table. The SHOW CREATE TABLE, SHOW TABLE STATUS, and SHOW INDEX statements also provide ... SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW COLUMNS displays information about the columns in a given ...
https://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html
With an innodb_force_recovery value of 3 or less you can DROP or CREATE tables. To investigate database page corruption, you might dump your tables from the database with SELECT ... In such cases, you can use the innodb_force_recovery option to ...
https://dev.mysql.com/doc/refman/8.0/en/host-cache.html
The Performance Schema host_cache table exposes the contents of the host cache so that it can be examined using SELECT statements. It does not use the cache for TCP connections established using a loopback interface address (for example, 127.0.0.1 ... The MySQL server maintains an in-memory host cache that contains information about clients: IP address, host name, and error ...