PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/option-files.html
For example, to include the /home/mydir/myopt.cnf file, use the following directive: !include /home/mydir/myopt.cnf To search the /home/mydir directory and read option files found there, use this directive: !includedir /home/mydir MySQL makes no ...
https://dev.mysql.com/doc/refman/8.0/en/checking-gpg-signature-windows.html
Type "Mysql Release Engineering" into the search box and press Search. When the import dialog is displayed, choose Okay, and this certificate should now be listed under the Imported Certificates tab. This requires files for both the packaged file, ... The Section 2.1.4.2, “Signature Checking Using GnuPG” section describes how to verify MySQL downloads using ...
https://dev.mysql.com/doc/refman/8.0/en/controlling-query-plan-evaluation.html
If you are unsure of what a reasonable value is for optimizer_search_depth, this variable can be set to 0 to tell the optimizer to determine the value automatically. Because the difference in performance between “good” and “bad” plans can be ... The task of the query optimizer is to find an optimal plan for executing an SQL ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
This guideline is especially important for InnoDB tables, where the primary key determines the physical layout of rows in the data file. Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte ...
https://dev.mysql.com/doc/refman/8.0/en/delete.html
There are some exceptions to this behavior for InnoDB tables, as discussed in Section 17.6.1.6, “AUTO_INCREMENT Handling in InnoDB”. In this case, reuse of values deleted from the top of the sequence occurs even for MyISAM tables. This affects ... DELETE is a DML statement that removes rows from a ...
https://dev.mysql.com/doc/refman/8.0/en/explain-output.html
ref_or_null This join type is like ref, but with the addition that MySQL does an extra search for rows that contain NULL values. This means that MySQL reads a row from the first table, then finds a matching row in the second table, and then in the ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/8.0/en/handler-scope.html
When a condition occurs in a stored program, the server searches for applicable handlers in the current scope (current BEGIN ... If there are no applicable handlers, the search continues outward with the handlers in each successive containing scope ... A stored program may include handlers to be invoked when certain conditions occur within the ...
https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html
This means such names are not case-sensitive in Windows, but are case-sensitive in most varieties of Unix. The lower_case_table_names system variable also affects how the server handles identifier case sensitivity, as described later in this section. The following statement would not work on Unix, because it refers to the alias both as a and as A: mysql> SELECT col_name FROM tbl_name AS a WHERE a.col_name = 1 OR A.col_name = 2; However, this same statement is permitted on ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-config-table.html
The values for this column might change, depending on the needs for performance tuning and debugging for InnoDB full-text processing. Example mysql> SELECT * FROM INFORMATION_SCHEMA.INNODB_FT_CONFIG; +---------------------------+-------------------+ ... The INNODB_FT_CONFIG table provides metadata about the FULLTEXT index and associated processing for an InnoDB ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-ft-default-stopword-table.html
This is not used if you override the default stopword processing with either the innodb_ft_server_stopword_table or the innodb_ft_user_stopword_table system variable. Use the INFORMATION_SCHEMA COLUMNS table or the SHOW COLUMNS statement to view ...