Search Results
https://dev.mysql.com/doc/refman/8.4/en/comparison-operators.html
The function is executed using the arguments as provided, performing data type conversions to one or more of the arguments if and only if they are not all of the same type. Any type coercion mandated by an expression that makes use of the return ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
in_views SET ('with_runtimes_in_95th_percentile', 'analysis', 'with_errors_or_warnings', 'with_full_table_scans', 'with_sorting', 'with_temp_tables', 'custom'): Which views to include. This procedure disables binary logging during its execution by ... Creates a report of the statements running on the ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-mutex-instances-table.html
The work performed while holding a mutex is said to be in a “critical section,” and multiple queries do execute this critical section in a serialized way (one at a time), which is a potential bottleneck. The mutex_instances table lists all the ...The mutex_instances table has these columns: NAME The instrument name associated with the ...
https://dev.mysql.com/doc/refman/8.4/en/myisamlog.html
If a recovery is done (-r), all writes and possibly updates and deletes are done and errors are only counted. This option can be given multiple times to produce more and more output. To create such a file, start the server with a --log-isam=log_file ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-fetch-field.html
mysql_fetch_field() is reset to return information about the first field each time you execute a new SELECT query. (The 8KB size is chosen because MySQL does not know the maximum length for the BLOB. This should be made configurable sometime.) Once ... MYSQL_FIELD * mysql_fetch_field(MYSQL_RES *result) Description Returns the definition of one column of a result set as a MYSQL_FIELD ...
https://dev.mysql.com/doc/ndbapi/en/ndb-ndbrecattr.html
A brief example is shown here: MyRecAttr = MyOperation->getValue("ATTR2", NULL); if(MyRecAttr == NULL) goto error; if(MyTransaction->execute(Commit) == -1) goto error; ndbout << MyRecAttr->u_32_value(); For additional examples, see Section 2.5.2, ...
https://dev.mysql.com/doc/relnotes/mysql/8.4/en/news-8-4-3.html
(Bug #36871927) JavaScript Programs Employing a user variable in a DML statement within a stored procedure that used the Statement handle interface sometimes led to an unplanned server exit when any statement was executed following execution of such ...(Bug #36702072) Microsoft Windows: On Windows, clicking the [X] close button on a MySQL Configurator wizard's page now yields a confirmation popup if the wizard is busy executing an ... C API Notes Compilation Notes Configuration Notes SQL Function and Operator Notes JavaScript Programs Performance ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-replication-applier-status-by-coordinator-table.html
LAST_ERROR_TIMESTAMP A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the most recent SQL/coordinator error occurred. replication_applier_status_by_coordinator Column SHOW REPLICA STATUS Column THREAD_ID None SERVICE_STATE ...
https://dev.mysql.com/doc/mysql-em-plugin/en/myoem-config-metric-replicationsource-category.html
Gtid Executed Compression Period Compress the mysql.gtid_executed table each time this many transactions have been processed. Semi Sync Source Timeout How long the source waits on a commit (in milliseconds) for acknowledgment from a replica before ...Enforce Gtid Consistency Enabled Allows execution of only those statements that can be logged in a transactionally safe ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-operations-per-fragment.html
The table_id column value is unique at any given time, but can be reused if the corresponding object has been deleted. Generally, such a refusal is due to duplicate keys (inserts), Key not found errors (updates, deletes, and reads), or the operation ... The operations_per_fragment table provides information about the operations performed on individual fragments and fragment replicas, as well as about some of the results from these ...