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/sorted-index-builds.html
Reserving B-tree Page Space for Future Index Growth To set aside space for future index growth, you can use the innodb_fill_factor variable to reserve a percentage of B-tree page space. For example, setting innodb_fill_factor to 80 reserves 20 ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-general-options.html
--defaults-extra-file=file_name Command-Line Format --defaults-extra-file=file_name Type File name Read this option file after the global option file but (on Unix) before the user option file. The options described in this section can be used for ...The sections following this one describe options that pertain only to specific operations, such as table checking or ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 24.2 INFORMATION_SCHEMA General Tables Table Name Description CHARACTER_SETS Available character sets ...
https://dev.mysql.com/doc/refman/5.7/en/replication-channels.html
For instructions to configure sources and replicas for multi-source replication, to start, stop and reset multi-source replicas, and to monitor multi-source replication, see Section 16.1.5, “MySQL Multi-Source Replication”. This channel is ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-statistics-estimation.html
The auto-rehash feature enables automatic name completion of database, table, and column names for interactive users. The default setting for innodb_stats_on_metadata was changed to OFF when persistent optimizer statistics were enabled by default in ...For information about persistent optimizer statistics, see Section 14.8.11.1, “Configuring Persistent Optimizer Statistics ...Optimizer statistics ...
https://dev.mysql.com/doc/refman/5.7/en/plugin-loading.html
In the descriptions, plugin_name stands for a plugin name such as innodb, csv, or validate_password. The argument format is the same as for --plugin-load, but multiple instances of --plugin-load-add can be used to avoid specifying a large set of ...
https://dev.mysql.com/doc/refman/5.7/en/condition-filtering.html
Disable condition filtering for the session: SET optimizer_switch = 'condition_fanout_filter=off'; . To the extent that the optimizer can use information about conditions on rows selected from one table and passed to the next, the more accurately it ... In join processing, prefix rows are those rows passed from one table in a join to the ...
https://dev.mysql.com/doc/refman/5.7/en/numeric-type-attributes.html
MySQL supports an extension for optionally specifying the display width of integer data types in parentheses following the base keyword for the type. For example, INT(4) specifies an INT with a display width of four digits. This optional display ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
Even if you use lower_case_table_names=2 (which enables MySQL to remember the case used for databases and table names), MySQL does not remember the case used for database names for the function DATABASE() or within the various logs (on ...For ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-triggers-table.html
DEFINER The account named in the DEFINER clause (often the user who created the trigger), in 'user_name'@'host_name' format. To see information about a table's triggers, you must have the TRIGGER privilege for the table. TRIGGER_SCHEMA The name of ...The TRIGGERS table has these columns: TRIGGER_CATALOG The name of the catalog to which the trigger ...