Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-statement-digests.html
The copy of the normalized statement digest is stored in the appropriate Performance Schema tables, along with the SHA-256 hash value computed from the original normalized statement. Statement Digests in the Performance Schema In the Performance ...
https://dev.mysql.com/doc/mysql-ai/9.5/en/mys-mysqlai-ml-model-import.html
Models in ONNX format (.onnx) cannot be loaded directly into a MySQL table. Before running ML_MODEL_IMPORT, follow the instructions in Import an External ONNX Model to pre-process and then load the model into a temporary table to use with AutoML.
https://dev.mysql.com/doc/refman/8.4/en/derived-condition-pushdown-optimization.html
When a derived table cannot be merged into the outer query (for example, if the derived table uses aggregation), pushing the outer WHERE condition down to the derived table should decrease the number of rows that need to be processed and thus speed ...This includes WHERE conditions having multiple predicates joined with AND, OR, or ...
https://dev.mysql.com/doc/refman/8.4/en/bnl-bka-optimization.html
In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join buffer. Benefits of BKA include improved join performance due to more efficient table scanning. Moreover, a join buffer can ...The BKA algorithm supports inner join, outer join, and semijoin operations, including nested outer ...
https://dev.mysql.com/doc/refman/8.4/en/trigger-syntax.html
Here is a simple example that associates a trigger with a table, to activate for INSERT operations. The trigger acts as an accumulator, summing the values inserted into one of the columns of the table. In this case, the trigger activates before each ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 15.1.22, “CREATE TRIGGER Statement”, and Section 15.1.34, “DROP TRIGGER ...
https://dev.mysql.com/doc/mysql-enterprise-backup/8.4/en/bugs.backup.html
Here is a list of limitations of MySQL Enterprise Backup: In some cases, backups of non-transactional tables such as MyISAM tables could contain additional uncommitted data. If autocommit is turned off, and both InnoDB tables and non-transactional ... Please refer to the MySQL Enterprise Backup 8.4 Release Notes for a list of fixed bugs for ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-troubleshooting.html
mysql> SHOW STATUS LIKE 'Last_query_cost'; Solution C: The table you are querying is not loaded. You can check the load status of a table in MySQL HeatWave by querying LOAD_STATUS data from MySQL HeatWave Performance Schema tables. Alternatively, ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-performance-schema.html
For example, you should know how enable instruments and consumers, and how to query performance_schema tables to retrieve data. To view InnoDB-related instruments, you can query the setup_instruments table for instrument names that contain 'innodb'.
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-examples.html
If you use a combination of database-level and table-level replication filtering options, the replica first accepts or ignores events using the database options, then it evaluates all events permitted by those options according to the table options. With row-based format, DML statements are handled based on the database where the modified table ...It is also important to note that the results vary ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-lakehouse-overview.html
While Lakehouse provides in-memory query processing on data in Object Storage, it does not load data into a DB System table. External Tables When MySQL HeatWave loads data and creates a table from a file in Object Storage, it is an external ... The ...