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/innodb-information-schema-innodb_cmp.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information about operations related to compressed tables, which are described in Section 17.9, “InnoDB Table and Page Compression”. These two tables have identical contents, but reading ...For example, if you archive the output of INNODB_CMP_RESET every 60 minutes, you see the statistics for each hourly ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-windows-source.html
The procedure for doing this is almost identical to the procedure used to compile the standard MySQL Server binaries for Windows, and uses the same tools. This means that, by default, if CMake cannot find the location of Java on your system, the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-tde-setup.html
Start the management server with either --initial or --reload to cause it to read the updated configuration file. When you supply the password on the command line, a warning is shown, similar to this one: > ndbmtd -c 127.0.0.1 ...Perform a rolling ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs.html
The replica's connection metadata repository contains information that the replication receiver thread needs to connect to the replication source server and retrieve transactions from the source's binary log. The replica's applier metadata ... A ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-blackhole.html
Updates and deletes are handled differently depending on whether statement based or row based logging is in use. When using row-based logging, updates and deletes to such tables are simply skipped—they are not written to the binary log. The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-floatvalues.html
Because conversions between decimal and binary representations of them may be approximate, comparisons involving floating-point values are inexact. Comparisons of floating-point values might yield different results on source and replica servers due ... With statement-based replication, values are converted from decimal to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-flush.html
If you replicate the privilege tables in the mysql database and update those tables directly without using GRANT, you must issue a FLUSH PRIVILEGES on the replicas to put the new privileges into effect. Some forms of the FLUSH statement are not ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-repair-table.html
However, any such modifications of table data performed by this statement are not replicated, which can cause source and replica to lose synchronization. When used on a corrupted or otherwise damaged table, it is possible for the REPAIR TABLE ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-reserved-words.html
You can encounter problems when you attempt to replicate from an older source to a newer replica and you make use of identifiers on the source that are reserved words in the newer MySQL version running on the replica. Only after the event is parsed ...For example, a table column named rank on a MySQL 5.7 source that is replicating to a MySQL 8.0 replica could cause a problem because RANK is a reserved word beginning in MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/se-csv-repair.html
The CSV storage engine supports the CHECK TABLE and REPAIR TABLE statements to verify and, if possible, repair a damaged CSV table. When running the CHECK TABLE statement, the CSV file is checked for validity by looking for the correct field ...