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/replication-rules-table-options.html
Important Table-level replication filters are only applied to tables that are explicitly mentioned and operated on in the query. The replica checks for and evaluates table options only if either of the following two conditions is true: No matching ...
https://dev.mysql.com/doc/refman/5.7/en/replication-semisync.html
Important With semisynchronous replication, if the source crashes and a failover to a replica is carried out, the failed source should not be reused as the replication source server, and should be discarded. In addition to the built-in asynchronous ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-backups-mysqldump.html
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 ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-partitioning.html
Important You should not use --replicate-do-db for this purpose when using statement-based replication, since statement-based replication causes this option's effects to vary according to the database that is currently selected. There may be ...
https://dev.mysql.com/doc/refman/5.7/en/replication-solutions-scaleout.html
The important thing is to have a unified interface for connecting for reads, connecting for writes, doing a read, and doing a write. You can use replication as a scale-out solution; that is, where you want to split up the load of database queries ...
https://dev.mysql.com/doc/refman/5.7/en/reset-master.html
RESET MASTER Warning Use this statement with caution to ensure you do not lose any wanted binary log file data and GTID execution history. For a server where binary logging is enabled (log_bin is ON), RESET MASTER deletes all existing binary log ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
(This capability can be disabled with the --skip-symbolic-links option.) This is especially important if you run mysqld as root, because anyone that has write access to the server's data directory then could delete any file in the system! See ...
https://dev.mysql.com/doc/refman/5.7/en/select-optimization.html
Indexes are especially important for queries that reference different tables, using features such as joins and foreign keys. Queries, in the form of SELECT statements, perform all the lookup operations in the database. Tuning these statements is a ...
https://dev.mysql.com/doc/refman/5.7/en/server-configuration.html
When tuning a MySQL server, the two most important variables to configure are key_buffer_size and table_open_cache. The MySQL server, mysqld, has many command options and system variables that can be set at startup to configure its operation. To ...
https://dev.mysql.com/doc/refman/5.7/en/set-global-sql-slave-skip-counter.html
When using this statement, it is important to understand that the binary log is actually organized as a sequence of groups known as event groups. SET GLOBAL sql_slave_skip_counter = N This statement skips the next N events from the master. This is ...