PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-transaction-tables.html
The setup_timers table contains a row with a NAME value of transaction that indicates the unit for transaction event timing. The cost of transaction instrumentation can be reduced various ways, such as enabling or disabling transaction ...These ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-mgm-definition.html
(NDB 7.5.0) This refers to the Id set for one of the computers defined in a [computer] section of the config.ini file. Normally, the management server should be configured as an arbitrator by setting its ArbitrationRank to 1 (the default for ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-shm-definition.html
For optimum performance, you can define a spin time for the SHM transporter (ShmSpinTime parameter); this affects both the data node receiver thread and the poll owner (receive thread or user thread) in NDB. You can enable a shared memory connection ...The shared-memory transporter (SHM) can improve performance by negating up to 20% of the overhead required by a TCP connection when running an API node (usually an SQL node) and a data node together on the same ...
https://dev.mysql.com/doc/refman/5.7/en/using-systemd.html
In other cases, the error log directory must be writable or the error log must be present and writable for the user running the mysqld process. Arrange for systemd to set environment variables for the MySQL server process. For example: [Service] ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-information-schema-internal-data.html
Because InnoDB must temporarily stall while the transaction and locking data is collected, too frequent queries of these tables can negatively impact performance as seen by other users. As these tables contain sensitive information (at least ...This ...For performance reasons, and to minimize the chance of misleading joins between the transaction and locking tables, InnoDB collects the required transaction and locking information into an intermediate buffer whenever a SELECT on any of the tables is ...
https://dev.mysql.com/doc/refman/5.7/en/locking-functions.html
The OBJECT_TYPE column says USER LEVEL LOCK and the OBJECT_NAME column indicates the lock name. When this happens, the server chooses a caller and terminates its lock-acquisition request with an ER_USER_LOCK_DEADLOCK error. A warning is logged if ...
https://dev.mysql.com/doc/refman/5.7/en/binary-varbinary.html
Instead, it causes the binary (_bin) collation for the column character set (or the table default character set if no column character set is specified) to be used, and the column itself stores nonbinary character strings rather than binary byte ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-memcached-txn.html
As you gain experience using the daemon_memcached plugin, you can consider relaxing durability settings for non-critical classes of data, at the risk of losing some updated values in the event of an outage, or returning data that is slightly ...By ...
https://dev.mysql.com/doc/refman/5.7/en/diagnostics-area.html
The following discussion describes the structure of the diagnostics area in MySQL, the information items recognized by MySQL, how statements clear and set the diagnostics area, and how diagnostics areas are pushed to and popped from the stack. If a ... SQL statements produce diagnostic information that populates the diagnostics ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-requirements.html
You can prevent the use of other storage engines by setting the disabled_storage_engines system variable on group members, for example: disabled_storage_engines="MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY" Primary Keys. A setting of 1 is correct for ... Server instances that you want to use for Group Replication must satisfy the following ...If there are ...