PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 297.2Kb
Man Pages (Zip)
- 402.4Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/replication-privilege-checks-account.html
(If events access these tables explicitly for other purposes, you must grant the appropriate privileges on the tables.) Applying a binary log Table_map_log_event, which provides table metadata but does not make any database changes. The ... The user ...As explained in Section 19.3.3, “Replication Privilege Checks”, the account requires further privileges that are sufficient to apply all the expected transactions expected on the replication ...
https://dev.mysql.com/doc/refman/8.0/en/resignal.html
RESIGNAL makes it possible to both handle an error and return the error information. Otherwise, RESIGNAL is illegal and a RESIGNAL when handler not active error occurs. For example, the condition_value can be an SQLSTATE value, and the value can ...
https://dev.mysql.com/doc/refman/8.0/en/large-page-support.html
In the event sysctl returns an error relating to the file name, check the name of the corresponding file in /proc/sys/vm and use that instead. Check any configuration files such as my.cnf used by the server, and make sure that ...Before large pages ... Some hardware and operating system architectures support memory pages greater than the default (usually ...Applications that perform a lot of memory accesses may ...
https://dev.mysql.com/doc/refman/8.0/en/install-component.html
Example: INSTALL COMPONENT 'file://component1', 'file://component2'; A component is named using a URN that begins with file:// and indicates the base name of the library file that implements the component, located in the directory named by the ...A ...[SET variable = expr [, variable = expr] ...] variable: { {GLOBAL | @@GLOBAL.} [component_prefix.]system_var_name | {PERSIST | @@PERSIST.} [component_prefix.]system_var_name } This statement installs one or more components, which become active ...
https://dev.mysql.com/doc/refman/8.0/en/string-literals.html
When writing application programs, any string that might contain any of these special characters must be properly escaped before the string is used as a data value in an SQL statement that is sent to the MySQL server. Backslash (\) and the quote ...
https://dev.mysql.com/doc/refman/8.0/en/replication-rbr-safe-unsafe.html
If a large number of such statements were executed on the source, this could lead to excessively large error log files. When activated, this causes such warnings not to be written to the error log; instead, for each 50 warnings of this type, a note ... The “safeness” of a statement in MySQL replication refers to whether the statement and its effects can be replicated correctly using statement-based ...
https://dev.mysql.com/doc/refman/8.0/en/connecting.html
For a client program to connect to the MySQL server, it must use the proper connection parameters, such as the name of the host where the server is running and the user name and password of your MySQL account. Each connection parameter has a default ... This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or ...
https://dev.mysql.com/doc/refman/8.0/en/mysql-cluster-ndbinfo-dict-obj-info.html
The dict_obj_info table provides information about NDB data dictionary (DICT) objects such as tables and indexes. (The dict_obj_types table can be queried for a list of all the types.) This information includes the object's type, state, parent ...
https://dev.mysql.com/doc/refman/8.0/en/group-replication-responses-failure-exit.html
The group_replication_exit_state_action system variable, which is available from MySQL 8.0.12 and MySQL 5.7.24, specifies what Group Replication does when the member leaves the group unintentionally due to an error or problem, and either fails to ...Note that in the case of an expelled member, the member does not know that it was expelled until it reconnects to the group, so the specified action is only taken if the member manages to reconnect, or if the member raises a suspicion on itself and expels ...
https://dev.mysql.com/doc/refman/8.0/en/general-thread-states.html
This state is used even if the table could not be created due to some error. closing tables The thread is flushing the changed table data to disk and closing the used tables. Actions taken by the server in this state include flushing the binary log ... The following list describes thread State values that are associated with general query processing and not more specialized activities such as ...