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/refman/8.4/en/innodb-parameters.html
The innodb_open_files limit can be set at runtime using a SELECT innodb_set_open_files_limit(N) statement, where N is the desired innodb_open_files limit; for example: mysql> SELECT innodb_set_open_files_limit(1000); The statement executes a stored ...Each page that is stored in or read from the buffer pool is assigned to one of the buffer pool instances randomly, using a hashing ... InnoDB Startup Options InnoDB System ...
https://dev.mysql.com/doc/mysql-ai/9.4/en/mys-ai-genai-summarize-content.html
One of the key features of MySQL ', 'is its support for stored procedures, which allow developers to create reusable blocks of ', 'code that can be executed multiple times. MySQL uses a client-server ', 'architecture, where the server stores and ...
https://dev.mysql.com/doc/heatwave/en/mys-hw-genai-summarize-content.html
One of the key features of MySQL ', 'is its support for stored procedures, which allow developers to create reusable blocks of ', 'code that can be executed multiple times. It uses a client-server architecture, supports stored procedures, a wide ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/adding-loadable-function.html
This memory is not allocated, but the value is used to decide which data type to use if there is a need to temporarily store the data. If something went wrong, you can store a value in the variable to which the error argument points. You should not ... The MySQL interface for loadable functions provides the following features and capabilities: Functions can return string, integer, or real values and can accept arguments of those same ...
https://dev.mysql.com/doc/refman/8.4/en/replication-sbr-rbr.html
Note Statements that update the information in the mysql system schema, such as GRANT, REVOKE and the manipulation of triggers, stored routines (including stored procedures), and views, are all replicated to replicas using statement-based ...For ...
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 ...| ...