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/replication-features-transactions.html
However, when a second connection updates the nontransactional table before the first connection transaction is complete, statements can be logged out of order because the second connection update is written immediately after it is performed, ...In ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync.html
Fully synchronous replication means failover from the source to any replica is possible at any time. The source does not wait for all replicas to acknowledge receipt, and it requires only an acknowledgement from the replicas, not that the events ...
https://dev.mysql.com/doc/refman/5.7/en/switchable-optimizations.html
This variable has global and session values and can be changed at runtime. Command Syntax Meaning default Reset every optimization to its default value opt_name=default Set the named optimization to its default value opt_name=off Disable the named ...Its value is a set of flags, each of which has a value of on or off to indicate whether the corresponding optimizer behavior is enabled or ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-events-transactions-current-table.html
For discussion of picoseconds as the unit for event times and factors that affect time values, see Section 25.4.1, “Performance Schema Event Timing”. For example, the events_transactions_history and events_transactions_history_long tables are ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-subpartitions.html
Data and indexes belonging to p1's second subpartition (s1b) are stored on /disk5—the data in /disk5/data, and the indexes in /disk5/idx. Subpartitioning—also known as composite partitioning—is the further division of each partition in a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-optimization.html
Certain types of queries for INFORMATION_SCHEMA tables can be optimized to execute more quickly. For the second EXPLAIN output row: All COLUMNS table values are OPEN_FRM_ONLY lookups, so COLUMNS.TABLE_NAME requires the .frm file to be opened.
https://dev.mysql.com/doc/refman/5.7/en/out-of-range-and-overflow.html
When a floating-point or fixed-point column is assigned a value that exceeds the range implied by the specified (or default) precision and scale, MySQL stores the value representing the corresponding endpoint of that range. If strict SQL mode is ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-start-phases.html
This occurs either when the cluster started for the very first time, or when all data nodes are restarted using the --initial option. For an initial start or system restart, a local checkpoint is executed, followed by a global checkpoint. This ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-tp-thread-group-state-table.html
OLDEST_QUEUED How long in milliseconds the oldest queued statement has been waiting for execution. There is at most one thread ready to start executing if the active threads become stalled or blocked. There can be a maximum of four connection ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-spin_lock_polling.html
On a multi-core system, it can be more efficient for a thread to continuously check if it can acquire a mutex or rw-lock for a period of time before it sleeps. If the mutex or rw-lock becomes available during this period, the thread can continue ...