MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 871 to 880 of 890 total results

https://dev.mysql.com/doc/refman/8.0/en/update-optimization.html

Performing multiple updates together is much quicker than doing one at a time if you lock the table. An update statement is optimized like a SELECT query with the additional overhead of a write. The speed of the write depends on the amount of data ...

3.8 Upgrading MySQL with the MySQL Yum Repository

https://dev.mysql.com/doc/refman/8.0/en/updating-yum-repo.html

Upgrading MySQL Upgrade MySQL and its components by the following command, for platforms that are not dnf-enabled: sudo yum update mysql-server For platforms that are dnf-enabled: sudo dnf upgrade mysql-server Alternatively, you can update MySQL by ... For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can perform an in-place upgrade for MySQL (that is, replacing the old version and then running the new version using the old data files) with the MySQL Yum ...

3.1 Before You Begin

https://dev.mysql.com/doc/refman/8.0/en/upgrade-before-you-begin.html

If your MySQL installation contains a large amount of data that might take a long time to convert after an in-place upgrade, it may be useful to create a test instance for assessing the conversions that are required and the work involved to perform ...The backup should include the mysql system database, which contains the MySQL data dictionary tables and system ...

13.4.11 Using Spatial Indexes

https://dev.mysql.com/doc/refman/8.0/en/using-spatial-indexes.html

The optimizer investigates whether available spatial indexes can be involved in the search for queries that use a function such as MBRContains() or MBRWithin() in the WHERE clause. The following query finds all objects that are in the given ...

7.1.9 Using System Variables

https://dev.mysql.com/doc/refman/8.0/en/using-system-variables.html

The client's session variables are initialized at connect time using the current values of the corresponding global variables. To restrict the maximum value to which a system variable can be set at runtime with the SET statement, specify this ...

8.4.3.3 Transitioning to the Password Validation Component

https://dev.mysql.com/doc/refman/8.0/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. If you need to set any validate_password.xxx system variables, you can do so at runtime using SET GLOBAL.

2.1.4 Verifying Package Integrity Using MD5 Checksums or GnuPG

https://dev.mysql.com/doc/refman/8.0/en/verifying-package-integrity.html

If you notice that the MD5 checksum or GPG signatures do not match, first try to download the respective package one more time, perhaps from another mirror site. After downloading the MySQL package that suits your needs and before attempting to ...

27.9 Restrictions on Views

https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html

In this case, the view is stored in a temporary table and thus you are not really selecting from the table in a subquery and modifying it at the same time. The maximum number of tables that can be referenced in the definition of a view is 61. View ...

27.5.3 Updatable and Insertable Views

https://dev.mysql.com/doc/refman/8.0/en/view-updatability.html

It is sometimes possible for a multiple-table view to be updatable, assuming that it can be processed with the MERGE algorithm. They must not be expressions, such as these: 3.14159 col1 + 3 UPPER(col2) col3 / col4 (subquery) MySQL sets a flag, ...

10.2.1.1 WHERE Clause Optimization

https://dev.mysql.com/doc/refman/8.0/en/where-optimization.html

At one time, a scan was used based on whether the best index spanned more than 30% of the table, but a fixed percentage no longer determines the choice between using an index or a scan. This section discusses optimizations that can be made for ...

Displaying 871 to 880 of 890 total results