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/explain-output.html
If you restrict queries with the max_join_size system variable, this row product also is used to determine which multiple-table SELECT statements to execute and which to abort. EXPLAIN returns a row of information for each table used in the SELECT ... The EXPLAIN statement provides information about how MySQL executes ...
https://dev.mysql.com/doc/refman/8.0/en/table-scan-avoidance.html
You are comparing indexed columns with constant values and MySQL has calculated (based on the index tree) that the constants cover too large a part of the table and that a table scan would be faster. This is common for tables with fewer than 10 rows ... The output from EXPLAIN shows ALL in the type column when MySQL uses a full table scan to resolve a ...
https://dev.mysql.com/doc/refman/8.0/en/mysqlbinlog.html
--binlog-row-event-max-size=N Command-Line Format --binlog-row-event-max-size=# Type Numeric Default Value 4294967040 Minimum Value 256 Maximum Value 18446744073709547520 Specify the maximum size of a row-based binary log event, in bytes. Rows are ...For statement-based logging, event information includes the SQL statement, the ID of the server on which it was executed, the timestamp when the statement was executed, how much time it took, and so ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-key-cache.html
The key cache also is not used if the key_buffer_size value is too small to allocate the minimal number of block buffers (8). To control the size of the key cache, use the key_buffer_size system variable. Usually the size of an index block is equal ... To minimize disk I/O, the MyISAM storage engine exploits a strategy that is used by many database management ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-reference.html
binlog_transaction_dependency_history_size: Number of row hashes kept for looking up transaction that last updated some row. max_relay_log_size: If nonzero, relay log is rotated automatically when its size exceeds this value. If zero, size at which ... The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs-relaylog.html
When the size of the current relay log file becomes too large, which is determined as follows: If the value of max_relay_log_size is greater than 0, that is the maximum relay log file size. If the value of max_relay_log_size is 0, max_binlog_size ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-statement-summary-tables.html
By default, the table is autosized, but if this size is too small, set the performance_schema_digests_size system variable to a larger value at server startup. The QUERY_SAMPLE_TEXT, QUERY_SAMPLE_SEEN, and QUERY_SAMPLE_TIMER_WAIT columns also are ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-innodb-change-buffer.html
When should the change buffer be used? The change buffer is a feature designed to reduce random I/O to secondary indexes as indexes grow larger and no longer fit in the InnoDB buffer pool. How do I determine the current size of the change buffer? ...
https://dev.mysql.com/doc/refman/8.0/en/create-tablespace.html
FILE_BLOCK_SIZE is required when you intend to use the tablespace for storing compressed InnoDB tables (ROW_FORMAT=COMPRESSED). If FILE_BLOCK_SIZE is equal the innodb_page_size value, the tablespace can contain only tables having an uncompressed row ...It can hold multiple tables, and supports all table row ...The ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-transactions.html
To ensure that a given transaction reads only before or after values, you can impose row locks using SELECT ... LOCK IN SHARE MODE causes shared row locks to be used; FOR UPDATE causes exclusive row locks to be used. To avoid modification of the ...