PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
What character set should the server translate statements to after receiving them? To determine this, the server uses the character_set_connection and collation_connection system variables: The server converts statements sent by the client from ...
https://dev.mysql.com/doc/refman/5.7/en/get-diagnostics.html
If a statement raises multiple conditions, this part of the diagnostics area has a condition area for each one. If a statement raises no conditions, this part of the diagnostics area is empty. For a statement that produces three conditions, the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-limitations-transactions.html
This issue does not occur for queries that use index or table scans, even against NDB tables having BLOB or TEXT columns. To avoid modification of the index during this double-read operation, the row found in the hidden index table is locked. This ... A number of limitations exist in NDB Cluster with regard to the handling of ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-functions.html
(See also Section 16.4.1.8, “Replication of CURRENT_USER()”.) This is also true for VERSION() and RAND(). This means that the value as returned by the call to this function on the source is replicated to the replica. For this reason, if you ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
If this is true of the statement, we refer to the statement as safe; otherwise, we refer to it as unsafe. However, certain nondeterministic functions are not considered unsafe (see Nondeterministic functions not considered unsafe, later in this ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
This section describes the impact of an unexpected halt of a replica during replication, and how to configure a replica for the best chance of recovery to continue replication. In older MySQL Server versions, this repository could only be created as ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
It starts by pushing a diagnostics area to the top of the stack, which now looks like this: DA 1. ERROR 1051 (42S02): Unknown table 'xx' At this point, the contents of the first (current) and second (stacked) diagnostics areas are the same. SET is ...RESIGNAL may change some or all information before passing it ...
https://dev.mysql.com/doc/refman/5.7/en/index-condition-pushdown-optimization.html
If we know a person's zipcode value but are not sure about the last name, we can search like this: SELECT * FROM people WHERE zipcode='95054' AND lastname LIKE '%etrunia%' AND address LIKE '%Main Street%'; MySQL can use the index to scan through ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
This limits scalability when load increases, particularly for statement mixes that include writes. To enforce different size limits for MEMORY tables, change the value of this variable. You can set the size for individual tables as described later ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/5.7/en/column-indexes.html
Indexing only a prefix of column values in this way can make the index file much smaller. Take this into account when specifying a prefix length for a nonbinary string column that uses a multibyte character set. If a search term exceeds the index ...