PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/performance-schema-status-variables.html
Performance Schema status variables have the following meanings: Performance_schema_accounts_lost The number of times a row could not be added to the accounts table because it was full. Performance_schema_digest_lost The number of digest instances ...
https://dev.mysql.com/doc/refman/8.0/en/reloading-sql-format-dumps.html
To reload a dump file written by mysqldump that consists of SQL statements, use it as input to the mysql client.
https://dev.mysql.com/doc/refman/8.0/en/replace.html
For information about generated columns, see Section 15.1.20.8, “CREATE TABLE and Generated Columns”. REPLACE [LOW_PRIORITY | DELAYED] [INTO] tbl_name [PARTITION (partition_name [, partition_name] ...)] [(col_name [, col_name] ...)] { {VALUES | ...
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 ...