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/optimizer-statistics.html
The optimizer applies histogram statistics to determine row estimates based on the selectivity (filtering effect) of column value comparisons against constant values. Adding an index to a column for which histogram statistics are applicable might ...
https://dev.mysql.com/doc/refman/8.0/en/out-of-range-and-overflow.html
If no restrictive modes are enabled, MySQL clips the value to the appropriate endpoint of the column data type range and stores the resulting value instead. When an out-of-range value is assigned to an integer column, MySQL stores the value ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-file-summary-tables.html
row *************************** EVENT_NAME: wait/io/file/sql/binlog COUNT_STAR: 31 SUM_TIMER_WAIT: 8243784888 MIN_TIMER_WAIT: 0 AVG_TIMER_WAIT: 265928484 MAX_TIMER_WAIT: 6490658832 ... row *************************** FILE_NAME: ... The Performance ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-instrument-naming.html
The TIMED column for the error row in the setup_instruments table is inapplicable because timing information is not collected. These include row-level accesses to persistent base tables or temporary tables. Thus, events_waits_current for a table I/O ... An instrument name consists of a sequence of elements separated by '/' ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-processlist-table.html
The processlist table contains a row for each server process: mysql> SELECT * FROM performance_schema.processlist\G *************************** 1. row *************************** ID: 5 USER: event_scheduler HOST: localhost DB: NULL COMMAND: Daemon ... The MySQL process list indicates the operations currently being performed by the set of threads executing within the ...
https://dev.mysql.com/doc/refman/8.0/en/rename-table.html
row *************************** Table: t3 Create Table: CREATE TABLE `t3` ( `i1` int(11) DEFAULT NULL, `i2` int(11) DEFAULT NULL, CONSTRAINT `t3_chk_1` CHECK ((`i1` > 0)), CONSTRAINT `t3_chk_2` CHECK ((`i2` < 0)) ) ENGINE=InnoDB DEFAULT ... RENAME ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-errors.html
This can happen, for example, on a multiple-row insert that has one row violating a key constraint, or if a long update statement is killed after updating some of the rows. Beginning with MySQL 8.0.31, replication filter rules are applied first, ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-load-data.html
When binlog_format=MIXED is set, the statement is logged in row-based format. This temporary file is not encrypted, even if binary log encryption is active on the source, If encryption is required, use row-based or mixed binary logging format ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-triggers.html
With row-based replication, triggers executed on the source do not execute on the replica. Instead, the row changes on the source resulting from trigger execution are replicated and applied on the replica. If under row-based replication the replica ... With statement-based replication, triggers executed on the source also execute on the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rules-db-options.html
If the statement has been logged using the row format, the database where data is to be changed is the database that is checked. Note Only DML statements can be logged using the row format. When using row-based logging with the same option, the ...