MySQL :: MySQL 9.7 Reference Manual

Search Results

Displaying 681 to 690 of 692 total results

30.4.3.50 The waits_by_host_by_latency and x$waits_by_host_by_latency Views

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

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

30.4.3.51 The waits_by_user_by_latency and x$waits_by_user_by_latency Views

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

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

7.3 The mysql System Schema

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

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 tables that store database object metadata, and system tables used for other operational ...

10.11.2 Table Locking Issues

https://dev.mysql.com/doc/refman/9.7/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 ...

8.4.1.12 Test Pluggable Authentication

https://dev.mysql.com/doc/refman/9.7/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 ...

Chapter 3 Upgrading MySQL

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

This chapter describes the steps to upgrade a MySQL installation. Upgrading is a common procedure, as you pick up bug fixes within the same MySQL release series or significant features between major MySQL releases. You perform this procedure first ...

11.4 User-Defined Variables

https://dev.mysql.com/doc/refman/9.7/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.6.2 View Processing Algorithms

https://dev.mysql.com/doc/refman/9.7/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 ...

B.3.1 How to Determine What Is Causing a Problem

https://dev.mysql.com/doc/refman/9.7/en/what-is-crashing.html

This can normally be checked by pressing the Caps Lock key. If the Caps Lock light does not change, you have to replace your keyboard. (Before doing this, you should try to restart your computer and check all cables to the keyboard.) The mouse ...

1.2.1 What is MySQL?

https://dev.mysql.com/doc/refman/9.7/en/what-is-mysql.html

MySQL, the most popular Open Source SQL database management system, is developed, distributed, and supported by Oracle Corporation. The MySQL website (http://www.mysql.com/) provides the latest information about MySQL software. It may be anything ...

Displaying 681 to 690 of 692 total results