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/archive-storage-engine.html
Attempting to create an index on any other column results in an error. ARCHIVE does not support inserting a value into an AUTO_INCREMENT column less than the current maximum column value. A bulk insert is visible only after it completes, unless ...
https://dev.mysql.com/doc/refman/5.7/en/commit.html
You cannot use ROLLBACK to undo the effect; however, if an error occurs during statement execution, the statement is rolled back. Important Many APIs used for writing MySQL client applications (such as JDBC) provide their own methods for starting ...
https://dev.mysql.com/doc/refman/5.7/en/subquery-materialization.html
Materialization speeds up query execution by generating a subquery result as a temporary table, normally in memory. The first time MySQL needs the subquery result, it materializes that result into a temporary table. Any subsequent time the result is ... The optimizer uses materialization to enable more efficient subquery ...
https://dev.mysql.com/doc/refman/5.7/en/binary-varbinary.html
If strict SQL mode is not enabled and you assign a value to a BINARY or VARBINARY column that exceeds the column's maximum length, the value is truncated to fit and a warning is generated. The permissible maximum length is the same for BINARY and ...
https://dev.mysql.com/doc/refman/5.7/en/creating-tables.html
Age changes as time passes, which means you'd have to update your records often. You want a table that contains a record for each of your pets. This can be called the pet table, and it should contain, as a bare minimum, each animal's name. Because ...
https://dev.mysql.com/doc/refman/5.7/en/function-optimization.html
For example: SELECT * FROM t WHERE partial_key=5 AND some_column=RAND(); If the optimizer can use partial_key to reduce the set of rows selected, RAND() is executed fewer times, which diminishes the effect of nondeterminism on optimization. The ...A ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
When this happens, query execution is quicker by the time needed to perform materialization. The optimizer handles derived tables and view references the same way: It avoids unnecessary materialization whenever possible, which enables pushing down ...(For an example, see Section 8.2.2.2, “Optimizing Subqueries with Materialization”.) If merging would result in an outer query block that references more than 61 base tables, the optimizer chooses materialization ...
https://dev.mysql.com/doc/refman/5.7/en/blackhole-storage-engine.html
In this scenario, replication fails with a duplicate entry error on the primary key column. The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. To examine the source for the BLACKHOLE ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema.html
The Performance Schema has these characteristics: The Performance Schema provides a way to inspect internal execution of the server at runtime. The MySQL Performance Schema is a feature for monitoring MySQL Server execution at a low level. An ...It ...
https://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
After using this value, be prepared to drop and recreate all secondary indexes. To investigate database page corruption, you might dump your tables from the database with SELECT ... Usually, most of the data obtained in this way is intact. Serious ...