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/performance-schema-replication-connection-configuration-table.html
(CHANGE MASTER TO option: MASTER_PORT) USER The user name of the account used to connect to the replication source server. (CHANGE MASTER TO option: MASTER_USER) NETWORK_INTERFACE The network interface that the replica is bound to, if any. This ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-system-variables.html
performance_schema_users_size Command-Line Format --performance-schema-users-size=# System Variable performance_schema_users_size Scope Global Dynamic No Type Integer Default Value -1 (signifies autoscaling; do not assign this literal value) Minimum ...The Performance Schema automatically sizes the values of several of its parameters at server startup if they are not set ...
https://dev.mysql.com/doc/refman/5.7/en/prepare.html
preparable_stmt is either a string literal or a user variable that contains the text of the SQL statement. As a workaround, refer instead to user-defined variables, which also have session scope; see Section 9.4, “User-Defined Variables”.
https://dev.mysql.com/doc/refman/5.7/en/repair-table.html
if the user ID of the owner of the .frm, .MYD, or .MYI file is different from the user ID of the mysqld process, REPAIR TABLE generates a "cannot change ownership of the file" error unless mysqld is started by the root user. [QUICK] [EXTENDED] ...
https://dev.mysql.com/doc/refman/5.7/en/replica-logs-status.html
The metadata in this repository includes the connection configuration, the replication user account details, the SSL settings for the connection, and the file name and position where the replication I/O thread is currently reading from the source's ... A replica server creates two replication metadata repositories, the connection metadata repository and the applier metadata ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-source.html
--show-slave-auth-info Command-Line Format --show-slave-auth-info[={OFF|ON}] Type Boolean Default Value OFF Display replica user names and passwords in the output of SHOW SLAVE HOSTS on the source server for replicas started with the --report-user ... This section describes the server options and system variables that you can use on replication source ...
https://dev.mysql.com/doc/refman/5.7/en/select.html
SELECT [ALL | DISTINCT | DISTINCTROW ] [HIGH_PRIORITY] [STRAIGHT_JOIN] [SQL_SMALL_RESULT] [SQL_BIG_RESULT] [SQL_BUFFER_RESULT] [SQL_CACHE | SQL_NO_CACHE] [SQL_CALC_FOUND_ROWS] select_expr [, select_expr] ... [into_option] [FROM table_references ...
https://dev.mysql.com/doc/refman/5.7/en/show-slave-hosts.html
User: The replica server user name as, specified on the replica with the --report-user option. SHOW SLAVE HOSTS Displays a list of replicas currently registered with the source. SHOW SLAVE HOSTS should be executed on a server that acts as a ...
https://dev.mysql.com/doc/refman/5.7/en/sys-sys-get-config.html
By convention, routines that call sys_get_config() first check whether the corresponding user-defined variable exists and is non-NULL. If the variable does not exist or is NULL, the routine reads the option value from the table and sets the ...
https://dev.mysql.com/doc/refman/5.7/en/thread-pool-operation.html
A statement becomes blocked if it encounters a disk I/O operation or a user level lock (row lock or table lock). While a thread executes a statement from a user connection, Performance Schema instrumentation accounts thread activity to the user ...