Search Results
https://dev.mysql.com/doc/ndbapi/en/mccj-overview-clusterj-object-models.html
It contains methods for the following operations: Finding persistent instances by primary key Creating, updating, and deleting persistent instances Getting a query builder (see com.mysql.clusterj.query.QueryBuilder) Getting the current transaction ... This section discusses the ClusterJ API and the object model used to represent the data handled by the ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-performance-pages.html
The Performance dashboards are available from the Performance sub-menu of the MySQL Database menu. A tooltip is displayed listing the data type, the time the data was collected, and the value of the metric collected. Graph regions also contain links ...
https://dev.mysql.com/doc/x-devapi-userguide/en/fetching-all-data-items-at-once.html
The life time of the list is independent from the life of the data set that has produced it. In addition to the pattern of using fetchOne() explained at Section 9.3, “Working with Data Sets”, which enables applications to consume data items one ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-apptask-logs.html
This topic contains the following sections: Syntax Syntax Example See Also Syntax mysql> SELECT mysql_tasks.app_task_logs( IN 'app_user_id' VARCHAR(255), IN 'task_id' VARCHAR(36), IN 'newer_than_log_time' TIMESTAMP(6)); Following are app_task_logs ...newer_than_log_time TIMESTAMP(6): all the log entries created after the specified timestamp are ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-async-exec-prepared-stmt.html
Syntax Example mysql> CALL mysql_tasks.execute_prepared_stmt_async('DO SLEEP(5); SELECT JSON_OBJECT("Async Task completed at", now()) into @task_result', NULL, 'DemoAsyncTask', NULL, @task_id); In this example, the first SQL statement DO SLEEP(5) ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-auto-query-plan-improvement.html
The Auto Query Plan Improvement feature collects and stores query plan statistics in a statistics cache when a query is executed in MySQL HeatWave. When a new query shares query execution plan nodes with previously executed queries, the statistics ...Each entry in the cache corresponds to a query execution plan ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-backups.html
Backups 18 Backups This section describes how to create, restore, and manage MySQL DB System backups. MySQL HeatWave on AWS limits the maximum number of backups that you can retain across all DB System instances. Backups are incremental, but if the ...DB System backups are Amazon EBS snapshots which are automatically saved to Amazon Simple Storage Service (Amazon ...
https://dev.mysql.com/doc/connector-j/en/connector-j-usagenotes-spring-config-connpooling.html
Although MySQL does not spawn an extra process when a connection is made, there is still a small amount of overhead to create and set up the connection. Pooling of connections also alleviates problems such as collecting large amounts of sockets in ... In many situations, such as web applications, there will be a large number of small database ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-legacy-filtering.html
Legacy Event Filtering by Account Legacy Event Filtering by Status Legacy Event Filtering by Account To filter audited events based on the originating account, set one (not both) of the following system variables at server startup or runtime. Note ...
https://dev.mysql.com/doc/refman/8.4/en/charset-database.html
The CHARACTER SET and COLLATE clauses make it possible to create databases with different character sets and collations on the same MySQL server. Example: CREATE DATABASE db_name CHARACTER SET latin1 COLLATE latin1_swedish_ci; MySQL chooses the ...