MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 651 to 660 of 664 total results

30.4.3.22 The processlist and x$processlist Views

https://dev.mysql.com/doc/refman/8.0/en/sys-processlist.html

The MySQL process list indicates the operations currently being performed by the set of threads executing within the server. They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, ...

30.4.3.50 The waits_by_host_by_latency and x$waits_by_host_by_latency Views

https://dev.mysql.com/doc/refman/8.0/en/sys-waits-by-host-by-latency.html

The waits_by_host_by_latency and x$waits_by_host_by_latency views have these columns: host The host from which the connection originated. These views summarize wait events, grouped by host and event. By default, rows are sorted by host and ...

30.4.3.51 The waits_by_user_by_latency and x$waits_by_user_by_latency Views

https://dev.mysql.com/doc/refman/8.0/en/sys-waits-by-user-by-latency.html

The waits_by_user_by_latency and x$waits_by_user_by_latency views have these columns: user The user associated with the connection. These views summarize wait events, grouped by user and event. By default, rows are sorted by user and descending ...

7.3 The mysql System Schema

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

default_roles: This table lists default roles to be activated after a user connects and authenticates, or executes SET ROLE DEFAULT. It contains tables that store information required by the MySQL server as it runs. A broad categorization is that ...

10.11.2 Table Locking Issues

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

To specify that all updates issued in a specific connection should be done with low priority, set the low_priority_updates server system variable equal to 1. InnoDB tables use row-level locking so that multiple sessions and applications can read ...

8.4.1.12 Test Pluggable Authentication

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

MySQL includes a test plugin that checks account credentials and logs success or failure to the server error log. This is a loadable plugin (not built in) and must be installed prior to use. The test plugin source code is separate from the server ...

3.3 Upgrade Best Practices

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

Connect to the existing MySQL server and select the MySQL Server version you plan to upgrade to for the utility to report issues to address prior to an upgrade. MySQL supports upgrading between minor versions (within an LTS series) and to the next ...

Chapter 3 Upgrading MySQL

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

SQL statements can be executed using the mysql command-line client (connect as root to ensure that you have the necessary privileges). This chapter describes the steps to upgrade a MySQL installation. Upgrading is a common procedure, as you pick up ...

11.4 User-Defined Variables

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

You can store a value in a user-defined variable in one statement and refer to it later in another statement. This enables you to pass values from one statement to another. User variables are written as @var_name, where the variable name var_name ...

27.5.2 View Processing Algorithms

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

The optional ALGORITHM clause for CREATE VIEW or ALTER VIEW is a MySQL extension to standard SQL. For MERGE, the text of a statement that refers to the view and the view definition are merged such that parts of the view definition replace ...

Displaying 651 to 660 of 664 total results