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/sys-table-exists.html
Tests whether a given table exists as a regular table, a TEMPORARY table, or a view. If both a temporary and a permanent table exist with the given name, TEMPORARY is returned. Parameters in_db VARCHAR(64): The name of the database in which to ...
https://dev.mysql.com/doc/refman/8.0/en/table.html
TABLE is a DML statement introduced in MySQL 8.0.19 which returns rows and columns of the named table. Given the existence of a table named t, the following two statements produce identical output: TABLE t; SELECT * FROM t; You can order and limit ...
https://dev.mysql.com/doc/refman/8.0/en/mysqldumpslow.html
The MySQL slow query log contains information about queries that take a long time to execute (see Section 7.4.5, “The Slow Query Log”). mysqldumpslow parses MySQL slow query log files and summarizes their contents. Normally, mysqldumpslow ...It ...
https://dev.mysql.com/doc/refman/8.0/en/stored-program-restrictions.html
If you refer to a temporary table multiple times in a stored function under different aliases, a Can't reopen table: 'tbl_name' error occurs, even if the references occur in different statements within the function. Unsupported Syntax from the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-applications.html
Specify character settings at configuration time, if you build MySQL from source. For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be needed. If most ...If applications require data storage using a different character set or collation, you can configure character set information several ways: Specify character settings per ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure.html
By default, the following behaviors happen if a member is suspected of having failed: Up to MySQL 8.0.20, when a suspicion is created, it times out immediately. From MySQL 8.0.21, a waiting period of 5 seconds is added before the suspicion times out ...When a suspicion times out, the suspected member is assumed to have failed, and is expelled from the ... Group Replication's failure detection mechanism is designed to identify group members that ...
https://dev.mysql.com/doc/refman/8.0/en/events-configuration.html
When the Event Scheduler is ON, the event scheduler thread is listed in the output of SHOW PROCESSLIST as a daemon process, and its state is represented as shown here: mysql> SHOW PROCESSLIST\G *************************** 1. row ... Events are ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-frequently-asked-questions.html
Alternatively, from MySQL 8.0.21, you can specify them on the START GROUP_REPLICATION statement each time Group Replication is started. From MySQL 8.0, two settings are available to increase the chances of a member remaining in or rejoining a group: ...What is the maximum number of MySQL servers in a group? A group can consist of maximum 9 ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-preload-buffer-pool.html
In addition to saving the buffer pool state at shutdown and restoring it at startup, you can save and restore the buffer pool state at any time, while the server is running. [mysqld] innodb_buffer_pool_dump_pct=40 The innodb_buffer_pool_dump_pct ...
https://dev.mysql.com/doc/refman/8.0/en/postinstallation.html
This section discusses tasks that you should perform after installing MySQL: If necessary, initialize the data directory and create the MySQL grant tables. For some MySQL installation methods, data directory initialization may be done for you ...