PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-setup-replicas.html
This method can also be used if you are setting up new servers but have an existing dump of the databases from a different server that you want to load into your replication configuration. If you are setting up a new replication environment using ...
https://dev.mysql.com/doc/refman/8.0/en/replication-threads-monitor-main.html
The following example illustrates how the three main replication threads, the binary log dump thread, replication I/O (receiver) thread, and replication SQL (applier) thread, show up in the output from SHOW PROCESSLIST. row ... The SHOW PROCESSLIST ...
https://dev.mysql.com/doc/refman/8.0/en/view-restrictions.html
That shortcoming can lead to problems backing up a database with mysqldump, which may fail due to insufficient privileges. Dump files created with mysqldump cannot be loaded into servers that enforce the column-length restriction. Then the view ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-formats.html
The MySQL server calls the audit log plugin to write an audit record to its log file whenever an auditable event occurs. Typically the first audit record written after plugin startup contains the server description and startup options. Elements ...
https://dev.mysql.com/doc/refman/8.0/en/innochecksum.html
If checksum mismatches are found, restore the tablespace from backup or start the server and attempt to use mysqldump to make a backup of the tables within the tablespace. Example usage: innochecksum --page-type-dump=/tmp/a.txt ../data/test/tab1.ibd ...This tool reads an InnoDB tablespace file, calculates the checksum for each page, compares the calculated checksum to the stored checksum, and reports mismatches, which indicate damaged ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-buffer-pool-in-core-file.html
Because the buffer pool resides in main memory, and the memory image of a running process is dumped to the core file, systems with large buffer pools can produce large core files when the mysqld process dies. To reduce core file size, you can ... A ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-ftdump.html
Before using myisam_ftdump, be sure to issue a FLUSH TABLES statement first if the server is running. myisam_ftdump scans and dumps the entire index, which is not particularly fast. Invoke myisam_ftdump like this: myisam_ftdump [options] tbl_name ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-nutshell.html
To use this variable, the core_file variable must be enabled and the operating system must support the MADV_DONTDUMP non-POSIX extension to madvise(), which is supported in Linux 3.4 and later. MySQL 8.0.22 and later supports periodic ... This ...
https://dev.mysql.com/doc/refman/8.0/en/replica-io-thread-states.html
Reconnecting after a failed binlog dump request The thread is trying to reconnect to the source. Requesting binlog dump A state that occurs very briefly, after the connection to the source is established. Waiting to reconnect after a failed binlog ... The following list shows the most common states you see in the State column for a replication I/O (receiver) thread on a replica ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
--max-binlog-dump-events=N Command-Line Format --max-binlog-dump-events=# Type Integer Default Value 0 This option is used internally by the MySQL test suite for replication testing and debugging. --sporadic-binlog-dump-fail Command-Line Format ...