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/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-replication-tables.html
Developers familiar with the Performance Schema interface can extend the replication tables to provide additional information by adding rows to the tables. That is, if the replica_parallel_workers or slave_parallel_workers system variable is greater ...This is similar to the information available from the SHOW REPLICA STATUS statement, but representation in table form is more accessible and has usability benefits: SHOW REPLICA STATUS output is useful for visual inspection, but not so much for programmatic ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-setup-actors-table.html
This table has a maximum size of 100 rows by default. To change the table size, modify the performance_schema_setup_actors_size system variable at server startup. For each new foreground thread, the Performance Schema matches the user and host for ... The setup_actors table contains information that determines whether to enable monitoring and historical event logging for new foreground server threads (threads associated with client ...
https://dev.mysql.com/doc/refman/8.0/en/derived-tables.html
Alternatively, tbl_name may be followed by a parenthesized list of names for the derived table columns: SELECT ... This can occur if the outer query accesses any tables and an inner query invokes a stored function that changes one or more rows of a ...For information about lateral derived tables preceded by the LATERAL keyword, see Section 15.2.15.9, “Lateral Derived ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-connection-tables.html
The Performance Schema also counts internal threads and threads for user sessions that failed to authenticate, using rows with USER and HOST column values of NULL. The Performance Schema tracks the connections as follows: The accounts table has four ... When a client connects to the MySQL server, it does so under a particular user name and from a particular ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-threads-table.html
The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring and historical event logging are enabled for it: mysql> SELECT * FROM performance_schema.threads\G ...When the ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-source.html
If the local value is set, the new value affects AUTO_INCREMENT columns for all tables into which new rows are inserted by the current user for the duration of the session, unless the values are changed during that session. This section describes ...
https://dev.mysql.com/doc/refman/8.0/en/revoke.html
row *************************** Level: Warning Code: 3162 Message: Authorization ID jerry does not exist. | +---------+------+--------------------------------------------+ 2 rows in set (0.00 sec) Roles named in the mandatory_roles system variable ...[IGNORE UNKNOWN USER] REVOKE [IF EXISTS] ALL [PRIVILEGES], GRANT OPTION FROM user_or_role [, user_or_role] ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-setup.html
It also inserts a single row of data into the demo_test table. The single row of data in the demo_test table has a key value of AA. For example, you can specify options to reduce the maximum number of simultaneous connections, change the maximum ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-innodb-virtual-table.html
A row appears in the INNODB_VIRTUAL table for each column upon which a virtual generated column is based. The value is large because it encodes the column sequence number and ordinal position. The INNODB_VIRTUAL table provides metadata about InnoDB ...