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/replication-solutions-partitioning.html
If you have data that must be synchronized to the replicas before replication starts, you have a number of choices: Synchronize all the data to each replica, and delete the databases, tables, or both that you do not want to keep. Use mysqldump to ...
https://dev.mysql.com/doc/refman/8.0/en/upgrade-troubleshooting.html
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 fail. In this case, remove all redo log files and restart the MySQL 5.7 server on the existing data ...If ...To address this issue, dump and restore affected tables before attempting the upgrade ...
https://dev.mysql.com/doc/refman/8.0/en/invisible-columns.html
As an illustration of when invisible columns may be useful, suppose that an application uses SELECT * queries to access a table, and must continue to work without modification even if the table is altered to add a new column that the application ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-limitations-limits.html
(In NDB 7.6 and earlier, this was 48.) A data node must have a node ID in the range of 1 to 144, inclusive. Memory consumed when data is inserted into an NDB table is not automatically recovered when deleted, as it is with other storage engines. See ... In this section, we list limits found in NDB Cluster that either differ from limits found in, or that are not found in, standard ...
https://dev.mysql.com/doc/refman/8.0/en/myisam-start.html
If the server finds an error, it tries to do a fast table repair (with sorting and without re-creating the data file). If the repair fails because of an error in the data file (for example, a duplicate-key error), the server tries again, this time ...myisam_max_sort_file_size The maximum size of the temporary file that MySQL is permitted to use while re-creating a MyISAM index (during REPAIR TABLE, ALTER TABLE, or LOAD ...
https://dev.mysql.com/doc/refman/8.0/en/default-privileges.html
For data directory initialization performed manually using mysqld --initialize, mysqld generates an initial random password, marks it expired, and writes it to the server error log. The MySQL installation process involves initializing the data ...
https://dev.mysql.com/doc/refman/8.0/en/multiple-windows-command-line-servers.html
For example, the C:\my-opts1.cnf file might be written like this: [mysqld] datadir = C:/mydata1 port = 3307 enable-named-pipe socket = mypipe1 Modify C:\my-opts2.cnf similarly for use by the second server. To start multiple servers this way, you can ... The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.4.6, “Starting MySQL from the Windows Command ...
https://dev.mysql.com/doc/refman/8.0/en/replication-gtids-concepts.html
The MySQL system table mysql.gtid_executed is used to preserve the assigned GTIDs of all the transactions applied on a MySQL server, except those that are stored in a currently active binary log file. No error is raised, and no statement in the ...
https://dev.mysql.com/doc/refman/8.0/en/backup-and-recovery.html
Additional Resources Resources related to backup or to maintaining data availability include the following: Customers of MySQL Enterprise Edition can use the MySQL Enterprise Backup product for backups. This has several benefits, such as enabling ...
https://dev.mysql.com/doc/refman/8.0/en/encrypted-connections.html
Encryption algorithms must include security elements to resist many kinds of known attacks such as changing the order of encrypted messages or replaying data twice. With an unencrypted connection between the MySQL client and the server, someone ...