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/mysql-cluster-ndb-transporter-errors.html
This section lists error codes, names, and messages that are written to the cluster log in the event of transporter errors. 0x00 TE_NO_ERROR No error 0x01 TE_ERROR_CLOSING_SOCKET Error found during closing of socket 0x02 ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-queries.html
Do not specify too many or too long columns in the primary key, because these column values are duplicated in each secondary index. If you have many queries for the same table, testing different combinations of columns, try to create a small number ... To tune queries for InnoDB tables, create an appropriate set of indexes on each ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-command-options.html
--max-join-size=value Command-Line Format --max-join-size=value Type Numeric Default Value 1000000 The automatic limit for rows in a join when using --safe-updates. --auto-vertical-output Command-Line Format --auto-vertical-output Cause result sets ... mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-change-buffer.html
Consider decreasing innodb_change_buffer_max_size on a MySQL server with static data used for reporting, or if the change buffer consumes too much of the memory space shared with the buffer pool, causing pages to age out of the buffer pool sooner ...
https://dev.mysql.com/doc/refman/8.0/en/host-cache.html
Starting the server with --skip-host-cache does not prevent runtime changes to the value of host_cache_size, but such changes have no effect and the cache is not re-enabled even if host_cache_size is set larger than 0. Some errors are considered ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
The temporary result set has become too large (see Section 10.4.4, “Internal Temporary Table Use in MySQL”). This state occurs after the table with the new structure has been created but before rows are copied into it. Copying to group table If ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...
https://dev.mysql.com/doc/refman/8.0/en/create-user.html
CREATE USER permits these auth_option syntaxes: IDENTIFIED BY 'auth_string' Sets the account authentication plugin to the default plugin, passes the cleartext 'auth_string' value to the plugin for possible hashing, and stores the result in the ...
https://dev.mysql.com/doc/refman/8.0/en/window-function-optimization.html
For example, adding a very small floating-point value to a very large value causes the very small value to be “hidden” by the large value. When inverting the large value later, the effect of the small value is lost. For EXPLAIN, windowing ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-space.html
For example: mysql> SET GLOBAL innodb_segment_reserve_factor=10; How Pages Relate to Table Rows For for 4KB, 8KB, 16KB, and 32KB innodb_page_size settings, the maximum row length is slightly less than half a database page size. For example, the ...
https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html
First approach to solving the problem: For each salesperson, calculate the maximum sale size, and also find the customer who provided this maximum. A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM ...