PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.1Kb
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-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 28.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description Introduced INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-debian.html
The section provides information about installing NDB Cluster on Debian and related Linux distributions such Ubuntu using the .deb files supplied by Oracle for this purpose. This file is named using the pattern shown here, according to the ...
https://dev.mysql.com/doc/refman/8.0/en/sys-io-global-by-file-by-latency.html
These views summarize global I/O consumers to display time waiting for I/O, grouped by file. The io_global_by_file_by_latency and x$io_global_by_file_by_latency views have these columns: file The file path name. total_latency The total wait time of ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-configuration-variables.html
Because the InnoDB storage engine performs many of its optimizations automatically, many performance-tuning tasks involve monitoring to ensure that the database is performing well, and changing configuration options when performance drops. The main ...Because the default is to buffer all types of data change operations, only change this setting if you need to reduce the amount of ... Different settings work best for servers ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-intro.html
By default, the memcached protocol is used to read and write data directly to InnoDB, letting MySQL manage in-memory caching using the InnoDB buffer pool. Advanced users can configure the system as a traditional memcached server, with all data ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-innodb-storage-layout.html
Once your data reaches a stable size, or a growing table has increased by tens or some hundreds of megabytes, consider using the OPTIMIZE TABLE statement to reorganize the table and compact any wasted space. OPTIMIZE TABLE copies the data part of ...The reorganized tables require less disk I/O to perform full table ...When using COMPACT row format and variable-length character sets, such as utf8mb4 or sjis, ...
https://dev.mysql.com/doc/refman/8.0/en/sys-io-global-by-file-by-bytes.html
These views summarize global I/O consumers to display amount of I/O, grouped by file. The io_global_by_file_by_bytes and x$io_global_by_file_by_bytes views have these columns: file The file path name. avg_read The average number of bytes per read ...write_pct The percentage of total bytes of I/O that were ...By default, ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldumpslow.html
mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow groups queries that are similar except for the particular values of number and string data values. The MySQL slow query log contains information ...-a Do not abstract all numbers to N and strings to ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-metrics-table.html
[mysqld] innodb_monitor_enable = log,metadata_table_handles_opened,metadata_table_handles_closed When enabling multiple counters or modules in a configuration file, specify the innodb_monitor_enable variable followed by counter and module names ...
https://dev.mysql.com/doc/refman/8.0/en/sys-latest-file-io.html
requested The number of data bytes requested for the file I/O event. These views summarize file I/O activity, grouped by file and thread. The latest_file_io and x$latest_file_io views have these columns: thread For foreground threads, the account ...