Search Results
https://dev.mysql.com/doc/refman/8.4/en/external-locking.html
If you use myisamchk for write operations such as repairing or optimizing tables, or if you use myisampack to pack tables, you must always ensure that the mysqld server is not using the table. External locking is the use of file system locking to ...
https://dev.mysql.com/doc/refman/8.4/en/federated-create.html
The optimization occurs because the query sent to the remote server includes the contents of the WHERE clause and is sent to the remote server and subsequently executed locally. To create a FEDERATED table you should follow these steps: Create the ...
https://dev.mysql.com/doc/refman/8.4/en/full-disk.html
Exceptions to the preceding behavior are when you use REPAIR TABLE or OPTIMIZE TABLE or when the indexes are created in a batch after LOAD DATA or after an ALTER TABLE statement. This section describes how MySQL responds to disk-full errors (such ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-query-expansion.html
| | 3 | Optimizing MySQL | In this tutorial we show ... Full-text search supports query expansion (and in particular, its variant “blind query expansion”). This is generally useful when a search phrase is too short, which often means that the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-functions-for-new-primary.html
The following function enables you to set a member of a single-primary replication group to take over as the primary. The current primary becomes a read-only secondary, and the specified group member becomes the read-write primary. The function can ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-multi-primary-mode.html
Group Replication is based on an optimistic replication paradigm, where statements are optimistically executed and rolled back later if necessary. 20.1.3.2.3 Version Compatibility For optimal compatibility and performance, all members of a group ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-online-upgrade-combining-versions.html
For optimal compatibility and performance, all members of a group should run the same version of MySQL Server and therefore of Group Replication. Group Replication is versioned according to the MySQL Server version that the Group Replication plugin ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance.html
The information in this section is to help you configure a replication group to optimize the automatic handling of any recurring issues that you experience on your particular systems, such as transient network outages or workloads and transactions ... Group Replication is designed to create fault-tolerant systems with built-in failure detection and automated ...
https://dev.mysql.com/doc/refman/8.4/en/implicit-commit.html
ANALYZE TABLE, CACHE INDEX, CHECK TABLE, FLUSH, LOAD INDEX INTO CACHE, OPTIMIZE TABLE, REPAIR TABLE, RESET (but not RESET PERSIST). The statements listed in this section (and any synonyms for them) implicitly end any transaction active in the ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-column-statistics-table.html
For information about histogram statistics, see Section 10.9.6, “Optimizer Statistics”, and Section 15.7.3.1, “ANALYZE TABLE Statement”. The COLUMN_STATISTICS table provides access to histogram statistics for column values. You can see ...