Search Results
https://dev.mysql.com/doc/refman/8.4/en/show-engines.html
row *************************** Engine: InnoDB Support: DEFAULT Comment: Supports transactions, row-level locking, and foreign keys Transactions: YES XA: YES Savepoints: YES *************************** 3. SHOW [STORAGE] ENGINES SHOW ENGINES ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/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 ...
https://dev.mysql.com/doc/refman/8.4/en/sys-statement-analysis.html
lock_latency The total time waiting for locks by timed occurrences of the statement. The statement_analysis and x$statement_analysis views have these columns: query The normalized statement string. db The default database for the statement, or NULL ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-statement-latency.html
lock_latency The total time waiting for locks by timed statements for the user. The user_summary_by_statement_latency and x$user_summary_by_statement_latency views have these columns: user The client user name. Rows for which the USER column in the ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-statement-type.html
lock_latency The total time waiting for locks by timed occurrences of the statement event for the user. These views summarize information about statements executed, grouped by user and statement type. By default, rows are sorted by user and ...