Search Results
https://dev.mysql.com/doc/relnotes/connector-net/en/news-8-0-10.html
New methods were added to the MySqlX.XDevAPI.BaseSession class to implement corresponding SQL statements using the X Protocol: SetSavepoint() and SetSavepoint(name) correspond to the SAVEPOINT statement. (WL #11135) Document Store: The ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-cloudwatch-metrics.html
It can be one of: mysql: DB System heatWave: MySQL HeatWave Cluster heatWaveNode: Specifies the MySQL HeatWave nodeindex the metric originated from. dbSystemId Basic Detailed heatwave.query_offload_count Count The number of statements executed ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-metadata-locks-table.html
The STATEMENT and TRANSACTION values signify locks that are released implicitly at statement or transaction end, respectively. The EXPLICIT value signifies locks that survive statement or transaction end and are released by explicit action, such as ... MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 10.11.4, “Metadata ...
https://dev.mysql.com/doc/refman/8.4/en/table-cache.html
(By contrast, the index file descriptor is shared between all sessions.) The table_open_cache and max_connections system variables affect the maximum number of files the server keeps open. This happens when someone issues a FLUSH TABLES statement or ... When you execute a mysqladmin status command, you should see something like this: Uptime: 426 Running threads: 1 Questions: 11082 Reloads: 1 Open tables: 12 The Open tables value of 12 can be somewhat puzzling if you have fewer than 12 ...
https://dev.mysql.com/doc/refman/8.4/en/spatial-type-overview.html
However, the optimizer cannot use SPATIAL indexes on them until the column definition is modified to include an SRID attribute, which may require that the column contents first be modified so that all values have the same SRID. MySQL has spatial ...
https://dev.mysql.com/doc/workbench/en/wb-sql-editor-toolbar.html
Execute the statement under the keyboard cursor: Uses the position the keyboard cursor to identify and execute the query. Execute the EXPLAIN command on the statement under the keyboard cursor: Uses the position the keyboard cursor to identify the ... The SQL query toolbar provides actions that enable you to create and manage ...
https://dev.mysql.com/doc/connectors/en/connector-odbc-errors.html
Batched Statements When I try to use batched statements, the execution of the batched statements fails. Enable option FLAG_MULTI_STATEMENTS, value 67108864, or select the Allow multiple statements flag within a GUI configuration. The following ...
https://dev.mysql.com/doc/connector-odbc/en/connector-odbc-errors.html
Batched Statements When I try to use batched statements, the execution of the batched statements fails. Enable option FLAG_MULTI_STATEMENTS, value 67108864, or select the Allow multiple statements flag within a GUI configuration. The following ...
https://dev.mysql.com/doc/internals/en/transactions-roles-responsibilities.html
The server has only one way to know that an engine participates in the statement and a transaction has been started in an engine: the engine says so. If autocommit is not set, the engine must register itself twice -- both in the statement list and ...So, in order to be a part of a transaction, an engine must "register" ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-threadpool-category.html
High Priority Connection This variable affects queuing of new statements prior to execution. If the value is 0 (false, the default), statement queuing uses both the low-priority and high-priority queues. If the value is 1 (true), queued statements ... Lists the Thread Pool configuration metrics and provides a brief description of ...