PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/xa.html
In essence, this extends ACID properties “up a level” so that multiple ACID transactions can be executed in concert as components of a global operation that also has ACID properties. The process for executing a global transaction uses two-phase ... Support for XA transactions is available for the InnoDB storage ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
The first time you sort a large table this way, it may take a long time. MyISAM supports concurrent inserts: If a table has no free blocks in the middle of the data file, you can INSERT new rows into it at the same time that other threads are ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
Certain types of queries for INFORMATION_SCHEMA tables can be optimized to execute more quickly. For the second EXPLAIN output row: All COLUMNS table values are OPEN_FRM_ONLY lookups, so COLUMNS.TABLE_NAME requires the .frm file to be opened.
https://dev.mysql.com/doc/refman/5.7/en/group-replication-message-compression.html
Note that the maximum supported input size for the LZ4 compression algorithm is 2113929216 bytes. This limit is lower than the maximum possible value for the group_replication_compression_threshold system variable, which is matched to the maximum ...
https://dev.mysql.com/doc/refman/5.7/en/table-locking.html
In this case, the second SELECT statement in the preceding scenario would execute before the UPDATE statement, and would not wait for the first SELECT to finish. But because only one session can write to a table at any one time, for best performance ... InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-status-by-worker-table.html
If an error occurs, the column value is the GTID of the transaction being executed by the worker when the error occurred. LAST_ERROR_TIMESTAMP A timestamp in YYMMDD hh:mm:ss format that shows when the most recent worker error occurred. If gtid_mode ... If the replica is not multithreaded, this table shows the status of the applier ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
The source sends the events contained in its binary log to its replicas, which execute those events to make the same data changes that were made on the source. After a backup has been restored, the events in the binary log that were recorded after ... The binary log contains “events” that describe database changes such as table creation operations or changes to table ...
https://dev.mysql.com/doc/refman/5.7/en/binary-varbinary.html
If strict SQL mode is not enabled and you assign a value to a BINARY or VARBINARY column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. The permissible maximum length is the same for BINARY and ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-temp-tables.html
total_latency The total wait time of timed occurrences of the statement. last_seen The time at which the statement was most recently seen. These views list normalized statements that have used temporary tables. By default, rows are sorted by ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary.html
statement_latency The total wait time of timed statements for the host. statement_avg_latency The average wait time per timed statement for the host. file_io_latency The total wait time of timed file I/O events for the host. These views summarize ...