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/internal-locking.html
Advantages of table-level locking: Relatively little memory required (row locking requires memory per row or group of rows locked) Fast when used on a large part of the table because only a single lock is involved. Row-Level Locking Table-Level ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo.html
row *************************** Engine: ndbcluster Support: YES Comment: Clustered, fault-tolerant tables Transactions: YES XA: NO Savepoints: NO *************************** 2. row *************************** Engine: CSV Support: YES Comment: CSV ...
https://dev.mysql.com/doc/refman/8.0/en/partitioning-limitations.html
In particular, you should make sure that large_files_support is enabled and that open_files_limit is set properly. If, when creating tables with a large number of partitions (but less than the maximum), you encounter an error message such as Got ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-performance.html
row *************************** Id: 5 User: root Host: localhost db: test Command: Query Time: 44 State: Waiting for table metadata lock Info: ALTER TABLE t1 ADD COLUMN x INT, ALGORITHM=INPLACE, LOCK=NONE ... Online DDL Performance The performance ... Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
When using row-based logging, no distinction is made in the treatment of safe and unsafe statements. When using mixed-format logging, statements flagged as unsafe are logged using the row-based format; statements regarded as safe are logged using ...
https://dev.mysql.com/doc/refman/8.0/en/truncate-table.html
It differs from DELETE in the following ways: Truncate operations drop and re-create the table, which is much faster than deleting rows one by one, particularly for large tables. Logically, TRUNCATE TABLE is similar to a DELETE statement that ...To ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-status.html
When the replication SQL (applier) thread has caught up on I/O, Seconds_Behind_Source displays 0; but when the replication I/O (receiver) thread is still queuing up a new event, Seconds_Behind_Source may show a large value until the replication ...
https://dev.mysql.com/doc/refman/8.0/en/nested-loop-joins.html
Nested-Loop Join Algorithm Block Nested-Loop Join Algorithm Nested-Loop Join Algorithm A simple nested-loop join (NLJ) algorithm reads rows from the first table in a loop one at a time, passing each row to a nested loop that processes the next table ... MySQL executes joins between tables using a nested-loop algorithm or variations on ...
https://dev.mysql.com/doc/refman/8.0/en/data-change-optimization.html
Data analysis and reporting applications typically run data change operations that affect many rows at once, where the main considerations is the I/O to write large amounts of data and keep indexes up-to-date. For inserting and updating large ...