PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/fulltext-boolean.html
Whether a word is too short is determined from the innodb_ft_min_token_size setting for InnoDB tables, or ft_min_word_len for MyISAM tables. If the minimum word length is 4, a search for '+word +the*' could return fewer rows than a search for '+word ...| +----+-----------------------+-------------------------------------+ Note In implementing this feature, MySQL uses what is sometimes referred to as implied Boolean logic, in which + stands for AND - stands for NOT [no operator] implies OR Boolean full-text searches have these characteristics: They do not automatically sort rows in order of decreasing ...
https://dev.mysql.com/doc/refman/8.0/en/memory-storage-engine.html
However, the two types of tables differ in that MEMORY tables are not subject to storage conversion, whereas internal temporary tables are: If an internal temporary table becomes too large, the server automatically converts it to on-disk storage, as ...NDB Cluster offers the same features as the MEMORY engine with higher performance levels, and provides additional features not available with MEMORY: Row-level locking and multiple-thread operation for low contention between ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-background.html
An InnoDB table created with ROW_FORMAT=COMPRESSED can use a smaller page size on disk than the configured innodb_page_size value. But if you specify a value that is too small, there is additional overhead to reorganize the pages when data values ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-tuning.html
You should bear in mind that the overhead of the connection polling operation for each thread group increases when using smaller values for the thread pool size with larger values for thread_pool_query_threads_per_group. Of chief importance is the ... This section provides guidelines on determining the best configuration for thread pool performance, as measured using a metric such as transactions per ...
https://dev.mysql.com/doc/refman/8.0/en/alter-user.html
ALTER USER permits these auth_option syntaxes: IDENTIFIED BY 'auth_string' [REPLACE 'current_auth_string'] [RETAIN CURRENT PASSWORD] Sets the account authentication plugin to the default plugin, passes the cleartext 'auth_string' value to the plugin ... ALTER USER [IF EXISTS] user [auth_option] [, user [auth_option]] ...
https://dev.mysql.com/doc/refman/8.0/en/disk-issues.html
This problem becomes more apparent when the amount of data starts to grow so large that effective caching becomes impossible. For large databases where you access data more or less randomly, you can be sure that you need at least one disk seek to ...
https://dev.mysql.com/doc/refman/8.0/en/table-cache.html
For example, for 200 concurrent running connections, specify a table cache size of at least 200 * N, where N is the maximum number of tables per join in any of the queries which you execute. If table_open_cache is set too high, MySQL may run out of ... When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 ...
https://dev.mysql.com/doc/refman/8.0/en/bug-reports.html
If you cannot produce a test case with only a few rows, or if the test table is too big to be included in the bug report (more than 10 rows), you should dump your tables using mysqldump and create a README file that describes your problem. This ...
https://dev.mysql.com/doc/refman/8.0/en/lateral-derived-tables.html
First approach to solving the problem: For each salesperson, calculate the maximum sale size, and also find the customer who provided this maximum. A derived table cannot normally refer to (depend on) columns of preceding tables in the same FROM ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-performance-message-fragmentation.html
The setting for group_replication_communication_max_message_size must be less than replica_max_allowed_packet (or slave_max_allowed_packet), because the applier thread cannot handle message fragments larger than the maximum permitted packet size.