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/merge-storage-engine.html
If you specify no INSERT_METHOD option or if you specify it with a value of NO, inserts into the MERGE table are not permitted and attempts to do so result in an error. The MERGE storage engine, also known as the MRG_MyISAM engine, is a collection ...
https://dev.mysql.com/doc/refman/5.7/en/repair-table.html
Table Repair Considerations REPAIR TABLE upgrades a table if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision) and the avoid_temporal_upgrade system variable ...Possible causes include but are not limited to file system ...[QUICK] [EXTENDED] [USE_FRM] REPAIR TABLE ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-txn.html
When a memcached operation inserts, updates, or deletes data in the underlying InnoDB table, the change might be committed to the InnoDB table instantly (if daemon_memcached_w_batch_size=1) or some time later (if the daemon_memcached_w_batch_size ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-reads.html
Here, LOCK IN SHARE MODE is not a good solution because if two users read the counter at the same time, at least one of them ends up in deadlock when it attempts to update the counter. If you query data and then insert or update related data within ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-index-stat.html
--connect-retries Command-Line Format --connect-retries=# Type Integer Default Value 12 Minimum Value 0 Maximum Value 12 Number of times to retry connection before giving up. --connect-retry-delay Command-Line Format --connect-retry-delay=# Type ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-redo-log-reader.html
Reads a redo log file, checking it for errors, printing its contents in a human-readable format, or both. Command-Line Format -mbyte # Type Numeric Default Value 0 Minimum Value 0 Maximum Value 15 -mbyte #: Starting megabyte. Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/data-size.html
Smaller tables normally require less main memory while their contents are being actively processed during query execution. With ROW_FORMAT=REDUNDANT, CHAR(N) occupies N × the maximum byte length of the character set. With the compact family of rows ... Design your tables to minimize their space on the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-preload-buffer-pool.html
In addition to saving the buffer pool state at shutdown and restoring it at startup, you can save and restore the buffer pool state at any time, while the server is running. If the operation is complete, the completion time is printed (e.g. If the ... To reduce the warmup period after restarting the server, InnoDB saves a percentage of the most recently used pages for each buffer pool at server shutdown and restores these pages at server ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
If the table name is close to the length limit for constraint names, the additional characters required for the constraint name may cause that name to exceed the limit, resulting in an error. The following table describes the maximum length for ...