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/mysql-installer-workflow.html
When all tokens resolve as valid (green text without an X icon), you can click OK to save the changes. Click Add User or Group to add the custom user and then click OK in each dialog to save the changes. MySQL Installer provides a wizard-like tool ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-what-is-new-7-6.html
It is now no longer strictly necessary for LCPs to do this—instead, an LCP now by default saves only a number of records that is based on the quantity of data changed since the previous LCP. This saves both the data nodes and the SPJ block from ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-data-encryption.html
Each time the master encryption key is rotated, all tablespace keys in the MySQL instance are re-encrypted and saved back to their respective tablespace headers. InnoDB then re-encrypts the tablespace key using the new master encryption key and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
The row format of a table determines how its rows are physically stored, which in turn can affect the performance of queries and DML operations. As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory ...The pages that make up each table are arranged in a tree data structure called a B-tree ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-size-pl.html
This is a Perl script that can be used to estimate the amount of space that would be required by a MySQL database if it were converted to use the NDBCLUSTER storage engine. Unlike the other utilities discussed in this section, it does not require ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-binary-log.html
In a normal shutdown, the set of GTIDs from the current binary log file is saved in the mysql.gtid_executed table. However, it is not strictly necessary to include every column in both images, and we can often save disk, memory, and network usage by ... Startup Options Used with Binary Logging System Variables Used with Binary Logging You can use the mysqld options and system variables that are described in this section to affect the operation of the binary log as well as to control which statements are written to the binary ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-restrictions.html
Results for queries that refer to tables in the performance_schema database are not saved in the query cache. If you save event information in another table, you should not assume that the original events are still available later. The Performance ...
https://dev.mysql.com/doc/refman/5.7/en/backup-types.html
Logical backups save information represented as logical database structure (CREATE DATABASE, CREATE TABLE statements) and content (INSERT statements or delimited-text files). Output is larger than for physical backup, particularly when saved in text ... This section describes the characteristics of different types of ...
https://dev.mysql.com/doc/refman/5.7/en/bnl-bka-optimization.html
For information about semijoin strategies, see Section 8.2.2.1, “Optimizing Subqueries, Derived Tables, and View References with Semijoin Transformations” Block Nested-Loop Algorithm for Outer Joins and Semijoins The original implementation of ... In MySQL, a Batched Key Access (BKA) Join algorithm is available that uses both index access to the joined table and a join ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] DO event_body; schedule: { AT timestamp [+ INTERVAL interval] ... The event does ...