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/views.html
Additional Resources You may find the MySQL User Forums helpful when working with views. Views are stored queries that when invoked produce a result set. The following discussion describes the syntax for creating and dropping views, and shows some ...There are some restrictions on the use of views; see Section 23.9, “Restrictions on ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-overview-requirements.html
Communication latency between these processes can directly affect the observed performance and latency of user queries. When setting timeout values such as HeartbeatIntervalDbDb and HeartbeatIntervalDbApi for NDB Cluster, care must be taken care to ... One of the strengths of NDB Cluster is that it can be run on commodity hardware and has no unusual requirements in this regard, other than for large amounts of RAM, due to the fact that all live data storage is done in ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-networking-issues.html
Also see Section 21.4.1, “Quick Test Setup of NDB Cluster”, for configuration examples using HostName with API nodes. We show an example of an NDB Cluster setup using such a physically segregated network here: Figure 21.9 NDB Cluster with ...It ... In this section, we discuss basic network security issues as they relate to NDB ...
https://dev.mysql.com/doc/refman/5.7/en/union.html
Use of ORDER BY for individual SELECT statements implies nothing about the order in which the rows appear in the final result because UNION by default produces an unordered set of rows. Therefore, ORDER BY in this context typically is used in ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-next-key-locking.html
InnoDB performs row-level locking in such a way that when it searches or scans a table index, it sets shared or exclusive locks on the index records it encounters. The so-called phantom problem occurs within a transaction when the same query ...Let ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-read_ahead.html
For example, if you set the value to 48, InnoDB triggers a linear read-ahead request only when 48 pages in the current extent have been accessed sequentially. Statistics include counter information for the following global status variables: ... A ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-timezone.html
Verify that your combination of settings for the system time zone (system_time_zone), server current time zone (the global value of time_zone), and per-session time zones (the session value of time_zone) on the source and replica is producing the ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-parameters-table.html
The PARAMETERS table provides information about parameters for stored routines (stored procedures and stored functions), and about return values for stored functions. Parameter information is similar to the contents of the param_list column in the ...The PARAMETERS table does not include built-in (native) functions or loadable ...
https://dev.mysql.com/doc/refman/5.7/en/statement-caching.html
Reparsing uses the default database and SQL mode that were in effect for the original conversion to internal form. For certain statements that a client might execute multiple times during a session, the server converts the statement to an internal ...The max_prepared_stmt_count system variable controls the total number of statements the server ...
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 ...