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/sys-schema-table-statistics.html
total_latency The total wait time of timed I/O events for the table. fetch_latency The total wait time of timed read I/O events for the table. insert_latency The total wait time of timed insert I/O events for the table. update_latency The total wait ...By default, rows are sorted by descending total wait time (tables with most contention ...
https://dev.mysql.com/doc/refman/5.7/en/regexp.html
(Unless the NO_BACKSLASH_ESCAPES SQL mode is enabled, in which case no escape character is used.) Regular expression operations use the character set and collation of the string expression and pattern arguments when deciding the type of a character ... Table 12.14 Regular Expression Functions and Operators Name Description NOT REGEXP Negation of REGEXP REGEXP Whether string matches regular expression RLIKE Whether string matches regular expression A regular expression is a powerful way of specifying a pattern for a complex ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-params-other.html
The listings in this section provide information about parameters used in the [computer], [tcp], and [shm] sections of a config.ini file for configuring NDB Cluster. For detailed descriptions and additional information about individual parameters, ...The following parameters apply to the config.ini file's [computer] section: HostName: Host name or IP address of this ...
https://dev.mysql.com/doc/refman/5.7/en/replication.html
There are a number of solutions available for setting up replication between servers, and the best method to use depends on the presence of data and the engine types you are using. For more information on the available options, see Section 16.1.2, ... Replication enables data from one MySQL database server (the source) to be copied to one or more MySQL database servers (the ...
https://dev.mysql.com/doc/refman/5.7/en/fulltext-search-ngram.html
Typically, ngram_token_size is set to the size of the largest token that you want to search for. If you only intend to search for single characters, set ngram_token_size to 1. If you need to search for words comprised of more than one character, set ...The ngram full-text parser is supported for use with InnoDB and ... The built-in MySQL full-text parser uses the white space between words as a delimiter to determine where words begin and end, which is a limitation ...
https://dev.mysql.com/doc/refman/5.7/en/gis-linestring-property-functions.html
mysql> SET @ls = 'LineString(1 1,2 2,3 3)'; mysql> SELECT ST_AsText(ST_EndPoint(ST_GeomFromText(@ls))); +----------------------------------------------+ | ST_AsText(ST_EndPoint(ST_GeomFromText(@ls))) | ...You can extract particular points of a ...
https://dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
If column b is also unique, the INSERT is equivalent to this UPDATE statement instead: UPDATE t1 SET c=c+1 WHERE a=1 OR b=2 LIMIT 1; If a=1 OR b=2 matches several rows, only one row is updated. With ON DUPLICATE KEY UPDATE, the affected-rows value ... If you specify an ON DUPLICATE KEY UPDATE clause and a row to be inserted would cause a duplicate value in a UNIQUE index or PRIMARY KEY, an UPDATE of the old row ...
https://dev.mysql.com/doc/refman/5.7/en/myisamchk-repair-options.html
--set-collation=name Command-Line Format --set-collation=name Type String Specify the collation to use for sorting table indexes. --tmpdir can be set to a list of directory paths that are used successively in round-robin fashion for creating ...See ...
https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html
If any geometry argument is not a syntactically well-formed geometry byte string, an ER_GIS_INVALID_DATA error occurs. The only valid empty geometry is represented in the form of an empty geometry collection value. ST_IsValid() works only for the ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-defining.html
For example, the following stored procedure has a body made up of a BEGIN ... The following example shows how to do this for the dorepeat() procedure just shown. The delimiter is changed to // to enable the entire definition to be passed to the ...