PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-pool-stats-table.html
The INNODB_BUFFER_POOL_STATS table provides much of the same buffer pool information provided in SHOW ENGINE INNODB STATUS output. Much of the same information may also be obtained using InnoDB buffer pool server status variables. For related usage ...The idea of making pages in the buffer pool “young” or “not young” refers to transferring them between the sublists at the head and tail of the buffer pool data ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-configuration.html
For information about optimizing database operations for InnoDB tables, see Section 8.5, “Optimizing for InnoDB Tables”. This section provides configuration information and procedures for InnoDB initialization, startup, and various components ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-backup.html
The next few sections describe how to prepare for and then to create an NDB Cluster backup using the functionality for this purpose found in the ndb_mgm management client. To distinguish this type of backup from a backup made using mysqldump, we ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statements-with-full-table-scans.html
db The default database for the statement, or NULL if there is none. total_latency The total wait time of timed statement events for the statement. rows_examined The total number of rows read from the storage engine for the table. rows_examined_avg ... These views display normalized statements that have done full table ...
https://dev.mysql.com/doc/refman/5.7/en/check-table.html
CHECK TABLE Output Checking Version Compatibility Checking Data Consistency CHECK TABLE Usage Notes for InnoDB Tables CHECK TABLE Usage Notes for MyISAM Tables CHECK TABLE Output CHECK TABLE returns a result set with the columns shown in the ...The ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-restrictions.html
The exception is that for Unicode, the utf8 character set can be used, but not the ucs2 character set. Full-text searches are supported for InnoDB and MyISAM tables only. Although FULLTEXT indexes on ucs2 columns cannot be used, you can perform IN ...Ideographic languages such as Chinese and Japanese do not have word ...
https://dev.mysql.com/doc/refman/5.7/en/gone-away.html
If you need big queries (for example, if you are working with big BLOB columns), you can increase the query limit by setting the server's max_allowed_packet variable, which has a default value of 4MB. More information on setting the packet size is ...The most common reason for the MySQL server has gone away error is that the server timed out and closed the ...
https://dev.mysql.com/doc/refman/5.7/en/installing-development-tree.html
Prerequisites for Installing from Development Source Setting Up a MySQL Git Repository Prerequisites for Installing from Development Source To install MySQL from a development source tree, your system must satisfy the tool requirements listed at ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-list.html
The chief difference between the two types of partitioning is that, in list partitioning, each partition is defined and selected based on the membership of a column value in one of a set of value lists, rather than in one of a set of contiguous ...
https://dev.mysql.com/doc/refman/5.7/en/string-comparison-functions.html
Normally, if any expression in a string comparison is case-sensitive, the comparison is performed in case-sensitive fashion. For more information about that option, see Section 4.5.1, “mysql — The MySQL Command-Line Client”. For example, it ...