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-compression-usage.html
Compressed tables can be created in file-per-table tablespaces or in general tablespaces. The system tablespace (space 0, the .ibdata files) can contain user-created tables, but it also contains internal system data, which is never compressed.
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/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/create-table-generated-columns.html
As of MySQL 5.7.10, if expression evaluation causes truncation or provides incorrect input to a function, the CREATE TABLE statement terminates with an error and the DDL operation is rejected. If a generated column is indexed, the optimizer ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-overview.html
With modern disks, the mean time for this is usually lower than 10ms, so we can in theory do about 100 seeks a second. As you work on database performance, you start by learning the high-level rules and guidelines for the software side, and ...
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 ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-processlist-table.html
TIME The time in seconds that the thread has been in its current state. 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. The MySQL process list ...
https://dev.mysql.com/doc/refman/5.7/en/replication-rbr-safe-unsafe.html
When activated, this causes such warnings not to be written to the error log; instead, for each 50 warnings of this type, a note The last warning was repeated N times in last S seconds is written to the error log. Formerly, if a large number of such ...This continues as long as the 50 most recent such warnings were issued in 50 seconds or less; once the rate has decreased below this threshold, the warnings are once again logged ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-innodb-buffer-page-lru-table.html
ACCESS_TIME An abstract number used to judge the first access time of the page. This can be the name of a clustered index or a secondary index. Querying this table can require MySQL to allocate a large block of contiguous memory, more than 64 bytes ... The INNODB_BUFFER_PAGE_LRU table provides information about the pages in the InnoDB buffer pool; in particular, how they are ordered in the LRU list that determines which pages to evict from the buffer pool when it becomes ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-connection-attribute-tables.html
For connections initiated using the C API, the libmysqlclient library imposes a limit of 64KB on the aggregate size of connection attribute data on the client side: Calls to mysql_options() that cause this limit to be exceeded produce a ...For ...