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/innodb-file-format.html
InnoDB file format settings do not apply to tables stored in general tablespaces. As InnoDB evolves, data file formats that are not compatible with prior versions of InnoDB are sometimes required to support new features. To help manage ...Now that ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-issues.html
For example, start mysqld with the --max-seeks-for-key=1000 option or use SET max_seeks_for_key=1000 to tell the optimizer to assume that no key scan causes more than 1,000 key seeks. In many cases, MySQL can calculate the best possible query plan, ... MySQL uses a cost-based optimizer to determine the best way to resolve a ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-storage-layout.html
When using COMPACT row format (the default InnoDB format) and variable-length character sets, such as utf8 or sjis, CHAR(N) columns occupy a variable amount of space, but still at least N bytes. The reorganized tables require less disk I/O to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-instrumentation-checking.html
It is always possible to determine what instruments the Performance Schema includes by checking the setup_instruments table. Changes to this code occur often, which also affects the set of instruments. As described earlier, it is possible to find ...It is not practical to list all the instruments because there are hundreds of ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-session-account-connect-attrs-table.html
For descriptions of common attributes, see Section 25.12.9, “Performance Schema Connection Attribute Tables”. The session_account_connect_attrs table contains connection attributes only for the current session, and other sessions associated with ... Application programs can provide key-value connection attributes to be passed to the server at connect ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-session-connect-attrs-table.html
For descriptions of common attributes, see Section 25.12.9, “Performance Schema Connection Attribute Tables”. To see connection attributes only for the current session, and other sessions associated with the session account, use the ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-binlog.html
The source of information for point-in-time recovery is the set of binary log files generated subsequent to the full backup operation. This section explains the general idea of using the binary log to perform a point-in-time-recovery. Therefore, to ...The next section, Section 7.5.2, “Point-in-Time Recovery Using Event Positions”, explains the operation in details with an ...
https://dev.mysql.com/doc/refman/5.7/en/scalar-subqueries.html
In its simplest form, a subquery is a scalar subquery that returns a single value. For the subquery just shown, if t1 were empty, the result would be NULL even though s2 is NOT NULL. For example, LIMIT requires literal integer arguments, and LOAD ...A scalar subquery is a simple operand, and you can use it almost anywhere a single column value or literal is legal, and you can expect it to have those characteristics that all operands have: a data type, a length, an indication that it can be NULL, and so ...
https://dev.mysql.com/doc/refman/5.7/en/statement-labels.html
[begin_label:] BEGIN [statement_list] END [end_label] [begin_label:] LOOP statement_list END LOOP [end_label] [begin_label:] REPEAT statement_list UNTIL search_condition END REPEAT [end_label] [begin_label:] WHILE search_condition DO statement_list ...If end_label is present, it must be the same as ...
https://dev.mysql.com/doc/refman/5.7/en/version-tokens-installation.html
For general information about installing or uninstalling plugins and loadable functions, see Section 5.5.1, “Installing and Uninstalling Plugins”, and Section 5.6.1, “Installing and Uninstalling Loadable Functions”. If necessary, configure ...To avoid this overhead, do not install it unless you plan to use ...