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/version-tokens-usage.html
The next time the client sends a statement to server 2, its own token list no longer matches the server token list and an error occurs: mysql> UPDATE emp.employee SET salary = salary * 1.1 WHERE id = 4982; ERROR 3136 (42000): Version token mismatch ...Assignment of a server within a certain group can change at any ... Before using Version Tokens, install it according to the instructions ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html
mysql sends each SQL statement that you issue to the server to be executed. If there is a concern that optimizer-hint comments may be stored in object definitions so that dump files when reloaded with mysql would result in execution of such ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-log-statistics.html
Check whether there are any timed messages to be executed; if so, put these into the job buffer as well. Counters providing information about the state of the cluster are updated at 5-second reporting intervals by the transaction coordinator (TC) ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-flow-control.html
This approach works well if the total number of writes to the group does not exceed the write capacity of any member in the group. Whenever the size of one of these queues exceeds the user-defined threshold, the throttling mechanism is triggered.
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-nodes-groups.html
This is also the case when using ndbmtd with MaxNoOfExecutionThreads set to 3 or less. (You should be aware that the number of LDM threads increases with the value of this parameter, but not in a strictly linear fashion, and that there are ... This ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-operation.html
The thread pool tries to ensure a maximum of one thread executing in each group at any time, but sometimes permits more threads to execute temporarily for best performance: Each thread group has a listener thread that listens for incoming statements ...thread_pool_prio_kickup_timer: How long before the thread pool moves a statement awaiting execution from the low-priority queue to the high-priority ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
Suppose that we have a table named person, created as shown here: USE test; CREATE TABLE person ( person_id INT NOT NULL PRIMARY KEY, fname VARCHAR(40) NULL, lname VARCHAR(40) NULL, created TIMESTAMP ); Suppose further that this table is initially ...The tagname in the optional ROWS IDENTIFIED BY clause must also be given as a literal string, and must be surrounded by angle brackets (< and ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-buffer-pool-flushing.html
However, if the number of page cleaner threads exceeds the number of buffer pool instances, innodb_page_cleaners is automatically set to the same value as innodb_buffer_pool_instances. When table data is stored on a traditional HDD storage device, ... InnoDB performs certain tasks in the background, including flushing of dirty pages from the buffer ...
https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html
Performance Characteristics MEMORY performance is constrained by contention resulting from single-thread execution and table lock overhead when processing updates. A server restart also sets the maximum size of existing MEMORY tables to the global ... The MEMORY storage engine (formerly known as HEAP) creates special-purpose tables with contents that are stored in ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-frequently-asked-questions.html
Warning When the network round-trip time (RTT) between any group members is 5 seconds or more you could encounter problems as the built-in failure detection mechanism could be incorrectly triggered. What is the maximum number of MySQL servers in a ...Attempting to add another server to a group with 9 members causes the request to join to be ...