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/replica-sql-thread-states.html
When global scope is used, the slow query log contains the old versions of the names. The following list shows the most common states you may see in the State column for a replication SQL thread on a replica server. In MySQL 8.0.26, incompatible ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
If the server has a mix of InnoDB transactions and non-InnoDB transactions, which are written to the mysql.gtid_executed table individually, the compression carried out by the compress_gtid_table thread interferes with the work of the GTID persister ... A global transaction identifier (GTID) is a unique identifier created and associated with each transaction committed on the server of origin (the ...
https://dev.mysql.com/doc/refman/8.0/en/server-option-variable-reference.html
The following table lists all command-line options, system variables, and status variables applicable within mysqld. The table lists command-line options (Cmd-line), options valid in configuration files (Option file), server system variables ...
https://dev.mysql.com/doc/refman/8.0/en/source-thread-states.html
When global scope is used, the slow query log contains the old versions of the names. The following list shows the most common states you may see in the State column for the Binlog Dump thread of the replication source. If you see no Binlog Dump ...
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
This is because Internet routing can cause a packet to take a slow route to its destination and it may arrive after both sides have agreed to close. A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix ...
https://dev.mysql.com/doc/refman/8.0/en/compressed-format.html
This minimizes disk usage, which is helpful when using slow disks (such as CD-ROMs). Compressed storage format is a read-only format that is generated with the myisampack tool. Compressed tables have the following characteristics: Compressed tables ...
https://dev.mysql.com/doc/refman/8.0/en/connection-control-plugin.html
This capability provides a deterrent that slows down brute force attacks against MySQL user accounts. MySQL Server includes a plugin library that enables administrators to introduce an increasing delay in server response to connection attempts ...
https://dev.mysql.com/doc/refman/8.0/en/copying-databases.html
In cases where you need to transfer databases between different architectures, you can use mysqldump to create a file containing SQL statements. You can then transfer the file to the other machine and feed it as input to the mysql client. Note If ...
https://dev.mysql.com/doc/refman/8.0/en/creating-many-tables.html
If you have many MyISAM tables in the same database directory, open, close, and create operations are slow. If you execute SELECT statements on many different tables, there is a little overhead when the table cache is full, because for every table ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-innodb-change-buffer.html
A full merge of the change buffer can be forced as part of a slow server shutdown using --innodb-fast-shutdown=0. What types of operations modify secondary indexes and result in change buffering? A.16.2. How much space does InnoDB use for the change ...