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/group-replication-enterprise-backup.html
For example, on Linux distributions that use systemd: s3> systemctl stop mysqld Preserve the two configuration files in the corrupted server's data directory, auto.cnf and mysqld-auto.cnf (if it exists), by copying them to a safe location outside of ... MySQL Enterprise Backup is a commercially-licensed backup utility for MySQL Server, available with MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-linux-binary.html
This section covers the steps necessary to install the correct executables for each type of Cluster node from precompiled binaries supplied by Oracle. For setting up a cluster using precompiled binaries, the first step in the installation process ...
https://dev.mysql.com/doc/refman/8.0/en/create-index.html
For a unique index, an error occurs regardless of SQL mode because reducing the index length might enable insertion of nonunique entries that do not meet the specified uniqueness requirement. CREATE [UNIQUE | FULLTEXT | SPATIAL] INDEX index_name ...
https://dev.mysql.com/doc/refman/8.0/en/create-table-generated-columns.html
STORED: Column values are evaluated and stored when rows are inserted or updated. Note Expression evaluation uses the SQL mode in effect at evaluation time. If any component of the expression depends on the SQL mode, different results may occur for ...Values of a generated column are computed from an expression included in the column ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-sql-mode.html
Using different server SQL mode settings on the source and the replica may cause the same INSERT statements to be handled differently on the source and the replica, leading the source and replica to diverge. For best results, you should always use ...This advice applies whether you are using statement-based or row-based ...
https://dev.mysql.com/doc/refman/8.0/en/replication-mode-change-online-concepts.html
Before setting the replication mode of an online server, it is important to understand some key concepts of replication. This section explains these concepts and is essential reading before attempting to modify the replication mode of an online ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-upgrade.html
This permits passwords to be specified in a safer way than on the command line even when --no-defaults is used. --ssl-fips-mode={OFF|ON|STRICT} Command-Line Format --ssl-fips-mode={OFF|ON|STRICT} Deprecated 8.0.34 Type Enumeration Default Value OFF ... Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 3.4, “What the MySQL Upgrade Process ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-change-buffer.html
The buffered changes, which may result from INSERT, UPDATE, or DELETE operations (DML), are merged later when the pages are loaded into the buffer pool by other read operations. Similarly, deletes and updates may affect secondary index pages that ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-replication-starting.html
It is also necessary in NDB 8.0 to enable logging of updates to NDB tables explicitly, using the --ndb-log-bin option; this is a change from previous versions of NDB Cluster, in which this option was enabled by default. It is also possible to ...
https://dev.mysql.com/doc/refman/8.0/en/optimizing-queries-myisam.html
This updates a value for each index part that indicates the average number of rows that have the same value. Try to avoid complex SELECT queries on MyISAM tables that are updated frequently, to avoid problems with table locking that occur due to ...