Home IT Linux Windows Database Network Programming Server Mobile  
  Home \ Database \ MySQL master-slave delay problem     - Each catalog Detailed Linux (Linux)

- How to deploy Icinga client (Server)

- When should I use Angular 2 (Programming)

- Oracle Linux 5.5 (64bit) Install Oracle 11gR2 RAC detailed tutorial (Database)

- Python class of operator overloading (Programming)

- CentOS / Linux SELinux Close (Linux)

- Tmux Crash Course: Tips and adjustment (Linux)

- RHEL5.x RHEL6.x replace CentOS yum source (Linux)

- Six Ways to view slides can be implemented Android (Programming)

- RHEL5.8 physical opportunities to Read-only file system (Linux)

- SSL VPN SSL VPN access to security websites patron (Linux)

- Zabbix monitoring different versions of RAID installation and monitoring and MySQL master-slave monitor (Server)

- Linux gprof oprofiling and performance testing tools (Linux)

- CentOS of NFS (Server)

- Transplant spider to MySQL 5.6 (Database)

- Using shell users or virtual users to login to pureftpd (Linux)

- OGG-03510 Problem (Database)

- Common Linux system performance monitoring command (Linux)

- Android SDK Manager can not update the domestic solutions (Linux)

- Nginx DHCP TFTP Kickstart set up automatic installation system (Server)

  MySQL master-slave delay problem
  Add Date : 2017-01-08      
  Recently came across several MySQL master-slave delay problem, there are colleagues complaining about this, a little tidy up

Problems two scenarios:

Scene 1. The main library alter operation takes about 10min, from the library to reproduce this alter the time, also spent about 10min time during the delay continues to increase;

Scene 2. On the main bank on a MyISAM table has a large number of additions and deletions to the operation, the statement from the business operation of the library in this table will often encounter a table lock, resulting in delay from the library;

Scenario Analysis:

Scene 1: In fact, this scenario is very simple, this takes a lot of time to alter the statement, in the main library spent so long after reproduction from the library must also spend a lot of time, naturally blocking synchronization;

Scenario 2:

First make sure the feature MyISAM, MyISAM tables are table-level locking, write mutually exclusive,

When synchronizing SQL thread CRUD data, if the select statement in the operating table, would produce table-level locking, blocking synchronization SQL thread, simply simulate the following table lock obstruction from the library SQL thread

MyISAM tables and in fact this is the case Scenario 1 is a type that is operating in the main library on the library from time to reproduce very slow / blocked, where the problem is reproducible SQL itself, this type of problem can only put these basic "issues SQL" on idle time to operate, belongs to a class of DBA's practices, if it is a normal period of time there is such a case, consider a table alone separated extension when from the library, shielding service request, so after the elimination of the delay, and then add it back, then replaced and another delay from the library, followed by the main library of the chase;

There is also a type from the main delay is synchronized from the library card write binlog this section, typical performance from the library system is a high IO wait, this case, depending on the type of business transaction group to modify and log refresh policy values, or replace the memory, the ability to improve hardware.
- Heartbeat cluster components Overview (Server)
- Summarize small problems encountered in the use Lua (Programming)
- Linux environment has been running Tomcat how to deploy the new Tomcat (Server)
- Ubuntu derivative version of the user and how to install SmartGit / HG 6.0.0 (Linux)
- Linux kernel update error, update-initramfs: failed Solution (Linux)
- The callback function used in C ++ (Programming)
- Java object initialization (Programming)
- Java Virtual Machine class loading mechanism and bytecode execution engine (Programming)
- Linux instructions and examples GPG encryption and decryption (Linux)
- Linux file permissions bit forced bits and adventure Comments (Linux)
- Nginx multi-domain certificate HTTPS (Server)
- Ubuntu 14.04 compile RT288x_SDK / toolchain / squashfs3.2-r2 Error (Linux)
- Hands to teach you to solve Ubuntu error message (Linux)
- Understand the profound discussion of some of the options for wireless encryption (Linux)
- Memcached distributed caching (Server)
- Linux System shutdown procedures (Linux)
- CentOS iptables firewall enabled (Linux)
- QBit development of micro-services (Server)
- The Samba service does not have permission to access (Server)
- Linux alpine use the command line to access Gmail (Linux)
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.