Search Results
https://dev.mysql.com/doc/refman/8.4/en/xa.html
In essence, this extends ACID properties “up a level” so that multiple ACID transactions can be executed in concert as components of a global operation that also has ACID properties. The process for executing a global transaction uses two-phase ... Support for XA transactions is available for the InnoDB storage ...
https://dev.mysql.com/doc/refman/8.4/en/revoke.html
Otherwise, REVOKE executes normally; if the user does not exist, the statement raises an error. Otherwise, the statement executes as usual, and attempting to revoke a privilege not assigned to the target for whatever reason raises an error, as ...
https://dev.mysql.com/doc/c-api/8.4/en/c-api-prepared-statement-interface-usage.html
To prepare and execute a statement, an application follows these steps: Create a prepared statement handler with mysql_stmt_init(). You can repeat the mysql_stmt_execute() to re-execute the statement by changing parameter values in the respective ...To prepare the statement on the server, call mysql_stmt_prepare() and pass it a string containing the SQL ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-clone-progress-table.html
The clone_progress table shows progress information for the current or last executed cloning operation only. BEGIN_TIME A timestamp in 'YYYY-MM-DD hh:mm:ss[.fraction]' format that shows when the cloning stage started. END_TIME A timestamp in ...The ...
https://dev.mysql.com/doc/mysql-cluster-manager/8.4/en/mcm-restart-cluster.html
Note Depending on the number of nodes and the amount of data stored in the cluster, a rolling restart can take a considerable amount of time, up to several hours for a cluster with a great many data nodes and a large amount of data. This means that ... restart cluster [--sequential-restart] cluster_name This command performs a rolling restart (see Performing a Rolling Restart of an NDB Cluster) of the cluster named ...
https://dev.mysql.com/doc/ndbapi/en/mgm-functions-log-events.html
> 0: The event exists, and it data was retrieved into the logevent 0: A timeout occurred while waiting for the event (more than timeout milliseconds elapsed) < 0: An error occurred. > 0: The event exists, and it data was retrieved into the logevent ...ndb_mgm_listen_event() ndb_mgm_create_logevent_handle() ndb_mgm_destroy_logevent_handle() ndb_logevent_get_fd() ndb_logevent_get_next() ndb_logevent_get_next2() ndb_logevent_get_latest_error() ndb_logevent_get_latest_error_msg() ndb_mgm_listen_event() Description This function is used to listen to log events, which are read from the return file ...
https://dev.mysql.com/doc/refman/8.4/en/precision-math-examples.html
Consider the following stored procedure, which adds .0001 to a variable 1,000 times. The floating-point calculation introduces small errors: +--------+------------------+ | d | f | +--------+------------------+ | 1.0000 | 0.99999999999991 | ... This ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/services-for-plugins.html
The interface includes a versioning mechanism so that service versions supported by the server can be checked at load time against plugin versions. my_plugin_log_service: A service that enables plugins to report errors and specify error messages. To ... MySQL server plugins have access to server “plugin services.” The plugin services interface exposes server functionality that plugins can ...
https://dev.mysql.com/doc/workbench/en/wb-mysql-connections-navigator-instance-server-logs.html
For each connection, the Administration - Server Logs tab includes additional tabs for the general error logs and the slow logs (if available). Error Log File The following figure shows an example of entries within the Error Log File tab. Figure 6.2 ... The Administration - Server Logs tab displays log information for the MySQL server represented by each connection ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-table-import.html
If the table has a foreign key relationship, foreign_key_checks must be disabled before executing DISCARD TABLESPACE. Also, you should export all foreign key related tables at the same logical point in time, as ALTER TABLE ... A schema mismatch ...