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/innodb-configuring-io-capacity.html
Configuring an I/O Capacity Maximum If flushing activity falls behind, InnoDB can flush more aggressively, at a higher rate of I/O operations per second (IOPS) than defined by the innodb_io_capacity variable. The InnoDB master thread and other ...
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/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/password-security-user.html
On Unix, the mysql client writes a record of executed statements to a history file (see Section 4.5.1.3, “mysql Client Logging”). MySQL users should use the following guidelines to keep passwords secure. When you run a client program to connect ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-columns-list.html
This is a variant of LIST partitioning that enables the use of multiple columns as partition keys, and for columns of data types other than integer types to be used as partitioning columns; you can use string types, DATE, and DATETIME columns. In ...
https://dev.mysql.com/doc/refman/5.7/en/processlist-access.html
For a replica SQL thread, the value is the number of seconds between the timestamp of the last replicated event and the real time of the replica host. If a thread stays in a given state for many seconds, there might be a problem that needs to be ...
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/group-replication-summary.html
A replication group is formed by multiple servers and each server in the group may execute transactions independently at any time. However, there may be conflicts between transactions that execute concurrently on different servers. During ... Group ...
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 ...