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/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 ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs.html
Updates to the replica's applier metadata repository table are committed together with the transactions, meaning that the replica's progress information recorded in that repository is always consistent with what has been applied to the database, ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-rawdata.html
If the MySQL server is still running, background tasks may still be updating the database files, particularly those involving storage engines with background processes such as InnoDB. For example, assuming that the data directory is located under ...