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/explain.html
Note MySQL Workbench has a Visual Explain capability that provides a visual representation of EXPLAIN output. {EXPLAIN | DESCRIBE | DESC} tbl_name [col_name | wild] {EXPLAIN | DESCRIBE | DESC} [explain_type] {explainable_stmt | FOR CONNECTION ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-cjk.html
Of what issues should I be aware when working with Korean character sets in MySQL? In theory, while there have been several versions of the euckr (Extended Unix Code Korea) character set, only one problem has been noted. This set of Frequently ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-connectors-apis.html
For common questions, issues, and answers relating to the MySQL Connectors and other APIs, see the following areas of the Manual: Using C API Features Connector/ODBC Notes and Tips Connector/NET Programming MySQL Connector/J Developer Guide .
https://dev.mysql.com/doc/refman/8.0/en/faqs-replication.html
Note that if your replica has been disconnected from the source for one hour, and then reconnects, you may immediately see large Time values such as 3600 for the replication SQL thread in SHOW PROCESSLIST. Let reads and writes denote the number of ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/federated-create-connection.html
For example: CREATE TABLE federated_table ( id INT(20) NOT NULL AUTO_INCREMENT, name VARCHAR(32) NOT NULL DEFAULT '', other INT(20) NOT NULL DEFAULT '0', PRIMARY KEY (id), INDEX name (name), INDEX other_key (other) ) ENGINE=FEDERATED DEFAULT ... To ...
https://dev.mysql.com/doc/refman/8.0/en/file-permissions.html
If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld starts. For example, mysqld might issue the following error message when you create a table: ERROR: Can't find file: ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-reference.html
Example: SELECT normalize_statement('SELECT * FROM t1 WHERE c1 > 2'); Note The same digest functionality is available outside firewall context using the STATEMENT_DIGEST_TEXT() SQL function. When enabled, the firewall bases operational decisions on ...
https://dev.mysql.com/doc/refman/8.0/en/firewall.html
Note MySQL Enterprise Firewall is an extension included in MySQL Enterprise Edition, a commercial product. MySQL Enterprise Edition includes MySQL Enterprise Firewall, an application-level firewall that enables database administrators to permit or ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-query-expansion.html
Note Because blind query expansion tends to increase noise significantly by returning nonrelevant documents, use it only when a search phrase is short. Full-text search supports query expansion (and in particular, its variant “blind query ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html
Note By default, words less than 3 characters in length or greater than 84 characters in length do not appear in an InnoDB full-text search index. The stopword list is loaded and searched for full-text queries using the server character set and ...