Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-information-schema-system-tables.html
You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA tables. Traditionally, you would get this type of information using the techniques from Section 17.17, “InnoDB Monitors”, setting up InnoDB monitors ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-online-ddl-performance.html
Online DDL improves several aspects of MySQL operation: Applications that access the table are more responsive because queries and DML operations on the table can proceed while the DDL operation is in progress. LOCK clauses are described below, in ...Reduced locking and waiting for MySQL server resources leads to greater scalability, even for operations that are not involved in the DDL ...
https://dev.mysql.com/doc/refman/8.4/en/mysqldump.html
Use this option if you want to increase the time allowed for queries from mysqldump before they are logged to the slow query log file. mysqldump performs a full table scan, which means its queries can often exceed a global long_query_time setting ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-examples.html
This section provides some examples that show precision math query results in MySQL. These examples demonstrate the principles described in Section 14.24.3, “Expression Handling”, and Section 14.24.4, “Rounding Behavior”. Consider the ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-6.html
(Bug #37704514) Performance: Redundant conditions in some queries optimized away in MySQL 8.0 were no longer removed in later versions, leading to a significant drop in the performance of such queries. (Bug #36330455) InnoDB: Fixed an issue relating ... Note These release notes were created with the assistance of MySQL HeatWave ...
https://dev.mysql.com/doc/mysql-router/9.4/en/router-set-trace.html
MySQL Router supports tracing of statements as they are processed by MySQL Router from client to server and the response to the client. Configuration To configure ROUTER SET trace you must add the following to your MySQL Router configuration file: ...
https://dev.mysql.com/doc/connectors/en/connector-net-programming-trace-source.html
This enables groups of queries on the same connection to be identified. The .NET tracing architecture consists of four main parts: Source - This is the originator of the trace information. Switch - This defines the level of trace information to ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-model-handles.html
The following example queries the model handle, the model owner, and the name of the training table from the model catalog table. When ML_TRAIN trains a model, you have the option to specify a name for the model, which is the model handle. If you ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-nl2ml.html
Use this routine to ask general questions about MySQL HeatWave AutoML and to generate AutoML queries you can copy and run. MySQL 9.4.0 introduces the NL2ML (natural language to machine learning) routine, which provides step-by-step guidelines on ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-31.html
MySQL HeatWave AutoML Functionality Added or Changed MySQL HeatWave AutoML MySQL HeatWave AutoML queries are now monitored and recorded in the Performance Schema tables rpd_query_stats and rpd_exec_stats. Where a single MySQL HeatWave AutoML query ...(WL #15243) New functions have been added to MySQL HeatWave AutoML to help you manage models: When you run the ML_TRAIN routine on a training dataset, you can now specify a model handle to use for the model instead of the generated ...