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/replica-logs-status.html
A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata repository. If binary log file position based replication is in use, when the replica restarts, it reads the two ...
https://dev.mysql.com/doc/refman/5.7/en/sys-statement-performance-analyzer.html
Creates a report of the statements running on the server. The views are calculated based on the overall and/or delta activity. This procedure disables binary logging during its execution by manipulating the session value of the sql_log_bin system ...
https://dev.mysql.com/doc/refman/5.7/en/using-system-variables.html
The MySQL server maintains many system variables that configure its operation. Section 5.1.7, “Server System Variables”, describes the meaning of these variables. System variables can be set at server startup using options on the command line ...
https://dev.mysql.com/doc/refman/5.7/en/replication-administration-skip.html
The binary log is organized as a sequence of groups known as event groups, and each event group consists of a sequence of events. For nontransactional tables, an event group corresponds to a single SQL statement. When you use a SET GLOBAL ... If ...
https://dev.mysql.com/doc/refman/5.7/en/derived-table-optimization.html
The optimizer propagates an ORDER BY clause in a derived table or view reference to the outer query block if these conditions are all true: The outer query is not grouped or aggregated. The optimizer handles derived tables and view references the ...
https://dev.mysql.com/doc/refman/5.7/en/pam-pluggable-authentication.html
Proxy user support: PAM authentication can return to MySQL a user name different from the external user name passed by the client program, based on the PAM groups the external user is a member of and the authentication string provided. Optionally, ... Note PAM pluggable authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-select-count.html
--defaults-group-suffix Command-Line Format --defaults-group-suffix=string Type String Default Value [none] Also read groups with concat(group, suffix). ndb_select_count prints the number of rows in one or more NDB tables. With a single table, the ...
https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html
These variables can be changed individually using SET statements, but two more convenient statements affect the connection-related character set sytem variables as a group: SET NAMES 'charset_name' [COLLATE 'collation_name'] SET NAMES indicates what ... A “connection” is what a client program makes when it connects to the server, to begin a session within which it interacts with the ...
https://dev.mysql.com/doc/refman/5.7/en/enum.html
(The practical limit is less than 3000.) A table can have no more than 255 unique element list definitions among its ENUM and SET columns considered as a group. An ENUM is a string object with a value chosen from a list of permitted values that are ...
https://dev.mysql.com/doc/refman/5.7/en/sys-host-summary-by-statement-latency.html
The host_summary_by_statement_latency and x$host_summary_by_statement_latency views have these columns: host The host from which the client connected. Rows for which the HOST column in the underlying Performance Schema table is NULL are assumed to ...