PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/index-statistics.html
This means that you can force a table's statistics to be regenerated with a given method without affecting other clients by setting the session value of myisam_stats_method. There is no way to tell which method was used to generate statistics for a ... Storage engines collect statistics about tables for use by the ...
https://dev.mysql.com/doc/refman/5.7/en/index.html
Including MySQL NDB Cluster 7.5 and NDB Cluster 7.6 Abstract This is the MySQL Reference Manual. It documents MySQL 5.7 through 5.7.52, as well as NDB Cluster releases based on version 7.5 of NDB through 5.7.44-ndb-7.5.36, respectively. It may ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-configuring-io-capacity.html
For systems with individual 5400 RPM or 7200 RPM drives, you might lower the value to 100, which represents an estimated proportion of the I/O operations per second (IOPS) available to older-generation disk drives that can perform about 100 IOPS.
https://dev.mysql.com/doc/refman/5.7/en/innodb-deadlock-example.html
As a result, InnoDB generates an error for one of the clients and releases its locks. The following example illustrates how an error can occur when a lock request causes a deadlock. First, client A creates a table containing one row, and then ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-locking-reads.html
In MySQL, the specific task of generating a unique identifier actually can be accomplished using only a single access to the table: UPDATE child_codes SET counter_field = LAST_INSERT_ID(counter_field + 1); SELECT LAST_INSERT_ID(); The SELECT ... If ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-tuning.html
It can also be used to generate sample key-value pairs to use in your own benchmarks. Because using InnoDB in combination with memcached involves writing all data to disk, whether immediately or sometime later, raw performance is expected to be ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-compression-oltp.html
If you are certain that the zlib version is not likely to change, disable innodb_log_compressed_pages to reduce redo log generation for workloads that modify compressed data. Traditionally, the InnoDB compression feature was recommended primarily ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-ro-txn.html
InnoDB can avoid the overhead associated with setting up the transaction ID (TRX_ID field) for transactions that are known to be read-only. A transaction ID is only needed for a transaction that might perform write operations or locking reads such ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-performance-spin_lock_polling.html
That number is generated by randomly selecting an integer ranging from 0 up to but not including the innodb_spin_wait_delay value, and multiplying that value by 50. InnoDB mutexes and rw-locks are typically reserved for short intervals. On a ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-temporary-tablespace.html
The temporary tablespace receives a dynamically generated space ID when it is created. Non-compressed, user-created temporary tables and on-disk internal temporary tables are created in a shared temporary tablespace. The innodb_temp_data_file_path ...