PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
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/can-not-connect-to-server.html
If you get the error message Can't connect to MySQL server on some_host, you can try the following things to find out what the problem is: Check whether the server is running on that host by executing telnet some_host 3306 and pressing the Enter key ...You should check that there is a MySQL server running, that it has network connections enabled, and that the network port you specified is the one configured on the ... A MySQL client on Unix can connect to the mysqld server in two ...
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/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/timestamp-lookups.html
Temporal values are stored in TIMESTAMP columns as UTC values, and values inserted into and retrieved from TIMESTAMP columns are converted between the session time zone and UTC. If the session time zone is UTC, there is effectively no time zone ...
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/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 ...