Search Results
https://dev.mysql.com/doc/refman/8.4/en/faqs-storage-engines.html
What are the unique benefits of the ARCHIVE storage engine? The ARCHIVE storage engine stores large amounts of data without indexes; it has a small footprint, and performs selects using table scans. Where can I obtain complete documentation for ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-thread-pool.html
The Thread Pool plugin increases server performance by efficiently managing statement execution threads for large numbers of client connections, especially on modern multi-CPU/Core systems. What is the Thread Pool and what problem does it solve? ...
https://dev.mysql.com/doc/refman/8.4/en/gis-class-point.html
Point Examples Imagine a large-scale map of the world with many cities. A Point is a geometry that represents a single location in coordinate space. On a city map, a Point object could represent a bus stop.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-replication-group-member-stats.html
Statistics regarding the certifier and applier procedures are useful to understand how the applier queue is growing, how many conflicts have been found, how many transactions were checked, which transactions are committed everywhere, and so on.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-view-changes.html
If there is not a large transaction gap, or if the clone plugin is not installed, Group Replication proceeds directly to state transfer from a donor's binary log. When Group Replication's distributed recovery process is carrying out state transfer ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-disabling-tablespace-path-validation.html
Disabling path validation improves startup time on systems with a large number of tablespace files. At startup, InnoDB scans directories defined by the innodb_directories variable for tablespace files. The paths of discovered tablespace files are ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-disk-io.html
Making a few large read requests for contiguous data can be more efficient than making several small, spread-out requests. InnoDB uses asynchronous disk I/O where possible, by creating a number of threads to handle I/O operations, while permitting ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-file-defragmenting.html
Another symptom of fragmentation is that a table scan such as this takes more time than it “should” take: SELECT COUNT(*) FROM t WHERE non_indexed_column <> 12345; The preceding query requires MySQL to perform a full table scan, the slowest type ... Random insertions into or deletions from a secondary index can cause the index to become ...
https://dev.mysql.com/doc/refman/8.4/en/ldml-rules.html
MySQL recognizes a large enough subset of the syntax that, in many cases, it is possible to download a collation definition from the Unicode Common Locale Data Repository and paste the relevant part (that is, the part between the <rules> and ...This ...
https://dev.mysql.com/doc/refman/8.4/en/making-trace-files.html
In a console window, use this command: C:\> mysqld-debug --debug --standalone After this, you can use the mysql.exe command-line tool in a second console window to reproduce the problem. The trace file can become very large! To generate a smaller ...