Search Results
https://dev.mysql.com/doc/refman/8.4/en/alter-event.html
Although an ALTER EVENT statement that contains another ALTER EVENT statement in its DO clause appears to succeed, when the server attempts to execute the resulting scheduled event, the execution fails with an error. When a user executes a ...The ...
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/refman/8.4/en/docker-mysql-getting-started.html
For example: $> docker ps CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES 4cd4129b3211 container-registry.oracle.com/mysql/community-server:latest "/entrypoint.sh mysq…" 8 seconds ago Up 7 seconds (health: starting) 3306/tcp, 33060-33061/tcp ...Because the MYSQL_ONETIME_PASSWORD option is true by default, after you have connected a mysql client to the server, you must reset the server root password by issuing this statement: mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password'; Substitute password with the password of your ...
https://dev.mysql.com/doc/refman/8.4/en/installing-source-distribution.html
If you have multiple source trees at the same level (for example, to build multiple versions of MySQL), the second strategy can be advantageous. With the second strategy, you can use the same name for the build directory within each source tree. To ...
https://dev.mysql.com/doc/refman/8.4/en/proxy-users.html
This enables the external user to be a proxy for the second user; that is, to assume the privileges of the second user: The external user is a “proxy user” (a user who can impersonate or become known as another user). The second user is a ...The ...
https://dev.mysql.com/doc/connector-j/en/connector-j-support-bug-report.html
Sometimes the error is platform-dependent; in such cases, it is next to impossible for us to fix anything without knowing the operating system and the version number of the platform. Writing a good bug report takes patience, but doing it right the ... The normal place to report bugs is http://bugs.mysql.com/, which is the address for our bugs ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-replication.html
During the cloning operation, both the binary log position (filename, offset) and the gtid_executed GTID set are extracted and transferred from the donor MySQL server instance to the recipient. To initiate replication, the binary logs required for ...In addition to cloning data, a cloning operation extracts replication coordinates from the donor and transfers them to the recipient, which enables using the clone plugin for provisioning Group Replication members and ...
https://dev.mysql.com/doc/refman/8.4/en/innodb-deadlocks-handling.html
It explains how to organize database operations to minimize deadlocks and the subsequent error handling required in applications. You can cope with deadlocks and reduce the likelihood of their occurrence with the following techniques: At any time, ... This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock ...