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-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-view-routine-usage-table.html
The VIEW_ROUTINE_USAGE table (available as of MySQL 8.0.13) provides access to information about stored functions used in view definitions. The table does not list information about built-in (native) functions or loadable functions used in the ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema-view-table-usage-table.html
The VIEW_TABLE_USAGE table (available as of MySQL 8.0.13) provides access to information about tables and views used in view definitions. You can see information only for views for which you have some privilege, and only for tables for which you ...
https://dev.mysql.com/doc/refman/8.0/en/information-schema.html
INFORMATION_SCHEMA provides access to database metadata, information about the MySQL server such as the name of a database or table, the data type of a column, or access privileges. Other terms that are sometimes used for this information are data ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-optimization.html
Knowing how the InnoDB buffer pool works, and taking advantage of it to keep frequently accessed data in memory, is an important aspect of MySQL tuning. InnoDB maintains a storage area called the buffer pool for caching data and indexes in memory.
https://dev.mysql.com/doc/refman/8.0/en/innodb-compression-background.html
For extracting or updating the column values, MySQL also creates an uncompressed page in the buffer pool with the uncompressed data. Because processors and cache memories have increased in speed more than disk storage devices, many workloads are ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-disk-management.html
Sometimes, I/O is postponed until the database is not busy, or until everything needs to be brought to a consistent state, such as during a database restart after a fast shutdown. This section discusses the main considerations for I/O and disk space ... As a DBA, you must manage disk I/O to keep the I/O subsystem from becoming saturated, and manage disk space to avoid filling up storage ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-transaction-model.html
To implement a large-scale, busy, or highly reliable database application, to port substantial code from a different database system, or to tune MySQL performance, it is important to understand InnoDB locking and the InnoDB transaction model. This ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-dml.html
Therefore, consider focussing initial development efforts on write-intensive applications that are I/O-bound, and look for opportunities to use MySQL with the daemon_memcached plugin for new write-intensive applications. Benchmarks suggest that the ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-online-ddl-limitations.html
Tables created before MySQL 5.6 that include temporal columns (DATE, DATETIME or TIMESTAMP) and have not been rebuilt using ALGORITHM=COPY do not support ALGORITHM=INPLACE. A long running or inactive transaction that holds a metadata lock on the ...