Search Results
https://dev.mysql.com/doc/internals/en/debug-sync-point.html
They were part of the MySQL code until the 6.0.5 and 5.1.46 versions. Debug Sync Points have been removed from the code in favor of the Debug Sync Facility. Debug Sync Points give user-level locks the ability to synchronize at arbitrary points in ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-auto-loading-data.html
After setting up an external table with the files to load into the table, you run HEATWAVE_LOAD command to automatically create the table and load the data. This topic contains the following sections: Before You Begin Load External Data Using ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-run-query.html
This topic describes how to use the EXPLAIN statement to analyze query execution and verify whether a query is offloaded to MySQL HeatWave for accelerated processing. To learn how to download the sample database, see AirportDB Analytics Quickstart.
https://dev.mysql.com/doc/refman/8.4/en/character-arrays.html
Each simple character set has a configuration file located in the sql/share/charsets directory. For a character set named MYSYS, the file is named MYSET.xml. <map> elements appear within these elements: <ctype> defines attributes for each character. <collation> elements indicate character ordering for comparison and sorting, one element per ...
https://dev.mysql.com/doc/refman/8.4/en/charset-unicode.html
The Unicode Standard includes characters from the Basic Multilingual Plane (BMP) and supplementary characters that lie outside the BMP. For information about the Unicode Standard itself, visit the Unicode Consortium website. BMP characters have ...
https://dev.mysql.com/doc/refman/8.4/en/condition-filtering.html
In join processing, prefix rows are those rows passed from one table in a join to the next. 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 ...
https://dev.mysql.com/doc/refman/8.4/en/derived-table-optimization.html
The optimizer handles derived tables, view references, and common table expressions the same way: It avoids unnecessary materialization whenever possible, which enables pushing down conditions from the outer query to derived tables and produces more ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-distributed-recovery-connections.html
When a joining member connects to an online existing member for state transfer during distributed recovery, the joining member acts as a client on the connection and the existing member acts as a server. When state transfer from the donor's binary ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
A number of limitations exist in NDB Cluster with regard to the handling of transactions. The NDBCLUSTER storage engine supports only the READ COMMITTED transaction isolation level. To ensure that a given transaction reads only before or after ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-innodb-bulk-data-loading.html
These performance tips supplement the general guidelines for fast inserts in Section 10.2.5.1, “Optimizing INSERT Statements”. When importing data into InnoDB, turn off autocommit mode, because it performs a log flush to disk for every insert.