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/replication-multi-source-configuration.html
Replicas in a multi-source replication topology require TABLE repositories for the connection metadata repository and applier metadata repository, as specified by the master_info_repository and relay_log_info_repository system variables. A ...
https://dev.mysql.com/doc/refman/5.7/en/replication-problems.html
If the replica is running, check whether it established a connection to the source. Then make the replica's table identical to the source's and run START SLAVE. If you are sure that the replica started out perfectly synchronized with the source, and ... If you have followed the instructions but your replication setup is not working, the first thing to do is check the error log for ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-read-only.html
Note The instructions in this section place the server to be backed up in a state that is safe for backup methods that get the data from the server, such as mysqldump (see Section 4.5.4, “mysqldump — A Database Backup Program”). You should not ...
https://dev.mysql.com/doc/refman/5.7/en/rewriting-subqueries.html
MySQL Server supports multiple-table DELETE statements that can be used to efficiently delete rows based on information from one table or even from many tables at the same time. Sometimes there are other ways to test membership in a set of values ...
https://dev.mysql.com/doc/refman/5.7/en/row-constructor-optimization.html
Consider the following table, which has a primary key on (c1, c2, c3): CREATE TABLE t1 ( c1 INT, c2 INT, c3 INT, c4 CHAR(100), PRIMARY KEY(c1,c2,c3) ); In this query, the WHERE clause uses all columns in the index. row *************************** ...
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html
variable: { user_var_name | param_name | local_var_name | {GLOBAL | @@GLOBAL.} system_var_name | [SESSION | @@SESSION. | @@] system_var_name } SET syntax for variable assignment enables you to assign values to different types of variables that ...
https://dev.mysql.com/doc/refman/5.7/en/show-procedure-status.html
To use either statement, you must be the owner of the routine or have SELECT access to the mysql.proc table. Stored routine information is also available from the INFORMATION_SCHEMA PARAMETERS and ROUTINES tables. See Section 24.3.15, “The ...
https://dev.mysql.com/doc/refman/5.7/en/show-variables.html
System variable information is also available from these sources: Performance Schema tables. SHOW [GLOBAL | SESSION] VARIABLES [LIKE 'pattern' | WHERE expr] Note The value of the show_compatibility_56 system variable affects the information ...
https://dev.mysql.com/doc/refman/5.7/en/sys-ps-thread-trx-info.html
The information includes the current transaction, and the statements it has already executed, derived from the Performance Schema events_transactions_current and events_statements_history tables. The value should match the THREAD_ID column from some ... Returns a JSON object containing information about a given ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-auto-increment-columns.html
This view indicates which tables have AUTO_INCREMENT columns and provides information about those columns, such as the current and maximum column values and the usage ratio (ratio of used to possible values). Tables in these schemas are excluded ...