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/create-index.html
Functional indexes are implemented as hidden virtual generated columns, which has these implications: Each functional key part counts against the limit on total number of table columns; see Section 10.4.7, “Limits on Table Column Count and Row ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-stopwords.html
Maximum and minimum word length values are configurable using the innodb_ft_max_token_size and innodb_ft_min_token_size variables. The stopword list is loaded and searched for full-text queries using the server character set and collation (the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-differing-tables.html
It is usually possible to replicate from a column of a given data type to another column of the same type and same size or width, where applicable, or larger. Row-based replication supports attribute promotion and demotion between smaller data types ...Attribute promotion can be used with both statement-based and row-based replication, and is not dependent on the storage engine used by either the source or the ...
https://dev.mysql.com/doc/refman/8.0/en/values.html
VALUES is a DML statement introduced in MySQL 8.0.19 which returns a set of one or more rows as a table. VALUES row_constructor_list [ORDER BY column_designator] [LIMIT number] row_constructor_list: ROW(value_list)[, ROW(value_list)][, ...] ...In ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-porting-mysql.html
When using functions such as AVG(), which depend on the number of rows in the result set, include WHERE clauses to filter out non-numeric values. row *************************** name: aaa db_schema: test db_table: demo_test key_columns: c1 ...
https://dev.mysql.com/doc/refman/8.0/en/slow-query-log.html
The slow query log consists of SQL statements that take more than long_query_time seconds to execute and require at least min_examined_row_limit rows to be examined. Note If you specify the TABLE log destination, see Log Tables and “Too many open ...The slow query log can be used to find queries that take a long time to execute and are therefore candidates for ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-transaction-management.html
Avoid performing rollbacks after inserting, updating, or deleting huge numbers of rows. To minimize the chance of this issue occurring: Increase the size of the buffer pool so that all the data change changes can be cached rather than immediately ...
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. For InnoDB tables, the row count is only a rough estimate used in SQL optimization. (This is also true if ... SHOW TABLE STATUS [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr] SHOW TABLE STATUS works likes SHOW TABLES, but provides a lot of information about each non-TEMPORARY ...
https://dev.mysql.com/doc/refman/8.0/en/insert.html
| TABLE table_name | VALUES row_constructor_list } [ON DUPLICATE KEY UPDATE assignment_list] value: {expr | DEFAULT} value_list: value [, value] ... row_constructor_list: ROW(value_list)[, ROW(value_list)][, ...] assignment: col_name = value | ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication-system-variables.html
authentication_ldap_sasl_init_pool_size Command-Line Format --authentication-ldap-sasl-init-pool-size=# System Variable authentication_ldap_sasl_init_pool_size Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 10 Minimum ...