PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.5Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/sys-user-summary.html
Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background threads and are reported with a host name of background. These views summarize statement activity, file I/O, and connections, grouped ...
https://dev.mysql.com/doc/refman/8.0/en/thread-information.html
row *************************** Id: 5 User: event_scheduler Host: localhost db: NULL Command: Daemon Time: 2756681 State: Waiting on empty queue Info: NULL *************************** 2. row *************************** Id: 20 User: me Host: ... To ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-information-schema-tables.html
They provide information about thread pool operation: TP_THREAD_GROUP_STATE: Information about thread pool thread group states TP_THREAD_GROUP_STATS: Thread group statistics TP_THREAD_STATE: Information about thread pool thread states Rows in these ... Note As of MySQL 8.0.14, the INFORMATION_SCHEMA thread pool tables are also available as Performance Schema ...
https://dev.mysql.com/doc/refman/8.0/en/timestamp-initialization.html
For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, the auto-update value, or both: An auto-initialized column is set to the current timestamp for inserted rows that specify no value for the ...
https://dev.mysql.com/doc/refman/8.0/en/uninstall-plugin.html
It requires the DELETE privilege for the mysql.plugin system table because it removes the row from that table that registers the plugin. The server executes the plugin's deinitialization function and removes the row for the plugin from the ...
https://dev.mysql.com/doc/refman/8.0/en/xa-restrictions.html
When binlog_format=MIXED or binlog_format=ROW is set, DML statements inside XA transactions are logged using row-based replication, and the potential issue is not present. XA transaction support is limited to the InnoDB storage engine. For ...
https://dev.mysql.com/doc/refman/8.0/en/xa-statements.html
(See Section 15.3.8.2, “XA Transaction States”.) The output includes a row for each such XA transaction on the server, regardless of which client started it. To perform XA transactions in MySQL, use the following statements: XA {START|BEGIN} ...
https://dev.mysql.com/doc/refman/8.0/en/access-control.html
For example, if you try to select rows from a table in a database or drop a table from the database, the server verifies that you have the SELECT privilege for the table or the DROP privilege for the database. MySQL enables the creation of accounts ...
https://dev.mysql.com/doc/refman/8.0/en/adding-collation.html
Note If you modify an existing user-defined collation, that may affect the ordering of rows for indexes on columns that use the collation. Warning User-defined collations are deprecated; you should expect support for them to be removed in a future ...
https://dev.mysql.com/doc/refman/8.0/en/all-subqueries.html
The expression is TRUE if table t2 contains (-5,0,+5) because 10 is greater than all three values in t2. The expression is FALSE if table t2 contains (12,6,NULL,-100) because there is a single value 12 in table t2 that is greater than 10. The ...