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-thread_concurrency.html
Once the number of executing threads reaches this limit, additional threads sleep for a number of microseconds, set by the configuration parameter innodb_thread_sleep_delay, before being placed into the queue. If the tickets run out, the thread is ... InnoDB uses operating system threads to process requests from user ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-read-only-instance.html
Querying data that has been put into a read-only state for security or data integrity reasons, such as archived backup data. The instance must have performed a slow shutdown before being put into the read-only state. You can query InnoDB tables ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-row-format.html
As more rows fit into a single disk page, queries and index lookups can work faster, less cache memory is required in the buffer pool, and less I/O is required to write out updated values. The row format of a table determines how its rows are ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-standard-monitor.html
The Lock Monitor is the same as the Standard Monitor except that it includes additional lock information. Enabling either monitor for periodic output turns on the same output stream, but the stream includes extra information if the Lock Monitor is ...
https://dev.mysql.com/doc/refman/5.7/en/insert-optimization.html
To optimize insert speed, combine many small operations into a single large operation. Ideally, you make a single connection, send the data for many new rows at once, and delay all index updates and consistency checking until the very end. The size ...
https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
SELECT statements that select from and insert into the same table, MySQL creates an internal temporary table to hold the rows from the SELECT, then inserts those rows into the target table. In some cases, the server creates internal temporary ...
https://dev.mysql.com/doc/refman/5.7/en/json-search-functions.html
The functions in this section perform search operations on JSON values to extract data from them, report whether data exists at a location within them, or report the path to data within them. JSON_CONTAINS(target, candidate[, path]) Indicates by ...
https://dev.mysql.com/doc/refman/5.7/en/known-issues.html
When inserting a big integer value (between 263 and 264−1) into a decimal or string column, it is inserted as a negative value because the number is evaluated in signed integer context. SELECT statements that insert zero or NULL values into an ...
https://dev.mysql.com/doc/refman/5.7/en/loadable-function-reference.html
The following table lists each function that is loadable at runtime and provides a short description of each one. For a table listing built-in functions and operators, see Section 12.1, “Built-In Function and Operator Reference” For general ...
https://dev.mysql.com/doc/refman/5.7/en/locking-service.html
MySQL distributions provide a locking interface that is accessible at two levels: At the SQL level, as a set of loadable functions that each map onto calls to the service routines. As a C language interface, callable as a plugin service from server ...