Search Results
https://dev.mysql.com/doc/refman/8.4/en/sorting-rows.html
You may have noticed in the preceding examples that the result rows are displayed in no particular order. It is often easier to examine query output when the rows are sorted in some meaningful way. This means that the order is undefined for columns ...
https://dev.mysql.com/doc/internals/en/row-based-replication.html
...
https://dev.mysql.com/doc/refman/8.4/en/example-maximum-column-group-row.html
Task: For each article, find the dealer or dealers with the most expensive price. Other possibilities for solving the problem are to use an uncorrelated subquery in the FROM clause, a LEFT JOIN, or a common table expression with a window function.
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache-reduce.html
The minimum setting for the XCom message cache size in MySQL 8.4 is 128 MB, which enables deployment on a host that has a restricted amount of available memory. Having a very low group_replication_message_cache_size setting is not recommended if ...
https://dev.mysql.com/doc/internals/en/join-buffer-size.html
If join_buffer_size is already large enough to hold all previous row combinations, there is no speed to be gained by making it larger. Basic information about the join buffer cache: The size of each join buffer is determined by the value of the ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-performance-xcom-cache-increase.html
However, if the transactions that happened during the member's absence have been deleted from the other members' XCom message caches because their maximum size limit was reached, the member cannot reconnect in this way. Although the group members ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-init-startup-configuration.html
The sum of file sizes must be, at a minimum, slightly larger than 12MB. The following configuration permits ibdata1 to grow to a limit of 500MB: [mysqld] innodb_data_file_path=ibdata1:12M:autoextend:max:500M A minimum file size is enforced for the ... The first decisions to make about InnoDB configuration involve the configuration of data files, log files, page size, and memory buffers, which should be configured before initializing ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-component-functions.html
Example: mysql> SELECT mask_canada_sin('046-454-286'), mask_canada_sin('abcdefijk'); +--------------------------------+------------------------------+ | mask_canada_sin('046-454-286') | mask_canada_sin('abcdefijk') | ...mask_canada_sin(str [, ...
https://dev.mysql.com/doc/internals/en/event-data-for-specific-event-types.html
Log files created subsequently (when someone issues a FLUSH LOGS statement or the current binary log file becomes too large) do not contain this event. SELECT fails after inserting 1000 rows into a MyISAM table (for example, with a duplicate-key ...
https://dev.mysql.com/doc/refman/8.4/en/server-options.html
--super-large-pages Command-Line Format --super-large-pages[={OFF|ON}] Platform Specific Solaris Type Boolean Default Value OFF Standard use of large pages in MySQL attempts to use the largest size supported, up to 4MB. This means that when you ...