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/monitor-alter-table-performance-schema.html
In order of occurrence, ALTER TABLE stage events include: stage/innodb/alter table (read PK and internal sort): This stage is active when ALTER TABLE is in the reading-primary-key phase. stage/innodb/alter table (merge sort): This stage is repeated ... You can monitor ALTER TABLE progress for InnoDB tables using Performance ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-mgm.html
Advanced users can also employ this API for programming dedicated management processes to perform tasks similar to those performed by ndb_mgm. --connect-retries=# Command-Line Format --connect-retries=# Type Numeric Default Value 3 Minimum Value 0 ... The ndb_mgm management client process is actually not needed to run the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-all.html
This option can be used only in conjunction with the -o (--order) option. --gci64 Adds a ROW$GCI64 column to the output showing the global checkpoint at which each row was last updated, as well as the number of the epoch in which this update ...
https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html
For example: $> mysql -u francis -pfrank db_name Warning This is convenient but insecure. Also, on some systems this overwriting strategy is ineffective and the password remains visible to ps. In this case, the client program solicits the password ... MySQL users should use the following guidelines to keep passwords ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
To work around this limitation, you can use a UNION with identical SELECT statements, except that you put each spatial predicate in a different SELECT. This means that the interval can be produced only for conditions in the following form: key_part1 ... The range access method uses a single index to retrieve a subset of table rows that are contained within one or several index value ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-partitioning.html
A sample of this layout is shown in Figure 16.2, “Replicating Databases to Separate Replicas”. Figure 16.2 Replicating Databases to Separate Replicas You can achieve this separation by configuring the source and replicas as normal, and then ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-tuning.html
This section provides guidelines on setting thread pool system variables for best performance, measured using a metric such as transactions per second. This is done by means of a timeout that can be tuned using the thread_pool_stall_limit system ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-index-types.html
InnoDB uses this primary key value to search for the row in the clustered index. How the Clustered Index Speeds Up Queries Accessing a row through the clustered index is fast because the index search leads directly to the page that contains the row ... Each InnoDB table has a special index called the clustered index that stores row ...
https://dev.mysql.com/doc/refman/5.7/en/encrypted-connections.html
Any data encrypted using this public key can be decrypted only using the corresponding secret key, which is held by the owner of the certificate. This enables you to choose an encrypted or unencrypted connection according to the requirements of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-persistent-stats.html
In this case innodb_stats_persistent_sample_pages should be decreased until ANALYZE TABLE execution time is acceptable. To avoid this scenario, innodb_stats_include_delete_marked can be enabled to ensure that delete-marked records are included when ... The persistent optimizer statistics feature improves plan stability by storing statistics to disk and making them persistent across server restarts so that the optimizer is more likely to make consistent choices each time for a given ...