Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-introduction-server.html
Others use timed durations, such as the average statement execution time. Analyzing the SQL queries performed on the monitored instance, in real-time, using the Query Analyzer. Some use percentages, such as percentage of maximum number of ... MySQL ...
https://dev.mysql.com/doc/internals/en/logging-transactions-rules-for-create-table-select.html
(R-log-create-select-statement-format) If logging in statement format (that is, one of the following holds: (1) @@SESSION.binlog_format=STATEMENT; (2) @@SESSION.binlog_format=MIXED and statement is safe): If there is an error, do not write anything.
https://dev.mysql.com/doc/refman/8.4/en/replica-logs-status.html
Execution of any statement requiring a write lock on either or both of the slave_master_info and slave_relay_log_info tables is disallowed while replication is ongoing (although statements that perform only reads are permitted at any time). The ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-data-structures.html
MYSQL_FIELD structures are also used to provide metadata for OUT and INOUT parameters returned from stored procedures executed using prepared CALL statements. Tip To view the MYSQL_FIELD member values for result sets interactively, start the mysql ... This section describes C API data structures other than those used for prepared statements, the asynchronous interface, or the replication stream ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-stmt-attr-set.html
This function may be called multiple times to set several options. STMT_ATTR_CURSOR_TYPE unsigned long * Type of cursor to open for statement when mysql_stmt_execute() is invoked. STMT_ATTR_PREFETCH_ROWS unsigned long * Number of rows to fetch from ... bool mysql_stmt_attr_set(MYSQL_STMT *stmt, enum enum_stmt_attr_type option, const void *arg) Description Can be used to affect behavior for a prepared ...
https://dev.mysql.com/doc/connector-j/en/connector-j-connp-props-statements.html
This results in better performance when dealing with time zone conversions in Date and Time data types, however it won't be aware of time zone changes if they happen at runtime. Default Value true Since Version 8.0.20 continueBatchOnError Should the ...Default Value true Since Version 3.0.3 dontTrackOpenResources The JDBC specification requires the driver to automatically track and close resources, however if your application doesn't do a good job of explicitly calling 'close()' on statements or result sets this can cause memory ...
https://dev.mysql.com/doc/refman/8.4/en/optimizing-queries-myisam.html
The first time you sort a large table this way, it may take a long time. MyISAM supports concurrent inserts: If a table has no free blocks in the middle of the data file, you can INSERT new rows into it at the same time that other threads are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-about-heatwave.html
It uses advanced machine learning techniques to sample data, collect statistics on data and queries, and build machine learning models to model memory usage, network load and execution time. MySQL HeatWave Autopilot uses these ML models to ...MySQL ... MySQL HeatWave is a fully-managed cloud service that enables organizations to efficiently run analytics, transactional processing, machine learning, generative AI, and vector processing using a single service without the need for extract, transfer, and load ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-hw-workload-perf-data.html
Recent Queries Displays recently executed queries with the Query Text, the query Start Time, and the Duration (ms) of the query. You are provided with options to Search by Query Text for specific queries and to Aggregate Executions to view ... MySQL ...
https://dev.mysql.com/doc/relnotes/heatwave/en/news-8-0-31.html
The new column model_metadata in the MODEL_CATALOG table records metadata for models, such as the training score, training time, and information about the training dataset. If an error occurs during training or you cancel the training operation, ...