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-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 ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
For example: ALTER USER user IDENTIFIED BY 'auth_string'; Important Under some circumstances, SET PASSWORD may be recorded in server logs or on the client side in a history file such as ~/.mysql_history, which means that cleartext passwords may be ... SET PASSWORD [FOR user] = password_option password_option: { 'auth_string' | PASSWORD('auth_string') } The SET PASSWORD statement assigns a password to a MySQL user ...