PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/system-variables-controlling-tracing.html
optimizer_trace_max_mem_size: Maximum amount of memory that can be used for storing all traces. The following system variables affect optimizer tracing: optimizer_trace: Enables or disables optimizer tracing. optimizer_trace_features: Enables or ...
https://dev.mysql.com/doc/refman/5.7/en/constraints.html
The basic philosophy is that MySQL Server tries to produce an error for anything that it can detect while parsing a statement to be executed, and tries to recover from any errors that occur while executing the statement. Several SQL mode options are ...We must handle the case when you have inserted or updated a lot of rows in a nontransactional table for which changes cannot be rolled back when an error ...
https://dev.mysql.com/doc/refman/5.7/en/data-masking-functions.html
gen_blacklist(str, dictionary_name, replacement_dictionary_name) Replaces a term present in one dictionary with a term from a second dictionary and returns the replacement term. Example: mysql> SELECT ...If a string return value should be in a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-setup-reload-saved.html
This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system variable. Reloads a Performance Schema configuration saved earlier within the same session using ps_setup_save(). That is a ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-bootstrap.html
The process of starting a group for the first time is called bootstrapping. If it is saved in the option file, upon restart the server automatically bootstraps a second group with the same name. The importance of the binary log entries is ...The ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-migration.html
In conjunction with the MySQL binary log, you can perform point-in-time recovery. Start a second mysqld server on the backup and let it clean up the .ibd files in the backup. Restoring from a Logical Backup You can use a utility such as mysqldump to ... This section describes techniques for moving or copying some or all InnoDB tables to a different server or ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-management.html
The second method involves studying the contents of the cluster log ndb_node_id_cluster.log; this is usually found in the management server's DataDir directory, but this location can be overridden using the LogDestination option. More detailed ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-multi-source.html
This does not automatically create binary logs on the second NDB Cluster's SQL node acting as the replica; in order to cause the binary logs to be created, you must issue a SHOW TABLES statement on that SQL node; this should be done prior to running ... It is possible to use NDB Cluster for bidirectional replication between two clusters, as well as for circular replication between any number of ...
https://dev.mysql.com/doc/refman/5.7/en/set-names.html
SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT} This statement sets the three session system variables character_set_client, character_set_connection, and character_set_results to the given character set. Setting ...
https://dev.mysql.com/doc/refman/5.7/en/merge-table-problems.html
If there is a difference between the tables, an error is returned and the statement fails. If you encounter an error message similar to ERROR 1017 (HY000): Can't find file: 'tbl_name.MRG' (errno: 2), it generally indicates that some of the ... The ...