PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/show-events.html
In its simplest form, SHOW EVENTS lists all of the events in the current schema: mysql> SELECT CURRENT_USER(), SCHEMA(); +----------------+----------+ | CURRENT_USER() | SCHEMA() | +----------------+----------+ | jon@ghidora | myschema | ... SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/show-index.html
row *************************** Table: city Non_unique: 0 Key_name: PRIMARY Seq_in_index: 1 Column_name: ID Collation: A Cardinality: 4188 Sub_part: NULL Packed: NULL Null: Index_type: BTREE Comment: Index_comment: Visible: YES Expression: NULL ...
https://dev.mysql.com/doc/refman/8.0/en/show-procedure-status.html
The WHERE clause can be given to select rows using more general conditions, as discussed in Section 28.8, “Extensions to SHOW Statements”. row *************************** Db: test Name: sp1 Type: PROCEDURE Definer: testuser@localhost Modified: ... SHOW PROCEDURE STATUS [LIKE 'pattern' | WHERE expr] This statement is a MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-disabled-instruments.html
Displays all currently disabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_disabled_instruments()\G *************************** 1. row *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-enabled-instruments.html
Displays all currently enabled Performance Schema instruments. This might be a long list. Parameters None. Example mysql> CALL sys.ps_setup_show_enabled_instruments()\G *************************** 1. row *************************** ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-show-enabled.html
Displays all currently enabled Performance Schema configuration. Parameters in_show_instruments BOOLEAN: Whether to display enabled instruments. This might be a long list. in_show_threads BOOLEAN: Whether to display enabled threads. Example mysql> ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-thread-trx-info.html
The value should match the THREAD_ID column from some Performance Schema threads table row. Returns a JSON object containing information about a given thread. The information includes the current transaction, and the statements it has already ...
https://dev.mysql.com/doc/refman/8.0/en/sys-schema-tables-with-full-table-scans.html
rows_full_scanned The total number of rows scanned by full scans of the table. These views display which tables are being accessed with full table scans. The schema_tables_with_full_table_scans and x$schema_tables_with_full_table_scans views have ...
https://dev.mysql.com/doc/refman/8.0/en/sys-statements-with-sorting.html
rows_sorted The total number of rows sorted by occurrences of the statement. avg_rows_sorted The average number of rows sorted per occurrence of the statement. The statements_with_sorting and x$statements_with_sorting views have these columns: query ...
https://dev.mysql.com/doc/refman/8.0/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. The automatic row-level locking makes these ...For this storage engine, avoid using the LOCK TABLES statement, because it does not offer any extra protection, but instead reduces ...