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-ndbinfo-cpustat-20sec.html
The cpustat_20sec table provides raw, per-thread CPU data obtained each 20 seconds, for each thread running in the NDB kernel. Like cpustat_50ms and cpustat_1sec, this table shows 20 measurement sets per thread, each referencing a period of the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html
For example, if a SELECT is executed twice, but returns a row the second time that was not returned the first time, the row is a “phantom” row. The so-called phantom problem occurs within a transaction when the same query produces different ...
https://dev.mysql.com/doc/refman/5.7/en/processlist-access.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. If a thread stays in a given state for many seconds, there might be a problem that needs to be ...
https://dev.mysql.com/doc/refman/5.7/en/using-system-variables.html
To restrict the maximum value to which a system variable can be set at runtime with the SET statement, specify this maximum by using an option of the form --maximum-var_name=value at server startup. For example, to prevent the value of ...The ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-max-allowed-packet.html
If you are replicating large column values (such as might be found in TEXT or BLOB columns) and max_allowed_packet is too small on the source, the source fails with an error, and the replica shuts down the replication I/O thread. max_allowed_packet ... max_allowed_packet sets an upper limit on the size of any single message between the MySQL server and clients, including ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-analyze-table-complexity.html
Using these parameters, an approximate formula for estimating ANALYZE TABLE complexity would be: The value of innodb_stats_persistent_sample_pages * number of indexed columns in a table * the number of partitions Typically, the greater the resulting ... ANALYZE TABLE complexity for InnoDB tables is dependent on: The number of pages sampled, as defined by ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cpustat-50ms.html
The cpustat_50ms table provides raw, per-thread CPU data obtained each 50 milliseconds for each thread running in the NDB kernel. Like cpustat_1sec and cpustat_20sec, this table shows 20 measurement sets per thread, each referencing a period of the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-cpustat.html
The cpustat table provides per-thread CPU statistics gathered each second, for each thread running in the NDB kernel.
https://dev.mysql.com/doc/refman/5.7/en/identifier-qualifiers.html
An unqualified name is permitted in contexts where interpretation of the name is unambiguous. A qualified name includes at least one qualifier to clarify the interpretive context by overriding a default context or providing missing context. For ...
https://dev.mysql.com/doc/refman/5.7/en/create-table-secondary-indexes.html
A secondary index defined on a virtual column is sometimes referred to as a “virtual index”. If a secondary index is not defined on a virtual column, there are additional costs for reads, as virtual column values must be computed each time the ...A secondary index may be created on one or more virtual columns or on a combination of virtual columns and regular columns or stored generated ...If the index is a covering index (one that includes all the ...