MySQL :: MySQL 8.0 Reference Manual

Search Results

Displaying 281 to 290 of 299 total results

https://dev.mysql.com/doc/refman/8.0/en/replication-setup-replicas.html

On the source, released the read lock: mysql> UNLOCK TABLES; On the replica, edited the MySQL configuration. Before you proceed, ensure that you have: Configured the source with the necessary configuration properties. Obtained the source status ...

10.2.1 Optimizing SELECT Statements

https://dev.mysql.com/doc/refman/8.0/en/select-optimization.html

Deal with locking issues, where the speed of your query might be affected by other sessions accessing the tables at the same time. Queries, in the form of SELECT statements, perform all the lookup operations in the database. Tuning these statements ...

7.1.4 Server Option, System Variable, and Status Variable Reference

https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html

The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...

15.7.7.16 SHOW ENGINES Statement

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

row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 8. SHOW [STORAGE] ENGINES SHOW ENGINES ...

15.7.7.21 SHOW GRANTS Statement

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

SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...

30.4.3.5 The host_summary_by_statement_latency and x$host_summary_by_statement_latency Views

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

lock_latency The total time waiting for locks by timed statements for the host. The host_summary_by_statement_latency and x$host_summary_by_statement_latency views have these columns: host The host from which the client connected. Rows for which the ...

30.4.3.6 The host_summary_by_statement_type and x$host_summary_by_statement_type Views

https://dev.mysql.com/doc/refman/8.0/en/sys-host-summary-by-statement-type.html

lock_latency The total time waiting for locks by timed occurrences of the statement event for the host. These views summarize information about statements executed, grouped by host and statement type. By default, rows are sorted by host and ...

30.4.3.22 The processlist and x$processlist Views

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

They provide more complete information than the SHOW PROCESSLIST statement and the INFORMATION_SCHEMA PROCESSLIST table, and are also nonblocking. lock_latency The time spent waiting for locks by the current statement. The MySQL process list ...

30.4.4.6 The ps_setup_disable_instrument() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-instrument.html

Example Disable a specific instrument: mysql> CALL sys.ps_setup_disable_instrument('wait/lock/metadata/sql/mdl'); +-----------------------+ | summary | +-----------------------+ | Disabled 1 instrument | +-----------------------+ Disable all mutex ... Disables Performance Schema instruments with names that contain the ...

30.4.4.10 The ps_setup_enable_instrument() Procedure

https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-enable-instrument.html

Example Enable a specific instrument: mysql> CALL sys.ps_setup_enable_instrument('wait/lock/metadata/sql/mdl'); +----------------------+ | summary | +----------------------+ | Enabled 1 instrument | +----------------------+ Enable all mutex ...

Displaying 281 to 290 of 299 total results