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/mysql-command-options.html
This may slow down the server if the output is suspended. mysql supports the following options, which can be specified on the command line or in the [mysql] and [client] groups of an option file. For information about option files used by MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html
REORGANIZE PARTITION: ALTER TABLE table_name REORGANIZE PARTITION partition_name INTO (partition_definition TABLESPACE=innodb_file_per_table); There must be no queries and stored program definitions from MySQL 8.0.12 or lower that use ASC or DESC ...
https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
Boolean queries against a MyISAM search index can work even without a FULLTEXT index, although a search executed in this fashion would be quite slow. InnoDB tables require a FULLTEXT index on all columns of the MATCH() expression to perform boolean ... MySQL can perform boolean full-text searches using the IN BOOLEAN MODE ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-indexes.html
Queries appear in the slow query log that did not appear there previously. If an index made invisible actually is needed or used by the optimizer, there are several ways to notice the effect of its absence on queries for the table: Errors occur for ... MySQL supports invisible indexes; that is, indexes that are not used by the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-persistent-stats.html
Increasing innodb_stats_persistent_sample_pages too much, however, could cause ANALYZE TABLE to run slowly. The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
Despite the in-memory processing for MEMORY tables, they are not necessarily faster than InnoDB tables on a busy server, for general-purpose queries, or under a read/write workload. In particular, the table locking involved with performing updates ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/8.0/en/password-logging.html
PASSWORD ...) Passwords in those statements are rewritten to not appear literally in statement text written to the general query log, slow query log, and binary log. Passwords can be written as plain text in SQL statements such as CREATE USER, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-undo-tablespaces.html
Manual removal of undo tablespace files is possible after a slow shutdown but is not recommended, as deactivated undo tablespaces may contain active undo logs for some time after the server is restarted if open transactions were present when ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-mysql-cluster.html
However, it also means that queries that could otherwise use range scans must be satisfied by other means, which can result in slower selects. How do I continue to send queries in the event that one of the SQL nodes fails? A.10.40. Transactions are ... In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and the NDB storage ...
https://dev.mysql.com/doc/refman/8.0/en/data-size.html
If it is a rare case that is limited by CPU speed, it might be slower. Indexes are good for retrieval, but slow down insert and update operations. Keep column names simple, so that you can use the same name across different tables and simplify join ... Design your tables to minimize their space on the ...