MySQL :: MySQL 5.7 Reference Manual

Search Results

Displaying 1411 to 1420 of 1425 total results

26.4.3.44 The user_summary_by_stages and x$user_summary_by_stages Views

https://dev.mysql.com/doc/refman/5.7/en/sys-user-summary-by-stages.html

Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. By default, rows are sorted by user and descending total stage latency. The ...

5.5.3.4 Thread Pool Tuning

https://dev.mysql.com/doc/refman/5.7/en/thread-pool-tuning.html

The default value of 6 (60ms) is suitable for servers that primarily execute very simple statements. Assuming that the TP_THREAD_GROUP_STATS table is enabled, you can use the following query to determine the fraction of executed statements that ...

11.2.3 The TIME Type

https://dev.mysql.com/doc/refman/5.7/en/time.html

Note that because '00:00:00' is itself a valid TIME value, there is no way to tell, from a value of '00:00:00' stored in a table, whether the original value was specified as '00:00:00' or whether it was invalid. MySQL retrieves and displays TIME ...

8.15.3 Traceable Statements

https://dev.mysql.com/doc/refman/5.7/en/traceable-statements.html

Statements which are traceable are listed here: SELECT INSERT REPLACE UPDATE DELETE EXPLAIN with any of the preceding statements SET DO DECLARE, CASE, IF, and RETURN as used in stored routines CALL Tracing is supported for both INSERT and REPLACE ...

4.2.5 Connection Transport Protocols

https://dev.mysql.com/doc/refman/5.7/en/transport-protocols.html

The following table shows the permissible values for --protocol and indicates the applicable platforms for each value. For programs that use the MySQL client library (for example, mysql and mysqldump), MySQL supports connections to the server based ...

8.15.4 Tuning Trace Purging

https://dev.mysql.com/doc/refman/5.7/en/tuning-trace-purging.html

A subsequent SELECT from the OPTIMIZER_TRACE table returns the first limit traces of the offset oldest stored traces (if offset >= 0), or the first limit traces of the -offset newest stored traces (if offset < 0). Thus, if a statement contains ...

Chapter 3 Tutorial

https://dev.mysql.com/doc/refman/5.7/en/tutorial.html

If you are interested only in accessing an existing database, you may want to skip the sections that describe how to create the database and the tables it contains. This chapter provides a tutorial introduction to MySQL by showing how to use the ...

2.10.5 Upgrading MySQL with the MySQL Yum Repository

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

mysql_upgrade also performs other functions; see Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables” for details. For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum ...

2.10.1 Before You Begin

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

The backup should include the mysql system database, which contains the MySQL system tables. Review Section 2.10.2, “Upgrade Paths” to ensure that your intended upgrade path is supported. Review Section 2.10.3, “Changes in MySQL 5.7” for ...

6.4.3.2 Password Validation Plugin Options and Variables

https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html

This section describes the options, system variables, and status variables that validate_password provides to enable its operation to be configured and monitored. The value should be one of those available for plugin-loading options, as described ...

Displaying 1411 to 1420 of 1425 total results