PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html
row *************************** Id: 3112 User: replikator Host: artemis:2204 db: NULL Command: Binlog Dump Time: 2144 State: Has sent all binlog to replica; waiting for binlog to be updated Info: NULL *************************** 4. row ... SHOW ...
https://dev.mysql.com/doc/refman/8.0/en/source-thread-states.html
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 threads on a source, this means that replication is not running; that is, that no ...In ...
https://dev.mysql.com/doc/refman/8.0/en/uninstall-plugin.html
If you are uninstalling a plugin with no intention of reinstalling it later and you care about the table contents, you should dump the table with mysqldump and remove the WITH PARSER clause from the dumped CREATE TABLE statement so that you can ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-troubleshooting.html
To address this issue, dump and restore affected tables before attempting the upgrade again. If, after an upgrade, you experience problems with compiled client programs, such as Commands out of sync or unexpected core dumps, you probably have used ... A schema mismatch in a MySQL 5.7 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 8.0 to ...
https://dev.mysql.com/doc/refman/8.0/en/backup-methods.html
Backing up the physical database files makes restore much faster than logical techniques such as the mysqldump command. (See Section 9.4, “Using mysqldump for Backups”.) For InnoDB tables, it is possible to perform an online backup that takes no ...Making a Hot Backup with MySQL Enterprise Backup Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product to do physical backups of entire instances or selected databases, tables, or ...
https://dev.mysql.com/doc/refman/8.0/en/blackhole-storage-engine.html
Other possible uses for the BLACKHOLE storage engine include: Verification of dump file syntax. The BLACKHOLE storage engine acts as a “black hole” that accepts data but throws it away and does not store it. To examine the source for the ...
https://dev.mysql.com/doc/refman/8.0/en/can-not-connect-to-server.html
You are using Linux and one server thread has died (dumped core). A MySQL client on Unix can connect to the mysqld server in two different ways: By using a Unix socket file to connect through a file in the file system (default /tmp/mysql.sock), or ...
https://dev.mysql.com/doc/refman/8.0/en/change-master-to.html
If you do not do this, the heartbeat signal has no effect, and if no data is received from the source, the replica can make repeated reconnection attempts, creating zombie dump threads. ] CHANGE MASTER TO changes the parameters that the replica ...
https://dev.mysql.com/doc/refman/8.0/en/change-replication-source-to.html
If you do not do this, the heartbeat signal has no effect, and if no data is received from the source, the replica can make repeated reconnection attempts, creating zombie dump threads. ] CHANGE REPLICATION SOURCE TO changes the parameters that the ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
option: { FOR UPGRADE | QUICK | FAST | MEDIUM | EXTENDED | CHANGED } CHECK TABLE checks a table or tables for errors. CHECK TABLE can also check views for problems, such as tables that are referenced in the view definition that no longer exist. To ...