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/condition-filtering.html
Condition filtering enables the optimizer to use other relevant conditions in the WHERE clause not taken into account by the access method, and thus improve its prefix row count estimates. It was not already taken into account by the access method.
https://dev.mysql.com/doc/refman/5.7/en/cost-model.html
Cost Model General Operation The Cost Model Database Making Changes to the Cost Model Database Cost Model General Operation The configurable optimizer cost model works like this: The server reads the cost model tables into memory at startup and uses ... To generate execution plans, the optimizer uses a cost model that is based on estimates of the cost of various operations that occur during query ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
These trigger_event values are permitted: INSERT: The trigger activates whenever a new row is inserted into the table (for example, through INSERT, LOAD DATA, and REPLACE statements). For example, an INSERT trigger activates not only for INSERT ...
https://dev.mysql.com/doc/refman/5.7/en/create-view.html
This same principle applies to options such as ALL, DISTINCT, or SQL_SMALL_RESULT that follow the SELECT keyword, and to clauses such as INTO, FOR UPDATE, LOCK IN SHARE MODE, and PROCEDURE. If the view does not exist, CREATE OR REPLACE VIEW is the ...
https://dev.mysql.com/doc/refman/5.7/en/creating-ssl-files-using-openssl.html
Check that OpenSSL was correctly integrated into the Path variable by opening a new command console (Start>Run>cmd.exe) and verifying that OpenSSL is available: Microsoft Windows [Version ...] Copyright (c) 2006 Microsoft Corporation. This section ...
https://dev.mysql.com/doc/refman/5.7/en/csv-storage-engine.html
The CSV storage engine is always compiled into the MySQL server. When you store data into the table, the storage engine saves it into the data file in comma-separated values format. The CSV storage engine stores data in text files using ...
https://dev.mysql.com/doc/refman/5.7/en/cursors.html
Cursors have these properties: Asensitive: The server may or may not make a copy of its result table Read only: Not updatable Nonscrollable: Can be traversed only in one direction and cannot skip rows Cursor declarations must appear before handler ...
https://dev.mysql.com/doc/refman/5.7/en/data-type-defaults.html
When not using strict mode, only the third statement produces an error; the implicit default is inserted for the first two statements, but the third fails because DEFAULT(i) cannot produce a value: INSERT INTO t VALUES(); INSERT INTO t ... Data type ...
https://dev.mysql.com/doc/refman/5.7/en/displaying-traces.html
INTO DUMPFILE is preferable to INTO OUTFILE for this purpose, since the latter escapes newlines. As noted previously, you should ensure that end_markers_in_json is OFFwhen executing the SELECT INTO statement, so that the output is valid JSON.
https://dev.mysql.com/doc/refman/5.7/en/faqs-innodb-change-buffer.html
Buffered changes can be applied later, in batches, as pages are read into the buffer pool by other read operations. When does change buffer merging occur? When a page is read into the buffer pool, buffered changes are merged upon completion of the ...What types of operations modify secondary indexes and result in change buffering? ...