Search Results
https://dev.mysql.com/doc/refman/8.4/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...
https://dev.mysql.com/doc/refman/8.4/en/system-schema.html
Replaces the data dictionary buffer table that resided in the InnoDB system tablespace. It contains tables that store information required by the MySQL server as it runs. A broad categorization is that the mysql schema contains data dictionary ...
https://dev.mysql.com/doc/refman/8.4/en/table.html
With INSERT and REPLACE statements, where you would otherwise use SELECT *. TABLE is a DML statement which returns rows and columns of the named table. Given the existence of a table named t, the following two statements produce identical output: ...
https://dev.mysql.com/doc/refman/8.4/en/uln-installation.html
If you are changing your package source to use ULN and not changing which build of MySQL you are using, then back up your data, remove your existing binaries, and replace them with those from ULN. Linux supports a number of different solutions for ...
https://dev.mysql.com/doc/refman/8.4/en/update.html
Note Unlike the case when using PARTITION with an INSERT or REPLACE statement, an otherwise valid UPDATE ... UPDATE is a DML statement that modifies rows in a table. An UPDATE statement can start with a WITH clause to define common table ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-best-practices.html
MySQL supports upgrading between minor versions (within an LTS series) and to the next major version (across an LTS series). LTS releases have 8+ years of support and are meant for production use. Performing a minor version upgrade is ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-binary-package.html
In-Place Upgrade Logical Upgrade MySQL Cluster Upgrade In-Place Upgrade An in-place upgrade involves shutting down the old MySQL server, replacing the old MySQL binaries or packages with the new ones, restarting MySQL on the existing data directory, ... This section describes how to upgrade MySQL binary and package-based installations on ...
https://dev.mysql.com/doc/refman/8.4/en/upgrading-what-is-upgraded.html
If the actual data dictionary version is lower than the current expected version, the server creates data dictionary tables with updated definitions, copies persisted metadata to the new tables, atomically replaces the old tables with the new ones, ... Installing a new version of MySQL may require upgrading these parts of the existing installation: The mysql system schema, which contains tables that store information required by the MySQL server as it runs (see Section 7.3, “The mysql System ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
It is sufficient to replace the existing file contents with a nonexpired certificate and execute ALTER INSTANCE RELOAD TLS to cause the new file contents to be read and used for new connections. Several configuration parameters are available to ...