PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 24.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated CHARACTER_SETS Available character sets ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-stats-table.html
These occur when threads go to sleep; for example, by calling the SLEEP() function. The TP_THREAD_GROUP_STATS table has these columns: TP_GROUP_ID The thread group ID. This number is incremented when a statement starts executing, not when it ...
https://dev.mysql.com/doc/refman/5.7/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/5.7/en/innodb-configuring-io-capacity.html
Generally, you can increase the value as a function of the number of drives used for InnoDB I/O. The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing dirty pages from ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-create-table-external.html
An .isl file is similar in function to a symbolic link. There are different reasons for creating InnoDB tables externally; that is, creating tables outside of the data directory. Those reasons might include space management, I/O optimization, or ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlocks-handling.html
For example, organize database operations into functions within your application, or call stored routines, rather than coding multiple similar sequences of INSERT, UPDATE, and DELETE statements in different places. This section builds on the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-disk-io.html
On Linux and Windows platforms, InnoDB uses the available OS and library functions to perform “native” asynchronous I/O. InnoDB uses asynchronous disk I/O where possible, by creating a number of threads to handle I/O operations, while ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-fulltext-index.html
Full-text indexes are created on text-based columns (CHAR, VARCHAR, or TEXT columns) to speed up queries and DML operations on data contained within those columns. A full-text index is defined as part of a CREATE TABLE statement or added to an ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-metrics-table.html
Note Because each counter adds a degree of runtime overhead, use counters conservatively on production servers to diagnose specific issues or monitor specific functionality. The INNODB_METRICS table provides information about InnoDB performance and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-introduction.html
InnoDB is a general-purpose storage engine that balances high reliability and high performance. Unless you have configured a different default storage engine, issuing a CREATE TABLE statement without an ENGINE clause creates an InnoDB table. Key ...