PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-examples.html
Note There may be inconsistencies between queries shown in the INFORMATION_SCHEMA PROCESSLIST and INNODB_TRX tables. The following table shows the contents of the Information Schema PROCESSLIST table for a system running a heavy workload. The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-internal-data.html
INNODB_TRX may reference rows that are not present in PROCESSLIST or the currently executing SQL query of a transaction shown in INNODB_TRX.TRX_QUERY may differ from the one in PROCESSLIST.INFO. Thus, you should be careful when comparing data in the ... The data exposed by the transaction and locking tables (INNODB_TRX, INNODB_LOCKS, and INNODB_LOCK_WAITS) represents a glimpse into fast-changing ...
https://dev.mysql.com/doc/refman/5.7/en/privileges-provided.html
Thread information available using the SHOW PROCESSLIST statement, the mysqladmin processlist command, the INFORMATION_SCHEMA.PROCESSLIST table, and the Performance Schema processlist table is accessible as follows: With the PROCESS privilege, a ...
https://dev.mysql.com/doc/refman/5.7/en/dba-dtrace-mysqld-ref.html
This is the same as the process ID shown as the Id value in the output from SHOW PROCESSLIST. The connection ID equals the connection ID returned when the client first connects and the Id value in the output from SHOW PROCESSLIST. The connection ID ...The values for each type are shown in the following ... MySQL supports the ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
This is the same value displayed in the ID column of the INFORMATION_SCHEMA PROCESSLIST table, displayed in the Id column of SHOW PROCESSLIST output, and returned by the CONNECTION_ID() function within the thread. Unlike the HOST column of the ...
https://dev.mysql.com/doc/refman/5.7/en/kill.html
Thread processlist identifiers can be determined from the ID column of the INFORMATION_SCHEMA PROCESSLIST table, the Id column of SHOW PROCESSLIST output, and the PROCESSLIST_ID column of the Performance Schema threads table. KILL [CONNECTION | ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-object-index.html
The following tables list sys schema objects and provide a short description of each one.
https://dev.mysql.com/doc/refman/5.7/en/sys-session.html
These views are similar to processlist and x$processlist, but they filter out background processes to display only user sessions. For descriptions of the columns, see Section 26.4.3.22, “The processlist and x$processlist Views”.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-show-tables.html
ndb_show_tables displays a list of all NDB database objects in the cluster. Options that can be used with ndb_show_tables are shown in the following table. If this option has not been specified, and no tables are found in the TEST_DB database, ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-show-disabled-consumers.html
Example mysql> CALL sys.ps_setup_show_disabled_consumers(); +----------------------------------+ | disabled_consumers | +----------------------------------+ | events_stages_current | | events_stages_history | | events_stages_history_long | | ...