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/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/information-schema-statistics-table.html
However, prefix lengths for index specifications in CREATE TABLE, ALTER TABLE, and CREATE INDEX statements are interpreted as number of characters for nonbinary string types (CHAR, VARCHAR, TEXT) and number of bytes for binary string types (BINARY, ...The STATISTICS table has these columns: TABLE_CATALOG The name of the catalog to which the table containing the index ...
https://dev.mysql.com/doc/refman/5.7/en/extensions-to-ansi.html
(Nevertheless, it is preferable to use RENAME TABLE or ALTER TABLE ... Use of CHANGE col_name, DROP col_name, or DROP INDEX, IGNORE or RENAME in ALTER TABLE statements. Use of multiple ADD, ALTER, DROP, or CHANGE clauses in an ALTER TABLE statement.
https://dev.mysql.com/doc/refman/5.7/en/innodb-compression-tuning-monitoring.html
This section builds on the performance tuning advice from Section 14.9.1.3, “Tuning Compression for InnoDB Tables”, and shows how to find problems that might not turn up during initial testing. To dig deeper into performance considerations for ... 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/added-deprecated-removed.html
innodb_tmpdir: Directory location for temporary table files created during online ALTER TABLE operations. disable-partition-engine-check: Whether to disable startup check for tables without native partitioning. group_replication_recovery_ssl_cert: ... Options and Variables Introduced in MySQL 5.7 Options and Variables Deprecated in MySQL 5.7 Options and Variables Removed in MySQL 5.7 This section lists server variables, status variables, and options that were added for the first time, have been deprecated, or have been removed in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-cmpmem-table.html
The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables provide status information on compressed pages within the InnoDB buffer pool. The INNODB_CMPMEM and INNODB_CMPMEM_RESET tables have these columns: PAGE_SIZE The block size in bytes. row ...PAGES_USED ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-events-table.html
The EVENTS table provides information about Event Manager events, which are discussed in Section 23.4, “Using the Event Scheduler”. The EVENTS table has these columns: EVENT_CATALOG The name of the catalog to which the event belongs. EXECUTE_AT ...EVENT_SCHEMA The name of the schema (database) to which the event ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-queries-myisam.html
Some general tips for speeding up queries on MyISAM tables: To help MySQL better optimize queries, use ANALYZE TABLE or run myisamchk --analyze on a table after it has been loaded with data. (For unique indexes, this is always 1.) MySQL uses this ...This updates a value for each index part that indicates the average number of rows that have the same ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-temptables.html
The discussion in the following paragraphs does not apply when binlog_format=ROW because, in that case, temporary tables are not replicated; this means that there are never any temporary tables on the replica to be lost in the event of an unplanned ...The remainder of this section applies only when using statement-based or mixed-format ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-range.html
At some point in the future—when the number of stores has increased to 25, 30, or more—you can use an ALTER TABLE statement to add new partitions for stores 21-25, 26-30, and so on (see Section 22.3, “Partition Management”, for details of ...