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/linux-installation-native.html
Many Linux distributions include a version of the MySQL server, client tools, and development components in their native software repositories and can be installed with the platforms' standard package management systems. For Red Hat and similar ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-resources.html
DISK_OPERATIONS: If a log file group is allocated, the size of the undo log buffer is used to set the size of this resource. Size is NoOfFragmentLogParts * RedoBuffer, plus 1 MB per log file part. This table provides information about data node ...
https://dev.mysql.com/doc/refman/8.0/en/repair-table-optimization.html
For example, if you set the myisamchk key_buffer_size variable to 128MB, you could set the corresponding key_buffer_size system variable larger than that (if it is not already set larger), to permit key buffer use by activity in other sessions.
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/create-index.html
Functional indexes are implemented as hidden virtual generated columns, which has these implications: Each functional key part counts against the limit on total number of table columns; see Section 10.4.7, “Limits on Table Column Count and Row ...
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/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 ...