Search Results
https://dev.mysql.com/doc/refman/8.4/en/upgrade-before-you-begin.html
The only supported alternative is to restore a backup taken before upgrading. Upgrade procedures vary by platform and how the initial installation was performed. Use the procedure that applies to your current MySQL installation: For binary and ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-transitioning.html
The procedure installs the component before uninstalling the plugin, to avoid having a time window during which no password validation occurs. Uninstall the validate_password plugin: UNINSTALL PLUGIN validate_password; If the validate_password ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-4-0.html
(Bug #22473405) DatabaseMetadata.getProcedureColumns() and DatabaseMetadata.getFunctionColumns() returned incorrect information when the procedure or function column names include whitespace characters. (Bug #21294134) ... Note These release notes ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-gtid-repair.html
A situation that can create a diverged set of transactions with no outside changes is when the primary cluster becomes unreachable and an emergency failover procedure is used. If the whole InnoDB Cluster is affected, remove the affected cluster from ... AdminAPI's clusterSet.status() command warns you if an InnoDB Cluster's GTID set is inconsistent with the GTID set on the primary cluster in the InnoDB ...
https://dev.mysql.com/doc/connectors/en/connector-j-time-instants.html
A time instant is said to be preserved when it always refers to the same point in time when its value is being stored to or retrieved from a database, no matter what time zones the database server and the clients are operating in. TIMESTAMP is the ... Background A time instant is a specific moment on a ...
https://dev.mysql.com/doc/connector-j/en/connector-j-time-instants.html
A time instant is said to be preserved when it always refers to the same point in time when its value is being stored to or retrieved from a database, no matter what time zones the database server and the clients are operating in. TIMESTAMP is the ... Background A time instant is a specific moment on a ...
https://dev.mysql.com/doc/refman/8.4/en/replication-options-replica.html
It does not apply to stored procedures and functions, or events. It does not affect statements that apply only to other database objects, such as stored routines. To filter statements operating on stored routines, use one or more of the ... This ...
https://dev.mysql.com/doc/refman/8.4/en/flush.html
However, you may use FLUSH in stored procedures, so long as these are not called from stored functions or triggers. Note It is not possible to issue FLUSH statements within stored functions or triggers. For information about prepared statement ...| ...
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
If the DEFINER clause is present, the privileges required depend on the user value, as discussed in Section 27.6, “Stored Object Access Control”. In general, the rules governing event names are the same as those for names of stored routines. The ... CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA | SLAVE}] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbd-definition.html
(NDB 8.4.0) This global parameter can be set only in the [ndbd default] section, and defines the number of fragment replicas for each table stored in the cluster. Warning Setting NoOfReplicas to 1 means that there is only a single copy of all ...