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/network-namespace-support.html
Each namespace has its own IP addresses, network interfaces, routing tables, and so forth. This can produce phenomena such as a client connection from an address in one namespace appearing to the MySQL server to be coming from a different address, ... A network namespace is a logical copy of the network stack from the host ...
https://dev.mysql.com/doc/refman/8.0/en/string-type-syntax.html
The string data types are CHAR, VARCHAR, BINARY, VARBINARY, BLOB, TEXT, ENUM, and SET. For definitions of character string columns (CHAR, VARCHAR, and the TEXT types), MySQL interprets length specifications in character units. For definitions of ...
https://dev.mysql.com/doc/refman/8.0/en/replication-sbr-rbr.html
Not all statements which modify data (such as INSERT DELETE, UPDATE, and REPLACE statements) can be replicated using statement-based replication. DELETE and UPDATE statements that use a LIMIT clause without an ORDER BY are nondeterministic. For ...
https://dev.mysql.com/doc/refman/8.0/en/plugin-loading.html
It is also possible to control the activation state of loaded plugins at startup, and to unload them at runtime. In the descriptions, plugin_name stands for a plugin name such as innodb, csv, or validate_password. --plugin-load, --plugin-load-add, ...Installing Plugins Controlling Plugin Activation State Uninstalling Plugins Plugins and Loadable Functions Installing Plugins Before a server plugin can be used, it must be installed using one of the following ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-transaction-inconsistencies.html
Up to and including MySQL 8.0.18, preserving the commit order requires that binary logging (log_bin) and replica update logging (log_replica_updates or log_slave_updates) are also enabled, which are the default settings from MySQL 8.0. From MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-usage.html
This means that it is possible that updates are not applied on the replica, so that the source and replica are no longer synchronized. Another method to filter out changes on some replicas is to use a WHERE clause that includes the relation ...The ... MySQL uses statement-based logging (SBL), row-based logging (RBL) or mixed-format ...
https://dev.mysql.com/doc/refman/8.0/en/check-table.html
A table is reported as needing a rebuild if it contains old temporal columns in pre-5.6.4 format (TIME, DATETIME, and TIMESTAMP columns without support for fractional seconds precision) and the avoid_temporal_upgrade system variable is disabled. If ...CHECK TABLE is supported for partitioned tables, and you can use ALTER TABLE ...option: { FOR UPGRADE | QUICK | ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-functions.html
To avoid unexpected results when replicating between MySQL servers in different time zones, set the time zone on both source and replica. To explain the potential problems when replicating between servers which are in different time zones, suppose ... Certain functions do not replicate well under some conditions: The USER(), CURRENT_USER() (or CURRENT_USER), UUID(), VERSION(), and LOAD_FILE() functions are replicated without change and thus do not work reliably on the replica unless row-based replication is ...
https://dev.mysql.com/doc/refman/8.0/en/update.html
The implicit default value is 0 for numeric types, the empty string ('') for string types, and the “zero” value for date and time types. Each matching row is updated once, even if it matches the conditions multiple times. Only the partitions (or ... UPDATE is a DML statement that modifies rows in a ...Each value can be given as an expression, or the ...
https://dev.mysql.com/doc/refman/8.0/en/using-systemd.html
Instances then are managed by normal systemd commands, such as: systemctl start mysqld@replica01 systemctl start mysqld@replica02 To enable instances to run at boot time, do this: systemctl enable mysqld@replica01 systemctl enable mysqld@replica02 ...The following discussion covers these topics: Overview of systemd Configuring systemd for MySQL Configuring Multiple MySQL Instances Using systemd Migrating from mysqld_safe to systemd Note On platforms for which systemd support for MySQL is installed, scripts such as mysqld_safe and the System V initialization script are unnecessary and are not ...