Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode.html
The MySQL implementation of UCS-2, UTF-16, and UTF-32 stores characters in big-endian byte order and does not use a byte order mark (BOM) at the beginning of values. Other database systems might use little-endian byte order or a BOM. The Unicode ...
https://dev.mysql.com/doc/refman/8.4/en/column-indexes.html
FULLTEXT queries that sort the matching rows in descending order of score and apply a LIMIT clause to take the top N matching rows. For this optimization to apply, there must be no WHERE clauses and only a single ORDER BY clause in descending order.
https://dev.mysql.com/doc/refman/8.4/en/condition-filtering.html
In general, the optimizer attempts to put tables with low prefix counts early in the join order to keep the number of row combinations from increasing rapidly. Ways to accomplish this include join-order optimizer hints (see Section 10.9.3, ... In ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
When two transactions start modifying multiple tables, accessing the tables in a different order, they can reach a state where each transaction is waiting for the other and neither can proceed. If deadlock warnings occur constantly, you might review ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.4/en/create-user.html
Order of REQUIRE options does not matter, but no option can be specified twice. CREATE USER 'jeffrey'@'localhost' REQUIRE SUBJECT '/C=SE/ST=Stockholm/L=Stockholm/ O=MySQL demo client certificate/ CN=client/emailAddress=client@example.com'; MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/data-dictionary-usage-differences.html
Consequently, depending on optimizer choices, the row order of results for INFORMATION_SCHEMA queries might differ from previous results. If a query result must have specific row ordering characteristics, include an ORDER BY clause. Use of a data ...
https://dev.mysql.com/doc/refman/8.4/en/derived-table-optimization.html
The optimizer propagates an ORDER BY clause in a derived table or view reference to the outer query block if these conditions are all true: The outer query is not grouped or aggregated. The outer query does not specify DISTINCT, HAVING, or ORDER BY.
https://dev.mysql.com/doc/refman/8.4/en/encrypted-connection-protocols-ciphers.html
Negotiation order is independent of the order in which protocols are configured. For example, negotiation order is the same regardless of whether tls_version has a value of TLSv1.2,TLSv1.3 or TLSv1.3,TLSv1.2. MySQL supports multiple TLS protocols ...
https://dev.mysql.com/doc/refman/8.4/en/fulltext-search.html
MySQL does not permit the use of a rollup column with MATCH(); more specifically, any query matching all of the criteria listed here is rejected with ER_FULLTEXT_WITH_ROLLUP: MATCH() appears in the SELECT list, GROUP BY clause, HAVING clause, or ...
https://dev.mysql.com/doc/refman/8.4/en/general-thread-states.html
Copying to group table If a statement has different ORDER BY and GROUP BY criteria, the rows are sorted by group and copied to a temporary table. Sorting for order The thread is doing a sort to satisfy an ORDER BY. The following list describes ...