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/optimize-overview.html
Are all memory areas used for caching sized correctly? That is, large enough to hold frequently accessed data, but not so large that they overload physical memory and cause paging. Does each table use an appropriate row format? This choice also ...
https://dev.mysql.com/doc/refman/8.0/en/alter-instance.html
If the CRL file is large, the server allocates a large chunk of memory (ten times the file size), which is doubled while the new instance is being loaded and the old one has not yet been released. The process resident memory is not immediately ...
https://dev.mysql.com/doc/refman/8.0/en/merge-table-advantages.html
You can split a large read-only table based on some criteria, and then put individual tables on different disks. A MERGE table structured this way could be much faster than using a single large table. It is easier to repair individual smaller tables ... MERGE tables can help you solve the following problems: Easily manage a set of log ...
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/temporary-files.html
The maximum disk space required is determined by the following expression: (length of what is sorted + sizeof(row pointer)) * number of matched rows * 2 The row pointer size is usually four bytes, but may grow in the future for really big tables. If ... On Unix, MySQL uses the value of the TMPDIR environment variable as the path name of the directory in which to store temporary ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-file-per-table-tablespaces.html
By comparison, each file-per-table tablespace has a 64TB size limit, which provides plenty of room for individual tables to grow in size. In other words, a shared tablespace data file does not shrink in size after a table is truncated or dropped. A ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-expel.html
Non-members that were never active in the group do not get this waiting period and are removed after the initial detection period because they took too long to join. It is important to ensure that XCom's message cache is sufficiently large to ...
https://dev.mysql.com/doc/refman/8.0/en/pluggable-authentication-system-variables.html
authentication_ldap_sasl_init_pool_size Command-Line Format --authentication-ldap-sasl-init-pool-size=# System Variable authentication_ldap_sasl_init_pool_size Scope Global Dynamic Yes SET_VAR Hint Applies No Type Integer Default Value 10 Minimum ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-statistics-estimation.html
Enabling innodb_stats_on_metadata may reduce access speed for schemas that have a large number of tables or indexes, and reduce stability of execution plans for queries that involve InnoDB tables. This technique is especially important for large ...
https://dev.mysql.com/doc/refman/8.0/en/switchable-optimizations.html
row *************************** id: 1 select_type: PRIMARY table: t1 partitions: NULL type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4 filtered: 33.33 Extra: Using where *************************** 2. row ...Its value is a set ...