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/memory-use.html
The InnoDB buffer pool is a memory area that holds cached InnoDB data for tables, indexes, and other auxiliary buffers. For each MyISAM table the server opens, the index file is opened once; the data file is opened once for each concurrently running ... MySQL allocates buffers and caches to improve performance of database ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-quick-start.html
If this engine is available (which you should already have checked earlier), you should see it listed with a SUPPORT value of YES in the output from the Information Schema ENGINES table or the SHOW ENGINES statement: mysql> SELECT * FROM ... This ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-lru-table.html
The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes full. The ...To avoid ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-table-reference.html
The following table summarizes INFORMATION_SCHEMA InnoDB tables. For greater detail, see the individual table descriptions. Table 24.3 INFORMATION_SCHEMA InnoDB Tables Table Name Description Deprecated INNODB_BUFFER_PAGE Pages in InnoDB buffer pool ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-file-format-compatibility-checking-table-access.html
When a table is first accessed, InnoDB (including some releases prior to InnoDB 1.0) checks that the file format of the tablespace in which the table is stored is fully supported. This check prevents crashes or corruptions that would otherwise ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-table-distribution-status.html
The table_distribution_status table provides information about the progress of table distribution for NDB tables. is_reorg_ongoing Whether table is currently being reorganized (1 if true) Notes The table_distribution_status table was added in NDB ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-privileges-table.html
The TABLE_PRIVILEGES table has these columns: GRANTEE The name of the account to which the privilege is granted, in 'user_name'@'host_name' format. TABLE_CATALOG The name of the catalog to which the table belongs. TABLE_SCHEMA The name of the schema ...The output does not list GRANT OPTION as a separate row with PRIVILEGE_TYPE='GRANT ...
https://dev.mysql.com/doc/refman/5.7/en/cost-model.html
These estimates are stored in the server_cost and engine_cost tables in the mysql system database and are configurable at any time. The intent of these tables is to make it possible to easily adjust the cost estimates that the optimizer uses when it ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
For example, DDL statements such as CREATE TABLE and ALTER TABLE are always logged as statements, without regard to the logging format in effect, so the following statement-based rules for --binlog-do-db always apply in determining whether or not ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
To use a row format other than DYNAMIC, configure innodb_default_row_format, or specify the ROW_FORMAT option explicitly in a CREATE TABLE or ALTER TABLE statement. Design your tables to minimize their space on the disk. Smaller tables normally ...