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/timestamp-initialization.html
TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current timestamp). For any TIMESTAMP or DATETIME column in a table, you can assign the current timestamp as the default value, ...If both are present in a column definition, either can occur ...
https://dev.mysql.com/doc/refman/8.0/en/stored-programs-logging.html
With mixed format, when a stored function, stored procedure, trigger, event, or prepared statement contains anything that is not safe for statement-based binary logging, the entire statement is marked as unsafe and logged in row format. The ... The ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-system-variables.html
For instructions on doing this safely, see Section 20.5.2, “Restarting a Group”. These system variables include group_replication_group_name, group_replication_single_primary_mode, group_replication_force_members, the SSL variables, and the flow ... This section lists the system variables that are specific to the Group Replication ...
https://dev.mysql.com/doc/refman/8.0/en/binary-log-mixed.html
When one or more tables with AUTO_INCREMENT columns are updated and a trigger or stored function is invoked. Like all other unsafe statements, this generates a warning if binlog_format = STATEMENT. For information about how replication treats ...
https://dev.mysql.com/doc/refman/8.0/en/firewall-reference.html
read_firewall_groups(group, mode, user) This aggregate function updates the firewall group profile cache through a SELECT statement on the mysql.firewall_groups table. Firewall Account Profile Functions These functions perform management operations ...The mysql.firewall_groups table lists names and operational modes of registered firewall group ...
https://dev.mysql.com/doc/refman/8.0/en/updating-yum-repo.html
Notes Before performing any update to MySQL, follow carefully the instructions in Chapter 3, Upgrading MySQL. Among other instructions discussed there, it is especially important to back up your database before the update. Selecting a Target Series ... For supported Yum-based platforms (see Section 2.5.1, “Installing MySQL on Linux Using the MySQL Yum Repository”, for a list), you can perform an in-place upgrade for MySQL (that is, replacing the old version and then running the new version using the old data files) with the MySQL Yum ...
https://dev.mysql.com/doc/refman/8.0/en/replication-options-binary-log.html
Be aware that, even with this and other safety checks, if a JSON document on a replica has diverged from that on the source and a partial update is applied, it remains theoretically possible to produce a valid but unexpected JSON document on the ...
https://dev.mysql.com/doc/refman/8.0/en/commit.html
To disable autocommit mode implicitly for a single series of statements, use the START TRANSACTION statement: START TRANSACTION; SELECT @A:=SUM(salary) FROM table1 WHERE type=1; UPDATE table2 SET summary=@A WHERE type=1; COMMIT; With START ...SET ...
https://dev.mysql.com/doc/refman/8.0/en/faqs-sql-modes.html
What is the default server SQL mode when MySQL 8.0 is installed? A.3.1. What are server SQL modes? Server SQL modes define what SQL syntax MySQL should support and what kind of data validation checks it should perform. How many server SQL modes are ...This makes it easier to use MySQL in different environments and to use MySQL together with other database ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbd-definition.html
BackupDataDir Version (or later) NDB 8.0.13 Type or units path Default FileSystemPath Range ... For example, if you set the value of BackupDataDir to /var/lib/cluster-data, then all backups are stored under /var/lib/cluster-data/BACKUP. In setting ... The [ndbd] and [ndbd default] sections are used to configure the behavior of the cluster's data ...