PDF (US Ltr)
- 43.2Mb
PDF (A4)
- 43.3Mb
Man Pages (TGZ)
- 295.2Kb
Man Pages (Zip)
- 400.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/version-tokens-reference.html
If the timeout is 0, there is no waiting and the function produces an error if locks cannot be acquired immediately. One set of functions permits the server's list of version tokens to be manipulated and inspected. Another set of functions permits ... The following discussion serves as a reference to these Version Tokens elements: Version Tokens Functions Version Tokens System Variables Version Tokens Functions The Version Tokens plugin library includes several ...
https://dev.mysql.com/doc/refman/8.0/en/thread-pool-operation.html
This is a kind of long-running “statement” that runs for a very long time, and that should not prevent other statements from executing. With this design, when a thread executes or becomes blocked for an extended time, the thread pool moves the ...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/8.0/en/performance-schema-setup-instruments-table.html
Events produced by the instrument have NULL for the TIMER_START, TIMER_END, and TIMER_WAIT timer values. This in turn causes those values to be ignored when calculating the sum, minimum, maximum, and average time values in summary tables. For ...row ... The setup_instruments table lists classes of instrumented objects for which events can be collected: mysql> SELECT * FROM performance_schema.setup_instruments\G ...
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-object-filtering.html
The ENABLED column indicates whether matching objects are monitored, and TIMED indicates whether to collect timing information. The order in which matching occurs matters because different matching setup_objects rows can have different ENABLED and ... The setup_objects table controls whether the Performance Schema monitors particular table and stored program ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool.html
The old sublist contains less frequently used pages; these pages are candidates for eviction. Per second averages provided in InnoDB Standard Monitor output are based on the elapsed time since InnoDB Standard Monitor output was last printed. The ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-system-tablespace.html
It may also contain table and index data if tables are created in the system tablespace rather than file-per-table or general tablespaces. The size and number of system tablespace data files is defined by the innodb_data_file_path startup option. To ... The system tablespace is the storage area for the change ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options.html
The following sections contain information about mysqld options and server variables that are used in replication and for controlling the binary log. Options and variables for use on sources and replicas are covered separately, as are options and ...The server can be started with this default ID, but when binary logging is enabled, an informational message is issued if you did not set server_id explicitly to specify a server ...
https://dev.mysql.com/doc/refman/8.0/en/command-line-options.html
The MySQL server has certain command options that may be specified only at startup, and a set of system variables, some of which may be set at startup, at runtime, or both. For example, the following command tells mysqladmin to ping the server 1024 ... Program options specified on the command line follow these rules: Options are given after the command ...An option argument ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-summary.html
MySQL Group Replication builds on top of such properties and abstractions and implements a multi-source update everywhere replication protocol. When a read/write transaction is ready to commit at the originating server, the server atomically ...The ... Group Replication is a technique that can be used to implement fault-tolerant ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-locking-reads.html
If you query data and then insert or update related data within the same transaction, the regular SELECT statement does not give enough protection. FOR SHARE requires the SELECT privilege and at least one of the DELETE, LOCK TABLES, or UPDATE ...