Search Results
https://dev.mysql.com/doc/heatwave/en/mys-hw-rpd-exec-stats-table.html
For MySQL HeatWave AutoML routines that include multiple sub-queries, such as ML_TRAIN, a new record is used for each query. The rpd_exec_stats table stores query execution statistics produced by MySQL HeatWave nodes in JSON format. One row of ...
https://dev.mysql.com/doc/heatwave/en/mys-hwaml-ml-model-import.html
Use the ML_MODEL_IMPORT routine to import a pre-trained model into your model catalog. To learn how to use ML_MODEL_IMPORT to share models, see Share a Model. ML_MODEL_IMPORT Overview ML_MODEL_IMPORT Syntax ML_MODEL_IMPORT Parameters Syntax ...
https://dev.mysql.com/doc/refman/8.4/en/aggregate-functions.html
This section describes aggregate functions that operate on sets of values. They are often used with a GROUP BY clause to group values into subsets. If you use an aggregate function in a statement containing no GROUP BY clause, it is equivalent to ...
https://dev.mysql.com/doc/refman/8.4/en/crashing.html
Normally, this is one of the last queries in the log file just before the server restarts. Run the command mysqladmin -i 5 status or mysqladmin -i 5 -r status in a separate window to produce statistics while running other queries. Each MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-persistent-stats.html
The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given query.
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
Despite the in-memory processing for MEMORY tables, they are not necessarily faster than InnoDB tables on a busy server, for general-purpose queries, or under a read/write workload. User-Created and Temporary Tables MEMORY table contents are stored ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-limitations-transactions.html
This issue does not occur for queries that use index or table scans, even against NDB tables having BLOB or TEXT columns. You can help minimize issues with shared read locks by avoiding queries that use unique key lookups that retrieve BLOB or TEXT ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-options-variables.html
Two additional sources of information about pushed join performance are available: The status variables Ndb_pushed_queries_defined, Ndb_pushed_queries_dropped, Ndb_pushed_queries_executed, and Ndb_pushed_reads. Setting ndb_row_checksum to 0 means ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-indexes.html
Indexes are used to find rows with specific column values quickly. Without an index, MySQL must begin with the first row and then read through the entire table to find the relevant rows. If the table has an index for the columns in question, MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/mysqladmin.html
Questions The number of questions (queries) from clients since the server was started. Slow queries The number of queries that have taken more than long_query_time seconds. You can use it to check the server's configuration and current status, to ...