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/nested-loop-joins.html
For example, if 10 rows are read into a buffer and the buffer is passed to the next inner loop, each row read in the inner loop can be compared against all 10 rows in the buffer. A join buffer is never allocated for the first nonconstant table, even ... MySQL executes joins between tables using a nested-loop algorithm or variations on ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-myisam-bulk-data-loading.html
These performance tips supplement the general guidelines for fast inserts in Section 8.2.4.1, “Optimizing INSERT Statements”. For a MyISAM table, you can use concurrent inserts to add rows at the same time that SELECT statements are running, if ...Use the following procedure: Execute a FLUSH TABLES statement or a mysqladmin flush-tables ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-socket-instances-table.html
Information available in this table provides a real-time snapshot of the active connections to the server. (Additional information is available in socket summary tables, including network activity such as socket operations and number of bytes ...
https://dev.mysql.com/doc/refman/5.7/en/keyring.html
MySQL Server supports a keyring that enables internal server components and plugins to securely store sensitive information for later retrieval. keyring_encrypted_file: Stores keyring data in an encrypted, password-protected file local to the ...
https://dev.mysql.com/doc/refman/5.7/en/view-check-option.html
The WITH CHECK OPTION clause can be given for an updatable view to prevent inserts to rows for which the WHERE clause in the select_statement is not true. It also prevents updates to rows for which the WHERE clause is true but the update would ...
https://dev.mysql.com/doc/refman/5.7/en/replication-snapshot-method.html
For more information, see Section 4.5.4, “mysqldump — A Database Backup Program”. For InnoDB, all tables in all databases are stored in the system tablespace files, unless you have the innodb_file_per_table option enabled. The following files ... If the database on the source contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/5.7/en/install-plugin.html
For example, set its value in a my.cnf file: [mysqld] plugin_dir=/path/to/plugin/directory If the value of plugin_dir is a relative path name, it is taken to be relative to the MySQL base directory (the value of the basedir system variable). A ...It ... INSTALL PLUGIN plugin_name SONAME 'shared_library_name' This statement installs a server ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-instruments-table.html
The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments; +---------------------------------------------------+---------+-------+ | NAME | ENABLED ...| wait/io/file/sql/binlog | YES | YES | | wait/io/file/sql/binlog_index | YES | YES | | wait/io/file/sql/casetest | YES | YES | | wait/io/file/sql/dbopt | YES | YES | ...
https://dev.mysql.com/doc/refman/5.7/en/replica-sql-thread-states.html
Making temporary file (create) before replaying LOAD DATA INFILE The thread is executing a LOAD DATA statement and is creating a temporary file containing the data from which the replica reads rows. Slave has read all relay log; waiting for more ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-multi-versioning.html
Internally, InnoDB adds three fields to each row stored in the database: A 6-byte DB_TRX_ID field indicates the transaction identifier for the last transaction that inserted or updated the row. Update undo logs are used also in consistent reads, but ...It keeps information about old versions of changed rows to support transactional features such as concurrency and ...