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-cluster-ndb-innodb-usage.html
When comparing application feature requirements to the capabilities of InnoDB with NDB, some are clearly more compatible with one storage engine than the other. The following table lists supported application features according to the storage ...
https://dev.mysql.com/doc/refman/5.7/en/sys-latest-file-io.html
These views summarize file I/O activity, grouped by file and thread. The latest_file_io and x$latest_file_io views have these columns: thread For foreground threads, the account associated with the thread (and port number for TCP/IP connections).
https://dev.mysql.com/doc/refman/5.7/en/installing-source-distribution.html
If you have multiple source trees at the same level (for example, to build multiple versions of MySQL), the second strategy can be advantageous. With the second strategy, you can use the same name for the build directory within each source tree. To ...
https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-many-tables.html
If you have configured non-persistent optimizer statistics (a non-default configuration), InnoDB computes index cardinality values for a table the first time that table is accessed after startup, instead of storing such values in the table. This ...
https://dev.mysql.com/doc/refman/5.7/en/replication-sbr-rbr.html
If there is an error in evaluation on the replica, particularly when executing complex statements, statement-based replication may slowly increase the margin of error across the affected rows over time. For complex statements, the statement must be ...For most users, the mixed replication format should provide the best combination of data integrity and ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-installer-setup.html
Choosing a Setup Type Path Conflicts Check Requirements MySQL Installer Configuration Files When you download MySQL Installer for the first time, a setup wizard guides you through the initial installation of MySQL products. As the following figure ...MySQL Installer detects existing MySQL products installed on the host during its initial setup and adds them to the list of products to be ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-management-exchange.html
The following example compares the difference between execution times when exchanging a partition with a nonpartitioned table, with and without validation. Exchanging Partitions Without Row-By-Row Validation To avoid time consuming validation when ...Table nt contains no foreign key references, and no other table has any foreign keys that refer to ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-replication-applier-configuration-table.html
Parameters stored in the table can be changed at runtime with the CHANGE MASTER TO statement, as indicated in the column descriptions. DESIRED_DELAY The number of seconds that the replica must lag the source. This table shows the configuration ...
https://dev.mysql.com/doc/refman/5.7/en/upgrade-binary-package.html
For example: mysql -u root -p --execute="SET GLOBAL innodb_fast_shutdown=0" With a slow shutdown, InnoDB performs a full purge and change buffer merge before shutting down, which ensures that data files are fully prepared in case of file format ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication.html
This section explains how to set up and manage a configuration in which one group of computers operating as an NDB Cluster replicates to a second computer or group of computers. For information about performing point-in-time recovery with NDB ...