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/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 ...
https://dev.mysql.com/doc/refman/8.0/en/sys-innodb-buffer-stats-by-table.html
These views summarize the information in the INFORMATION_SCHEMA INNODB_BUFFER_PAGE table, grouped by schema and table. Do not query these views on a production system unless you are aware of the performance impact and have determined it to be ...
https://dev.mysql.com/doc/refman/8.0/en/alter-logfile-group.html
An ALTER LOGFILE GROUP statement has one and only one ADD UNDOFILE clause. This means that each Disk Data object must be uniquely named (and not merely each Disk Data object of a given type). For example, you cannot have a tablespace and an undo log ... ALTER LOGFILE GROUP logfile_group ADD UNDOFILE 'file_name' [INITIAL_SIZE [=] size] [WAIT] ENGINE [=] engine_name This statement adds an UNDO file named 'file_name' to an existing log file group ...