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/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/replication-options-reference.html
The following two sections provide basic information about the MySQL command-line options and system variables applicable to replication and the binary log. abort-slave-event-count: Option used by mysql-test for debugging and testing of replication. disconnect-slave-event-count: Option used by mysql-test for debugging and testing of ...Replication Options and Variables The command-line options and ...
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 ...
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/flush.html
If the --skip-grant-tables option was specified at server startup to disable the MySQL privilege system, FLUSH PRIVILEGES provides a way to enable the privilege system at runtime. The mysqladmin utility provides a command-line interface to some ...| ...