PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-enterprise-data-masking.html
MySQL Enterprise Data Masking and De-Identification functions enable masking existing data using several methods such as obfuscation (removing identifying characteristics), generation of formatted random data, and data replacement or substitution.
https://dev.mysql.com/doc/refman/5.7/en/mysql-logging.html
Here is a sample of output generated on Linux by using --syslog. The mysql client can do these types of logging for statements executed interactively: On Unix, mysql writes the statements to a history file. By default, this file is named ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-tzinfo-to-sql.html
For example: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql mysql_tzinfo_to_sql reads your system's time zone files and generates SQL statements from them. The mysql_tzinfo_to_sql program loads the time zone tables in the mysql ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlcheck.html
--write-binlog Command-Line Format --write-binlog This option is enabled by default, so that ANALYZE TABLE, OPTIMIZE TABLE, and REPAIR TABLE statements generated by mysqlcheck are written to the binary log. The mysqlcheck client performs table ...
https://dev.mysql.com/doc/refman/5.7/en/optimizer-hints.html
If DUPSWEEDOUT is disabled, on occasion the optimizer may generate a query plan that is far from optimal. One means of control over optimizer strategies is to set the optimizer_switch system variable (see Section 8.9.2, “Switchable ...
https://dev.mysql.com/doc/refman/5.7/en/partitioning-selection.html
MySQL 5.7 supports explicit selection of partitions and subpartitions that, when executing a statement, should be checked for rows matching a given WHERE condition. Partition selection is similar to partition pruning, in that only specific ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-status-monitoring.html
All the historical data generated by the plugin code is still available, but new events for the instruments are not collected. Names for these variables have several forms: Performance_schema_xxx_classes_lost indicates how many instruments of type ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-binlog.html
The source of information for point-in-time recovery is the set of binary log files generated subsequent to the full backup operation. This section explains the general idea of using the binary log to perform a point-in-time-recovery. The next ...
https://dev.mysql.com/doc/refman/5.7/en/point-in-time-recovery-positions.html
The last section, Section 7.5.1, “Point-in-Time Recovery Using Binary Log”, explains the general idea of using the binary log to perform a point-in-time-recovery. As an example, suppose that around 13:00:00 on May 27, 2020, an SQL statement was ...
https://dev.mysql.com/doc/refman/5.7/en/query-log.html
Server restarts and log flushing do not cause a new general query log file to be generated (although flushing closes and reopens it). The general query log is a general record of what mysqld is doing. The server writes information to this log when ...