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/information-schema-key-column-usage-table.html
One row with CONSTRAINT_NAME = 'CO', TABLE_NAME = 't3', COLUMN_NAME = 's2', ORDINAL_POSITION = 1, POSITION_IN_UNIQUE_CONSTRAINT = 1. This table provides no information about functional key parts because they are expressions and the table provides ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-schema-privileges-table.html
Each row lists a single privilege, so there is one row per schema privilege held by the grantee. The output does not list GRANT OPTION as a separate row with PRIVILEGE_TYPE='GRANT OPTION'. The SCHEMA_PRIVILEGES table has these columns: GRANTEE The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-table-privileges-table.html
Each row lists a single privilege, so there is one row per table privilege held by the grantee. The output does not list GRANT OPTION as a separate row with PRIVILEGE_TYPE='GRANT OPTION'. The TABLE_PRIVILEGES table has these columns: GRANTEE The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-attributes-table.html
As of MySQL 8.0.22, USER_ATTRIBUTES contents are accessible as follows: All rows are accessible if: The current thread is a replica thread. Otherwise, the currently authenticated account can see the row for that account. Additionally, if the account ... The USER_ATTRIBUTES table (available as of MySQL 8.0.21) provides information about user comments and user ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-privileges-table.html
Each row lists a single privilege, so there is one row per global privilege held by the grantee. The output does not list GRANT OPTION as a separate row with PRIVILEGE_TYPE='GRANT OPTION'. The USER_PRIVILEGES table has these columns: GRANTEE The ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-views-table.html
You must have the SHOW VIEW privilege to access this table. The VIEWS table has these columns: TABLE_CATALOG The name of the catalog to which the view belongs. TABLE_SCHEMA The name of the schema (database) to which the view belongs. VIEW_DEFINITION ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-internal-data.html
Joining data_locks with data_lock_waits can show rows in data_lock_waits that identify a parent row in data_locks that no longer exists or does not exist yet. It is possible for INNODB_TRX to reference rows that are not present in PROCESSLIST or for ... Note This section describes locking information as exposed by the Performance Schema data_locks and data_lock_waits tables, which supersede the INFORMATION_SCHEMA INNODB_LOCKS and INNODB_LOCK_WAITS tables in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-dml.html
Single-row DML statements are the easiest types of statements to turn into memcached operations. These operations are guaranteed to only affect one row when issued through the memcached interface, because the key is unique within the table.
https://dev.mysql.com/doc/refman/8.0/en/innodb-transaction-model.html
InnoDB performs locking at the row level and runs queries as nonlocking consistent reads by default, in the style of Oracle. Typically, several users are permitted to lock every row in InnoDB tables, or any random subset of the rows, without causing ... The InnoDB transaction model aims to combine the best properties of a multi-versioning database with traditional two-phase ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-optimization.html
To coalesce fragmented rows and eliminate wasted space that results from deleting or updating rows, run myisamchk in recovery mode: $> myisamchk -r tbl_name You can optimize a table in the same way by using the OPTIMIZE TABLE SQL statement.