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/replication-rbr-safe-unsafe.html
If this is true of the statement, we refer to the statement as safe; otherwise, we refer to it as unsafe. However, certain nondeterministic functions are not considered unsafe (see Nondeterministic functions not considered unsafe, later in this ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-unexpected-replica-halt.html
This section describes the impact of an unexpected halt of a replica during replication, and how to configure a replica for the best chance of recovery to continue replication. In older MySQL Server versions, this repository could only be created as ... In order for replication to be resilient to unexpected halts of the server (sometimes described as crash-safe) it must be possible for the replica to recover its state before ...
https://dev.mysql.com/doc/refman/5.7/en/resignal.html
It starts by pushing a diagnostics area to the top of the stack, which now looks like this: DA 1. ERROR 1051 (42S02): Unknown table 'xx' At this point, the contents of the first (current) and second (stacked) diagnostics areas are the same. SET is ...RESIGNAL may change some or all information before passing it ...
https://dev.mysql.com/doc/refman/5.7/en/validate-password-options-variables.html
This section describes the options, system variables, and status variables that validate_password provides to enable its operation to be configured and monitored. This option is available only if the validate_password plugin has been previously ...
https://dev.mysql.com/doc/refman/5.7/en/controlling-query-plan-evaluation.html
If you are unsure of what a reasonable value is for optimizer_search_depth, this variable can be set to 0 to tell the optimizer to determine the value automatically. Because the difference in performance between “good” and “bad” plans can be ... The task of the query optimizer is to find an optimal plan for executing an SQL ...
https://dev.mysql.com/doc/refman/5.7/en/group-replication-restarting-group.html
You can do this manually by looking at the GTIDs, or you can compare the GTID sets using stored functions, as described in Section 16.1.3.7, “Stored Function Examples to Manipulate GTIDs”. For Group Replication, this includes both transactions ... Group Replication is designed to ensure that the database service is continuously available, even if some of the servers that form the group are currently unable to participate in it due to planned maintenance or unplanned ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
For example: [mysqld] user=mysql This causes the server to start as the designated user whether you start it manually or by using mysqld_safe or mysql.server. If the connection between the client and the server goes through an untrusted network, and ... When you connect to a MySQL server, you should use a ...
https://dev.mysql.com/doc/refman/5.7/en/column-count-limit.html
This section describes limits on the number of columns in tables and the size of individual rows. The exact column limit depends on several factors: The maximum row size for a table constrains the number (and possibly size) of columns because the ...Column Count Limits Row Size Limits Column Count Limits MySQL has hard limit of 4096 columns per table, but the effective maximum may be less for a given ...
https://dev.mysql.com/doc/refman/5.7/en/account-upgrades.html
For information about this plugin, see Section 6.4.1.5, “SHA-256 Pluggable Authentication”. The following table lists the types of mysql.user accounts considered in this discussion. This operation requires no password changes, so it can be ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-config-example.html
The NDB Cluster global configuration file is by convention named config.ini (but this is not required). This option has no default value, and is ignored if ndb_mgmd uses the configuration cache. This is also true for default sections of any other ...