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/replication-multi-source.html
This is because the server IDs of replicas must be unique in a replication topology. When you do this on a multi-source replica, each channel on the replica has the specified number of applier threads, plus a coordinator thread to manage them. This ... MySQL multi-source replication enables a replica to receive transactions from multiple immediate sources in ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-mysqldump.html
If you use this approach, make sure you monitor the replication process to ensure that the time taken to run the backup does not affect the replica's ability to keep up with events from the source. For an example of how to configure this scenario, ... Using mysqldump to create a copy of a database enables you to capture all of the data in the database in a format that enables the information to be imported into another instance of MySQL Server (see Section 4.5.4, “mysqldump — A Database Backup ...
https://dev.mysql.com/doc/refman/5.7/en/replication.html
In this environment, all writes and updates must take place on the replication source server. This model can improve the performance of writes (since the source is dedicated to updates), while dramatically increasing read speed across an increasing ... Replication enables data from one MySQL database server (the source) to be copied to one or more MySQL database servers (the ...
https://dev.mysql.com/doc/refman/5.7/en/setting-environment-variables.html
To set a variable permanently, you can set it in a startup file or by using the interface provided by your system for this purpose. To do so, use this syntax: SET USER=your_name The syntax on Unix depends on your shell. To do this, set the value of ... Environment variables can be set at the command prompt to affect the current invocation of your command processor, or set permanently to affect future ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-trigger.html
SHOW CREATE TRIGGER trigger_name This statement shows the CREATE TRIGGER statement that creates the named trigger. This statement requires the TRIGGER privilege for the table associated with the trigger. This is a TIMESTAMP(2) value (with a ...row ...
https://dev.mysql.com/doc/refman/5.7/en/show-databases.html
If the server was started with the --skip-show-database option, you cannot use this statement at all unless you have the SHOW DATABASES privilege. MySQL implements databases as directories in the data directory, so this statement simply lists ...
https://dev.mysql.com/doc/refman/5.7/en/show-relaylog-events.html
End_log_pos The value of End_log_pos for this event in the source's binary log. SHOW RELAYLOG EVENTS [IN 'log_name'] [FROM pos] [LIMIT [offset,] row_count] [channel_option] channel_option: FOR CHANNEL channel Shows the events in the relay log of a ...
https://dev.mysql.com/doc/refman/5.7/en/show-triggers.html
This statement returns results only for databases and tables for which you have the TRIGGER privilege. This is the type of operation on the associated table for which the trigger activates. This is a TIMESTAMP(2) value (with a fractional part in ...
https://dev.mysql.com/doc/refman/5.7/en/signal.html
This is true whether the SQLSTATE value is specified directly in the SIGNAL statement or in a named condition referred to in the statement. If pval is 2, the same error is signaled, although the SQLSTATE value is specified using a named condition in ...SIGNAL provides error information to a handler, to an outer portion of the application, or to the ...
https://dev.mysql.com/doc/refman/5.7/en/silent-column-changes.html
For the ENUM and SET data types, this does not occur; they are created as declared. In some cases, MySQL silently changes column specifications from those given in a CREATE TABLE or ALTER TABLE statement. These might be changes to a data type, to ...