PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-views-table.html
TABLE_SCHEMA The name of the schema (database) to which the view belongs. 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. VIEW_DEFINITION ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/innodb-benchmarking.html
If InnoDB is not the default storage engine, you can determine if your database server and applications work correctly with InnoDB by restarting the server with --default-storage-engine=InnoDB on the command line or with ...Since changing the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning-monitoring.html
The information in these tables is system-wide: it summarizes the compression statistics across all compressed tables in your database. A large number of compression operations overall (compared to the number of INSERT, UPDATE and DELETE operations ... Overall application performance, CPU and I/O utilization and the size of disk files are good indicators of how effective compression is for your ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-io.html
InnoDB uses asynchronous disk I/O where possible, by creating a number of threads to handle I/O operations, while permitting other database operations to proceed while the I/O is still in progress. There are two read-ahead heuristics in InnoDB: In ...On Linux and Windows platforms, InnoDB uses the available OS and library functions to perform “native” asynchronous ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-space.html
Pages, Extents, Segments, and Tablespaces Each tablespace consists of database pages. (See Section 14.3, “InnoDB Multi-Versioning”.) How Pages Relate to Table Rows The maximum row length is slightly less than half a database page for 4KB, 8KB, ... The data files that you define in the configuration file using the innodb_data_file_path configuration option form the InnoDB system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-buffer-pool-tables.html
The InnoDB INFORMATION_SCHEMA buffer pool tables provide buffer pool status information and metadata about the pages within the InnoDB buffer pool. The InnoDB INFORMATION_SCHEMA buffer pool tables include those listed below: mysql> SHOW TABLES FROM ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-tables.html
As your database becomes bigger and busier, running up against the limits of your hardware capacity, you monitor and tune these aspects to keep the database running smoothly. For related information and examples, see Section 14.16, “InnoDB ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema.html
You can view a list of InnoDB INFORMATION_SCHEMA tables by issuing a SHOW TABLES statement on the INFORMATION_SCHEMA database: mysql> SHOW TABLES FROM INFORMATION_SCHEMA LIKE 'INNODB%'; For table definitions, see Section 24.4, “INFORMATION_SCHEMA ... This section provides information and usage examples for InnoDB INFORMATION_SCHEMA ...
https://dev.mysql.com/doc/refman/5.7/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 ...