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-performance-midpoint_insertion.html
The goal is to make sure that frequently accessed (“hot”) pages remain in the buffer pool, even as read-ahead and full table scans bring in new blocks that might or might not be accessed afterward. Rather than using a strict LRU algorithm, ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-thread_concurrency.html
(Transactions may issue many requests to InnoDB before they commit or roll back.) On modern operating systems and servers with multi-core processors, where context switching is efficient, most workloads run well without any limit on the number of ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-temporary-tablespace.html
For example: [mysqld] innodb_temp_data_file_path=ibtmp1:12M:autoextend:max:500M When the data file reaches the maximum size, queries fail with an error indicating that the table is full. Non-compressed, user-created temporary tables and on-disk ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-undo-logs.html
For example, a transaction that performs INSERT, UPDATE, and DELETE operations on regular and temporary tables requires a full assignment of four undo logs. An undo log is a collection of undo log records associated with a single read-write ...
https://dev.mysql.com/doc/refman/5.7/en/key-space.html
Space compression makes the index file smaller than the worst-case figure if a string column has a lot of trailing space or is a VARCHAR column that is not always used to the full length. You can roughly calculate the size for the index file as ...
https://dev.mysql.com/doc/refman/5.7/en/keyring-key-migration.html
The migration server expects path name option values to be full paths. A keyring migration copies keys from one keystore to another, enabling a DBA to switch a MySQL installation to a different keystore. A successful migration operation has this ...
https://dev.mysql.com/doc/refman/5.7/en/kill.html
If the thread is waiting for free disk space in a write call, the write is aborted with a “disk full” error message. KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate thread. Thread processlist identifiers ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld-compiling.html
You can get the full list of libraries by executing mysql_config --libmysqld-libs. In precompiled binary MySQL distributions that include libmysqld, the embedded server library, MySQL builds the library using the appropriate vendor compiler if ...
https://dev.mysql.com/doc/refman/5.7/en/libmysqld.html
The embedded MySQL server library makes it possible to run a full-featured MySQL server inside a client application. The main benefits are increased speed and more simple management for embedded applications. Note The libmysqld embedded server ...
https://dev.mysql.com/doc/refman/5.7/en/limit-optimization.html
MySQL sometimes optimizes a query that has a LIMIT row_count clause and no HAVING clause: If you select only a few rows with LIMIT, MySQL uses indexes in some cases when normally it would prefer to do a full table scan. If you need only a specified ...