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-user-attributes-table.html
The USER_ATTRIBUTES table (available as of MySQL 8.0.21) provides information about user comments and user attributes. The USER_ATTRIBUTES table has these columns: USER The user name portion of the account to which the ATTRIBUTE column value ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-user-privileges-table.html
The USER_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. The value can be any privilege that can be granted at the global level; see Section 15.7.1.6, “GRANT ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-views-table.html
Notes MySQL permits different sql_mode settings to tell the server the type of SQL syntax to support. 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 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-backup.html
Note InnoDB does not support databases that are restored using third-party backup tools. The key to safe database management is making regular backups. Hot and cold backups are physical backups that copy actual data files, which can be used ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-in-core-file.html
Note Access to the data present in buffer pool pages at the time the mysqld process died may be beneficial in some debugging scenarios. A core file records the status and memory image of a running process. Because the buffer pool resides in main ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-tuning.html
The compressed page size should always be bigger than the maximum record size, or operations may fail as noted in Compression of B-Tree Pages. Most often, the internal optimizations described in InnoDB Data Storage and Compression ensure that the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-usage.html
Compressed tables can be created in file-per-table tablespaces or in general tablespaces. The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed.
https://dev.mysql.com/doc/refman/8.0/en/innodb-consistent-read.html
Note The snapshot of the database state applies to SELECT statements within a transaction, not necessarily to DML statements. A consistent read means that InnoDB uses multi-versioning to present to a query a snapshot of the database at a point in ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-deadlocks-handling.html
Note that the InnoDB instant deadlock detection algorithm also works in this case, because the serializing lock is a row-level lock. This section builds on the conceptual information about deadlocks in Section 17.7.5.2, “Deadlock Detection”. It ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-files-table.html
Note The INNODB_TABLESPACES and INNODB_DATAFILES tables also provide metadata about InnoDB tablespaces, but data is limited to file-per-table, general, and undo tablespaces. The Information Schema FILES table provides metadata about all InnoDB ...