Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-schema.html
Stored procedures that perform operations such as Performance Schema configuration and generating diagnostic reports. If this is not desired, you can drop the sys schema manually after initialization if it is unneeded. The MySQL upgrade procedure ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
During this process, the server upgrades metadata for all database objects, including databases, tablespaces, system and user tables, views, and stored programs (stored procedures and functions, triggers, and Event Scheduler events). Export your ...
https://dev.mysql.com/doc/mysql-shell/9.4/en/innodb-clusterset-remove.html
After that, the former primary cluster can be removed using this procedure. If they are met, MySQL Shell carries out the following tasks to remove the target cluster from the InnoDB ClusterSet: Drops the replication user that was created for the ...
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. If you created a new database for testing the steps in this section, delete ... The following sections in this topic describe how to summarize exiting content using the GenAI: Before You Begin Summarizing Content Running Batch Queries What's Next Before You Begin Review the GenAI requirements and ...
https://dev.mysql.com/doc/workbench/en/wb-what-is-new-8.html
A new auto-completion engine was added for use with object editors (triggers, views, stored procedures, and functions) in the visual SQL editor and in models. This section summarizes how the MySQL Workbench 8.0 release series progressed with each ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-download.html
If you already have the latest package, you can skip this procedure. On the Oracle Software Delivery Cloud page: Select Release from the drop-down list. To download the latest MySQL Enterprise Edition for Linux x86-64 generic binary package, ...
https://dev.mysql.com/doc/refman/8.4/en/converting-tables-to-innodb.html
In contrast with the InnoDB system tablespace, file-per-table tablespaces allow disk space to be reclaimed by the operating system when a table is truncated or dropped. Storage Requirements If you intend to make several temporary copies of your data ... If you have MyISAM tables that you want to convert to InnoDB for better reliability and scalability, review the following guidelines and tips before ...
https://dev.mysql.com/doc/refman/8.4/en/create-function-loadable.html
(CREATE FUNCTION is also used to created stored functions; see Section 15.1.17, “CREATE PROCEDURE and CREATE FUNCTION Statements”.) A loadable function is a way to extend MySQL with a new function that works like a native (built-in) MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking-components-installation.html
$> mysql -u root -p -e "RESET PERSIST component_masking.masking_database" Enter password: (enter root password here) [Optional] Drop the dedicated schema to ensure that it is not used for other purposes. Components provide expanded access to MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-mysql-cluster.html
However, we support such use only as part of a rolling upgrade procedure (see Section 25.6.5, “Performing a Rolling Restart of an NDB Cluster”). In the following section, we answer questions that are frequently asked about MySQL NDB Cluster and ...