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-gtids-restrictions.html
If a source used STATEMENT format and a replica used ROW format, the replica would be unable to handle the transaction correctly, therefore the CREATE TABLE ... When binlog_format is set to STATEMENT, CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE ... Because GTID-based replication is dependent on transactions, some features otherwise available in MySQL are not supported when using ...
https://dev.mysql.com/doc/refman/8.0/en/replication-snapshot-method.html
To select the appropriate method of dumping the database, choose between these options: Use the mysqldump tool to create a dump of all the databases you want to replicate. 19.1.2.5.1 Creating a Data Snapshot Using mysqldump To create a snapshot of ... If the source database contains existing data it is necessary to copy this data to each ...
https://dev.mysql.com/doc/refman/8.0/en/show-table-status.html
Prior to MySQL 8.0.16, Create_options shows the ENCRYPTION clause specified for tables created in file-per-table tablespaces. The encryption clause is not shown for tables created in general tablespaces. When creating a table with strict mode ...
https://dev.mysql.com/doc/refman/8.0/en/show-triggers.html
row *************************** Trigger: ins_sum Event: INSERT Table: account Statement: SET @sum = @sum + NEW.amount Timing: BEFORE Created: 2018-08-08 10:10:12.61 sql_mode: ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES, NO_ZERO_IN_DATE,NO_ZERO_DATE, ...
https://dev.mysql.com/doc/refman/8.0/en/show.html
SHOW has many forms that provide information about databases, tables, columns, or status information about the server. The pattern is useful for restricting statement output to matching values. Several SHOW statements also accept a WHERE clause ...
https://dev.mysql.com/doc/refman/8.0/en/signal.html
Example: CREATE PROCEDURE p (divisor INT) BEGIN DECLARE divide_by_zero CONDITION FOR SQLSTATE '22012'; IF divisor = 0 THEN SIGNAL divide_by_zero; END IF; END; If the named condition does not exist in the scope of the SIGNAL statement, an Undefined ...SIGNAL provides error information to a handler, to an outer portion of the application, or to the ...
https://dev.mysql.com/doc/refman/8.0/en/source-configuration-options.html
-DSYSTEMD_PID_DIR=dir_name The name of the directory in which to create the PID file when MySQL is managed by systemd. -DREPRODUCIBLE_BUILD=bool For builds on Linux systems, this option controls whether to take extra care to create a build result ...
https://dev.mysql.com/doc/refman/8.0/en/symbolic-links-to-databases.html
On Unix, symlink a database using this procedure: Create the database using CREATE DATABASE: mysql> CREATE DATABASE mydb1; Using CREATE DATABASE creates the database in the MySQL data directory and permits the server to update the data dictionary ...Stop the server to ensure that no activity occurs in the new database while it is being ...
https://dev.mysql.com/doc/refman/8.0/en/temporary-files.html
For some statements, MySQL creates temporary SQL tables that are not hidden and have names that begin with #sql. Some SELECT queries creates temporary SQL tables to hold intermediate results. DDL operations that rebuild the table and are not ... On ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-memcached-multiple-get-range-query.html
The example uses the test.city table described in Creating a New Table and Column Mapping. When a range query finds multiple matching key-value pairs, results are returned in a key-value pair sequence. The examples use the test.city table described ... The daemon_memcached plugin supports multiple get operations (fetching multiple key-value pairs in a single memcached query) and range ...