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/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/handler-scope.html
When a condition occurs in a stored program, the server searches for applicable handlers in the current scope (current BEGIN ... If there are no applicable handlers, the search continues outward with the handlers in each successive containing scope ... A stored program may include handlers to be invoked when certain conditions occur within the ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-table.html
To keep the index maintenance period to a reasonable time, set the innodb_ft_num_word_optimize option to specify how many words to update in the search index, and run a sequence of OPTIMIZE TABLE statements until the search index is fully updated.
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
To take advantage of this support manually, run mysql within a console that uses a compatible Unicode font and set the default character set to a Unicode character set that is supported for communication with the server: Open a console window. This ...Input-Line Editing Disabling Interactive History Unicode Support on Windows Displaying Query Results Vertically Using Safe-Updates Mode (--safe-updates) Disabling mysql Auto-Reconnect mysql Client Parser Versus Server Parser Input-Line Editing mysql supports input-line editing, which enables you to modify the current input line in place or recall previous input ...
https://dev.mysql.com/doc/refman/5.7/en/using-encrypted-connections.html
This section provides general guidance about configuring the server and clients for encrypted connections: Server-Side Startup Configuration for Encrypted Connections Client-Side Configuration for Encrypted Connections Configuring Encrypted ...
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 ...