Search Results
https://dev.mysql.com/doc/c-api/8.4/en/mysql-options.html
MYSQL_OPT_CONNECT_TIMEOUT (argument type: unsigned int *) The connect timeout in seconds. MYSQL_OPT_READ_TIMEOUT (argument type: unsigned int *) The timeout in seconds for each attempt to read from the server. MYSQL_OPT_WRITE_TIMEOUT (argument type: ...This function may be called multiple times to set several ... int mysql_options(MYSQL *mysql, enum mysql_option option, const void *arg) Description Can be used ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-file-formats.html
Example: "query": "DELETE FROM t1" query_time The query execution time in microseconds (if the longlong data type is selected) or seconds (if the double data type is selected). For example, the event corresponding to execution of an SQL statement ...
https://dev.mysql.com/doc/workbench/en/wb-basic-add-table.html
Pressing Tab yet again and the focus shifts to adding a second column. The tools in the vertical toolbar on the left of the EER Diagram tab are used for designing an EER diagram. The table tool is the rectangular grid in the middle of the vertical ...
https://dev.mysql.com/doc/internals/en/synchronization-pattern.html
It is possible that the condition variable is signaled multiple times without the wait condition to be true. If the killing thread would kill us when we are after the second test, but still before sleeping, we hold the mutex, which is registered in ...This is done to allow the thread to be interrupted (killed) from its ...
https://dev.mysql.com/doc/internals/en/innodb-field-start-offsets.html
The first column's length is 1, the second column's length is 2, and the third column's length is 4. The Field Start Offsets is a list in which each entry is the position, relative to the Origin, of the start of the next field. The entries are in ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-relnotes.html
It assures that when the primary instance fails, one of the secondary instances is promoted automatically to become the primary instance, with zero data loss and minimal downtime. It assures that when the primary instance fails, its function is ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-metric-sysschema-statementanalysis-total-latency-category.html
Max Time of Execution The maximum time the statement took to execute. Avg Time of Execution The average time the statement takes to execute. Exec Count The total number of times the statement has executed. Max Latency The maximum single wait time of ...Table 6.40 Sys Schema Statement Analysis by Total Latency Metrics NameDescriptionAvg Latency The average wait time per timed occurrence of the ...
https://dev.mysql.com/doc/internals/en/transactions-historical-note.html
Second, observe that BerkeleyDB provided the concept of "nested transactions" instead of SQL standard savepoints. "Statement transaction" is a non-standard term that comes from the days when MySQL supported the BerkeleyDB storage engine. First, ...
https://dev.mysql.com/doc/refman/8.4/en/federated-usagenotes.html
This capability has the following limitations: The size of the insert cannot exceed the maximum packet size between servers. ON DUPLICATE KEY UPDATE statements, but if a duplicate-key violation occurs, the statement fails with an error. Also, if the ...The following items indicate features that the FEDERATED storage engine does and does not support: The remote server must be a MySQL ...
https://dev.mysql.com/doc/ndbapi/en/ndb-examples-simple-dual.html
This example demonstrates synchronous transactions and connecting to multiple clusters in a single NDB API application. The source code for this program may be found in the NDB Cluster source tree, in the file ...