MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 31 to 40 of 82 total results

3.6 Preparing Your Installation for Upgrade

https://dev.mysql.com/doc/refman/8.0/en/upgrade-prerequisites.html

Before upgrading to the latest MySQL 8.0 release, ensure the upgrade readiness of your current MySQL 5.7 or MySQL 8.0 server instance by performing the preliminary checks described below. Tip Consider using the MySQL Shell upgrade checker utility ...

3.7 Upgrading MySQL Binary or Package-based Installations on Unix/Linux

https://dev.mysql.com/doc/refman/8.0/en/upgrade-binary-package.html

This section describes how to upgrade MySQL binary and package-based installations on Unix/Linux. In-Place Upgrade Logical Upgrade MySQL Cluster Upgrade In-Place Upgrade An in-place upgrade involves shutting down the old MySQL server, replacing the ...

10.11.2 Table Locking Issues

https://dev.mysql.com/doc/refman/8.0/en/table-locking.html

InnoDB tables use row-level locking so that multiple sessions and applications can read from and write to the same table simultaneously, without making each other wait or producing inconsistent results. For this storage engine, avoid using the LOCK ...

30.4.4.22 The ps_trace_statement_digest() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-trace-statement-digest.html

Traces all Performance Schema instrumentation for a specific statement digest. If you find a statement of interest within the Performance Schema events_statements_summary_by_digest table, specify its DIGEST column MD5 value to this procedure and ...

27.8 Restrictions on Stored Programs

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

Some of the restrictions noted here apply to all stored routines; that is, both to stored procedures and stored functions. There are also some restrictions specific to stored functions but not to stored procedures. The restrictions for stored ...

15.7.3.5 REPAIR TABLE Statement

https://dev.mysql.com/doc/refman/8.0/en/repair-table.html

[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE repairs a possibly corrupted table, for certain storage engines only. Although normally you should never have to run REPAIR TABLE, if disaster strikes, this statement is very likely to get back all your data ...

15.7.7.13 SHOW CREATE VIEW Statement

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

SHOW CREATE VIEW view_name This statement shows the CREATE VIEW statement that creates the named view. row *************************** View: v Create View: CREATE ALGORITHM=UNDEFINED DEFINER=`bob`@`localhost` SQL SECURITY DEFINER VIEW `v` AS select ...

15.7.7.3 SHOW CHARACTER SET Statement

https://dev.mysql.com/doc/refman/8.0/en/show-character-set.html

SHOW {CHARACTER SET | CHARSET} [LIKE 'pattern' | WHERE expr] The SHOW CHARACTER SET statement shows all available character sets. The LIKE clause, if present, indicates which character set names to match. The WHERE clause can be given to select ...

8.4.1.3 SHA-256 Pluggable Authentication

https://dev.mysql.com/doc/refman/8.0/en/sha256-pluggable-authentication.html

MySQL provides two authentication plugins that implement SHA-256 hashing for user account passwords: caching_sha2_password: Implements SHA-256 authentication (like the deprecated sha256_password), but uses caching on the server side for better ...

13.3.6 The SET Type

https://dev.mysql.com/doc/refman/8.0/en/set.html

A SET is a string object that can have zero or more values, each of which must be chosen from a list of permitted values specified when the table is created. SET column values that consist of multiple set members are specified with members ...

Displaying 31 to 40 of 82 total results