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/replace-third-party-yum.html
For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can replace a third-party distribution of MySQL with the latest GA release (from the MySQL 5.7 series currently) ...
https://dev.mysql.com/doc/refman/5.7/en/derived-tables.html
A derived table is an expression that generates a table within the scope of a query FROM clause. For example, a subquery in a SELECT statement FROM clause is a derived table: SELECT ... The [AS] tbl_name clause is mandatory because every table in a ...
https://dev.mysql.com/doc/refman/5.7/en/temporary-files.html
The maximum disk space required is determined by the following expression: (length of what is sorted + sizeof(row pointer)) * number of matched rows * 2 The row pointer size is usually four bytes, but may grow in the future for really big tables.
https://dev.mysql.com/doc/refman/5.7/en/data-types.html
fsp applies to the TIME, DATETIME, and TIMESTAMP types and represents fractional seconds precision; that is, the number of digits following the decimal point for fractional parts of seconds. MySQL supports SQL data types in several categories: ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-setup-instruments-table.html
This in turn causes those values to be ignored when calculating the sum, minimum, maximum, and average time values in summary tables. The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT ...| statement/sql/load | YES | YES | | statement/sql/grant | YES | YES | | statement/sql/check | YES | YES | | statement/sql/flush | YES | YES | ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-conflict-resolution.html
The NDB$EPOCH() and NDB$EPOCH_TRANS() functions discussed later in this section work by comparing the relative order of replication epochs applied on a primary and secondary NDB Cluster, and do not make use of timestamps. Individual rows read on the ...Some types of conflict resolution supported by NDB Cluster (NDB$OLD(), NDB$MAX(), NDB$MAX_DELETE_WIN()) implement this user-defined column as a “timestamp” column (although its type cannot be TIMESTAMP, as explained later in this ... Requirements Source Column Control Conflict Resolution Control Conflict Resolution Functions Conflict Resolution Exceptions Table ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking.html
Example 2: A credit card processor company provides a set of services using sensitive data, such as: Processing a large number of financial transactions per second. Note MySQL Enterprise Data Masking and De-Identification is an extension included ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-metrics-table.html
(The _RESET columns act like the lap counter on a stopwatch: you can measure the activity during some time interval, while the cumulative figures are still available in COUNT, MAX_COUNT, and so on.) MAX_COUNT_RESET The maximum counter value since it ...row *************************** NAME: dml_inserts SUBSYSTEM: dml COUNT: 3 MAX_COUNT: 3 MIN_COUNT: NULL AVG_COUNT: 0.046153846153846156 COUNT_RESET: 3 MAX_COUNT_RESET: 3 MIN_COUNT_RESET: NULL AVG_COUNT_RESET: NULL TIME_ENABLED: 2014-12-04 14:18:28 TIME_DISABLED: NULL TIME_ELAPSED: 65 TIME_RESET: NULL STATUS: enabled TYPE: status_counter COMMENT: Number of rows inserted Notes You must have the PROCESS privilege to query this ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-howto.html
This is a “cold start” procedure that assumes either that you are starting the replication source server for the first time, or that it is possible to stop it; for information about provisioning replicas using GTIDs from a running source, see ...
https://dev.mysql.com/doc/refman/5.7/en/index-btree-hash.html
In the second statement, only rows with 'Pat' <= key_col < 'Pau' are considered. In the second statement, the LIKE value is not a constant. WHERE index_part1=1 OR index_part2=10 Sometimes MySQL does not use an index, even if one is available.