PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.3Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/mysql-tips.html
However, even if mysql succeeds in reconnecting, your first connection has ended and all your previous session objects and settings are lost: temporary tables, the autocommit mode, and user-defined and session variables. Connection id: 1 Current ...
https://dev.mysql.com/doc/refman/5.7/en/optimize-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, OPTIMIZE TABLE generates a "cannot change ownership of the file" error unless mysqld is started by the root user. OPTIMIZE TABLE ...
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 ...