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/partitioning-pruning.html
Pruning can also be applied to short ranges, which the optimizer can convert into equivalent lists of values. The core concept behind partition pruning is relatively simple, and can be described as “Do not scan partitions where there can be no ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-thread-filtering.html
The threads table contains a row for each server thread. Each row contains information about a thread and indicates whether monitoring is enabled for it. For the Performance Schema to monitor a thread, these things must be true: The ...
https://dev.mysql.com/doc/refman/5.7/en/precision-math-rounding.html
This section discusses precision math rounding for the ROUND() function and for inserts into columns with exact-value types (DECIMAL and integer). The ROUND() function rounds differently depending on whether its argument is exact or approximate: ...
https://dev.mysql.com/doc/refman/5.7/en/problems-with-float.html
Suppose that you execute the following statements: CREATE TABLE t1(c1 FLOAT(53,0), c2 FLOAT(53,0)); INSERT INTO t1 VALUES('1e+52','-1e+52'); SELECT * FROM t1; On some platforms, the SELECT statement returns inf and -inf. An implication of the ...
https://dev.mysql.com/doc/refman/5.7/en/programs-overview.html
mysqldump A client that dumps a MySQL database into a file as SQL, text, or XML. mysqlimport A client that imports text files into their respective tables using LOAD DATA. mysqlpump A client that dumps a MySQL database into a file as SQL. Later ...
https://dev.mysql.com/doc/refman/5.7/en/range-optimization.html
Otherwise, any index on col_name is nonunique and the optimizer can estimate the row count for each range using dives into the index or index statistics. The idea is that if index use is forced, there is nothing to be gained from the additional ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-concepts.html
A range of GTIDs originating from the same server can be collapsed into a single expression, as shown here: 3E11FA47-71CA-11E1-9E33-C80AA9429562:1-5 The above example represents the first through fifth transactions originating on the MySQL server ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-replica.html
When the replication SQL thread replicates a LOAD DATA statement, it extracts the file to be loaded from the relay log into temporary files, and then loads these into the table. This value is only appropriate if data is partitioned into multiple ...
https://dev.mysql.com/doc/refman/5.7/en/replication-setup-replicas.html
This method can also be used if you are setting up new servers but have an existing dump of the databases from a different server that you want to load into your replication configuration. By loading the data into a new source, the data is ...Before ...
https://dev.mysql.com/doc/refman/5.7/en/request-access.html
This is where the privilege columns in the grant tables come into play. A '%' or blank Host value means “any host.” A '%' or blank Db value means “any database.” The server reads the db table into memory and sorts it at the same time that it ... After the server accepts a connection, it enters Stage 2 of access ...