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/sys-ps-is-instrument-default-timed.html
Example mysql> SELECT sys.ps_is_instrument_default_timed('memory/innodb/row_log_buf'); +-----------------------------------------------------------------+ | sys.ps_is_instrument_default_timed('memory/innodb/row_log_buf') | ... Returns YES or NO to ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-files.html
InnoDB non-compressed, user-created temporary tables and on-disk internal temporary tables are created in a temporary tablespace file named ibtmp1 in the MySQL data directory. On Unix, MySQL uses the value of the TMPDIR environment variable as the ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-operation.html
Thus, given a mix of statements for InnoDB and MyISAM tables, the thread pool prioritizes those for InnoDB over those for MyISAM unless autocommit is enabled. The thread pool consists of a number of thread groups, each of which manages a set of ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-tuning.html
Our experience in testing the thread pool indicates the following: If the primary storage engine is InnoDB, the optimal thread_pool_size setting is likely to be between 16 and 36, with the most common optimal values tending to be from 24 to 36. For ... This section provides guidelines on setting thread pool system variables for best performance, measured using a metric such as transactions per ...
https://dev.mysql.com/doc/refman/5.7/en/update.html
If you use a multiple-table UPDATE statement involving InnoDB tables for which there are foreign key constraints, the MySQL optimizer might process tables in an order that differs from that of their parent/child relationship. Instead, update a ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
If the instance unexpectedly shutdown, then restart the instance and shut it down with innodb_fast_shutdown=0 before upgrade. To perform an in-place upgrade: If you use XA transactions with InnoDB, run XA RECOVER before upgrading to check for ...
https://dev.mysql.com/doc/refman/5.7/en/xa-restrictions.html
XA transaction support is limited to the InnoDB storage engine. The implementation of internal XA requires that a storage engine support two-phase commit at the table handler level, and currently this is true only for InnoDB. For “external XA,” ...
https://dev.mysql.com/doc/refman/5.7/en/alter-table-generated-columns.html
ALTER TABLE operations permitted for generated columns are ADD, MODIFY, and CHANGE. CREATE TABLE t1 (c1 INT); ALTER TABLE t1 ADD COLUMN c2 INT GENERATED ALWAYS AS (c1 + 1) STORED; The data type and expression of generated columns can be modified.
https://dev.mysql.com/doc/refman/5.7/en/alter-table-problems.html
This is done because InnoDB and these operating systems cannot drop a table that is in use. If you get a duplicate-key error when using ALTER TABLE to change the character set or collation of a character column, the cause is either that the new ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
The tables use the InnoDB storage engine (MyISAM prior to MySQL 5.7.21). Unless those objects are installed, the audit_log plugin operates in legacy mode. Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for ...