MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 1151 to 1160 of 1164 total results

30.4.3.49 The wait_classes_global_by_latency and x$wait_classes_global_by_latency Views

https://dev.mysql.com/doc/refman/8.0/en/sys-wait-classes-global-by-latency.html

These views summarize wait class total latencies, grouped by event class. An event class is determined by stripping from the event name everything after the first three components. The wait_classes_global_by_latency and ...

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

By default, rows are sorted by host and descending total latency. These views summarize wait events, grouped by host and event. 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/8.0/en/sys-waits-by-user-by-latency.html

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

30.4.3.52 The waits_global_by_latency and x$waits_global_by_latency Views

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

The waits_global_by_latency and x$waits_global_by_latency views have these columns: events The event name. total_latency The total wait time of timed occurrences of the event. avg_latency The average wait time per timed occurrence of the event.

8.4.1.12 Test Pluggable Authentication

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

For example: $> mysql --user=testuser --password Enter password: testpassword The plugin fetches the password as received from the client and compares it with the value stored in the authentication_string column of the account row in the mysql.user ... MySQL includes a test plugin that checks account credentials and logs success or failure to the server error ...

10.3.14 Indexed Lookups from TIMESTAMP Columns

https://dev.mysql.com/doc/refman/8.0/en/timestamp-lookups.html

For the two distinct session time zone values that map to the same UTC value, the indexed lookup matches only the corresponding UTC index entry and returns only a single row. Temporal values are stored in TIMESTAMP columns as UTC values, and values ...

10.15.3 Traceable Statements

https://dev.mysql.com/doc/refman/8.0/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 ...For statements which are prepared and executed in separate steps, preparation and execution are traced ...

15.7.4.5 UNINSTALL COMPONENT Statement

https://dev.mysql.com/doc/refman/8.0/en/uninstall-component.html

It requires the DELETE privilege for the mysql.component system table because it removes the row from that table that registers the component. A component provides services that are available to the server and other components; see Section 7.5, ...

8.2.1 Account User Names and Passwords

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

The server is free to ignore rows that become malformed as a result of such modifications. MySQL stores accounts in the user table of the mysql system database. An account is defined in terms of a user name and the client host or hosts from which ...

10.8.1 Optimizing Queries with EXPLAIN

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

With the help of EXPLAIN, you can see where you should add indexes to tables so that the statement executes faster by using indexes to find rows. The EXPLAIN statement provides information about how MySQL executes statements: EXPLAIN works with ...

Displaying 1151 to 1160 of 1164 total results