Search Results
https://dev.mysql.com/doc/refman/8.4/en/table-size-limit.html
ALTER TABLE tbl_name MAX_ROWS=1000000000 AVG_ROW_LENGTH=nnn; You have to specify AVG_ROW_LENGTH only for tables with BLOB or TEXT columns; in this case, MySQL cannot optimize the space required based only on the number of rows. The effective ...
https://dev.mysql.com/doc/refman/8.4/en/thread-pool-tuning.html
Optimal performance is often seen with values from 4 to 8. This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per second. Of chief importance is the ...
https://dev.mysql.com/doc/refman/8.4/en/tracing-memory-usage.html
Each stored trace is a string, which is extended (using realloc()) as optimization progresses by appending more data to it. The optimizer_trace_max_mem_size server system variable sets a limit on the total amount of memory used by all traces ...If ...
https://dev.mysql.com/doc/refman/8.4/en/type-conversion.html
Also, results can be affected by factors such as computer architecture or the compiler version or optimization level. When an operator is used with operands of different types, type conversion occurs to make the operands compatible. For example, ...
https://dev.mysql.com/doc/refman/8.4/en/using-spatial-indexes.html
The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...
https://dev.mysql.com/doc/refman/8.4/en/verifying-index-usage.html
Use the EXPLAIN statement, as described in Section 10.8.1, “Optimizing Queries with EXPLAIN”. Always check whether all your queries really use the indexes that you have created in the tables.
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
View processing is not optimized: It is not possible to create an index on a view. The maximum number of tables that can be referenced in the definition of a view is 61. Indexes can be used for views processed using the merge algorithm. However, a ...
https://dev.mysql.com/doc/refman/8.4/en/what-is-mysql.html
The database structures are organized into physical files optimized for speed. MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. The MySQL website ...
https://dev.mysql.com/doc/refman/8.4/en/windows-select-server.html
Binary Description mysqld Optimized binary with named-pipe support mysqld-debug Like mysqld, but compiled with full debugging and automatic memory allocation checking Each of the servers in a distribution support the same set of storage engines.
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/index.html
Abstract This is the user manual for MySQL Enterprise Backup, a commercially licensed backup utility for MySQL databases. It explains the different kinds of backup and restore that can be performed with MySQL Enterprise Backup, and describes the ...