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/constraint-enum.html
ENUM and SET columns provide an efficient way to define columns that can contain only a given set of values. See Section 13.3.5, “The ENUM Type”, and Section 13.3.6, “The SET Type”. For a column defined as ENUM('a','b','c'), values such as ...Unless strict mode is disabled (not recommended, but see Section 7.1.11, “Server SQL Modes”), the definition of a ENUM or SET column acts as a constraint on values entered into the ...
https://dev.mysql.com/doc/refman/8.0/en/data-masking-components.html
MySQL Enterprise Data Masking and De-Identification implements these elements: A table in the mysql system database for persistent storage of dictionaries and terms. A component named component_masking that implements masking functionality and ...
https://dev.mysql.com/doc/refman/8.0/en/drop-procedure.html
(If the automatic_sp_privileges system variable is enabled, that privilege and EXECUTE are granted automatically to the routine creator when the routine is created and dropped from the creator when the routine is dropped. See Section 27.2.2, ...
https://dev.mysql.com/doc/refman/8.0/en/innodb-information-schema-innodb_cmp.html
The INNODB_CMP and INNODB_CMP_RESET tables provide status information about operations related to compressed tables, which are described in Section 17.9, “InnoDB Table and Page Compression”. These two tables have identical contents, but reading ...For example, if you archive the output of INNODB_CMP_RESET every 60 minutes, you see the statistics for each hourly ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-install-windows-source.html
The procedure for doing this is almost identical to the procedure used to compile the standard MySQL Server binaries for Windows, and uses the same tools. This means that, by default, if CMake cannot find the location of Java on your system, the ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-tde-setup.html
Start the management server with either --initial or --reload to cause it to read the updated configuration file. When you supply the password on the command line, a warning is shown, similar to this one: > ndbmtd -c 127.0.0.1 ...Perform a rolling ...
https://dev.mysql.com/doc/refman/8.0/en/replica-logs.html
The replica's connection metadata repository contains information that the replication receiver thread needs to connect to the replication source server and retrieve transactions from the source's binary log. The replica's applier metadata ... A ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-blackhole.html
Updates and deletes are handled differently depending on whether statement based or row based logging is in use. When using row-based logging, updates and deletes to such tables are simply skipped—they are not written to the binary log. The ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-floatvalues.html
Because conversions between decimal and binary representations of them may be approximate, comparisons involving floating-point values are inexact. Comparisons of floating-point values might yield different results on source and replica servers due ... With statement-based replication, values are converted from decimal to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-features-flush.html
If you replicate the privilege tables in the mysql database and update those tables directly without using GRANT, you must issue a FLUSH PRIVILEGES on the replicas to put the new privileges into effect. Some forms of the FLUSH statement are not ...