PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-system-tables.html
This information comes from the InnoDB internal system tables (also referred to as the InnoDB data dictionary), which cannot be queried directly like regular InnoDB tables. Traditionally, you would get this type of information using the techniques ... You can extract metadata about schema objects managed by InnoDB using InnoDB INFORMATION_SCHEMA system ...
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-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/faqs-replication.html
The implication of this is that, at any given time, the replica is not guaranteed to be in synchrony with the source unless you take some special measures. (This is why TIMESTAMP is well replicated.) In the Time column in the output of SHOW ... In ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
This section describes limits on the number of columns in tables and the size of individual rows. The exact column limit depends on several factors: The maximum row size for a table constrains the number (and possibly size) of columns because the ...Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a given ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-file-reading.html
(This capability does not apply to log files written in other formats.) When the audit log plugin initializes and is configured for JSON logging, it uses the directory containing the current audit log file as the location to search for readable ...