Home IT Linux Windows Database Network Programming Server Mobile  
           
  Home \ Database \ MySQL master-slave delay problem     - CUDA (including GPU card driver) installation process under Ubuntu (Linux)

- Linux security-related basics (Linux)

- Linux Getting Started tutorial: build your own Vim (Linux)

- When Linux Detailed time zone and common function of time (Linux)

- MySQL event table to achieve timing build a small note (Database)

- Eclipse Android development environment installation (Linux)

- Using nmcli commands to manage network in RedHat / CentOS 7.x (Linux)

- Get basic information about Linux server script (Server)

- java.net.NoRouteToHostException of Hadoop problem: no route to host (Server)

- MD5 and simple to use (Linux)

- Verify the character set on MyCAT (Database)

- Java static internal class (Programming)

- Linux command in the dialog whiptail (Linux)

- Linux Network Programming - raw socket Example: sending a UDP packet (Programming)

- Fedora 8 configured Heartbeat (Linux)

- Struts2 dynamic call DMI and error Solution (Programming)

- Kubernetes cluster deployment (Server)

- Depth understanding of the use of Spring Redis (Programming)

- Linux, C programming language library file handling and preparation of Makefile (Programming)

- Transplant spider to MySQL 5.6 (Database)

 
         
  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.
     
         
       
         
  More:      
 
- Ubuntu 15.04 / 14.04 install Ubuntu After Install 2.6 (Linux)
- Linux Fundamentals of the text, data flow processing orders (Linux)
- crontab cause CPU exception Analysis and Processing (Linux)
- Android official recommendation: DialogFragment create dialog (Programming)
- Linux environment RabbitMQ installation and monitoring of plug-in installation (Linux)
- Java Builder mode (Programming)
- Linux common network tools: batch scanning of nmap hosting service (Linux)
- HTML5 Application Cache (Programming)
- Oracle: RETURNING clause (Database)
- Basic Operation Linux files and directories (Linux)
- Thinking in Java study notes - initialization and cleanup (Programming)
- IIS virtual host of safety knowledge (Linux)
- BusyBox build root file system (Linux)
- Ubuntu manually set the DSL broadband connection (Linux)
- Cache implementation APP interacts with the server-side interface control Session (Server)
- After you change the GRUB boot disk partition repair (Linux)
- Oracle DataGuard principles and basic configuration (Database)
- jQuery get value drop-down list and select text (Programming)
- Use Ambari rapid deployment Hadoop big data environment (Server)
- Understanding Linux firewall Iptables (Linux)
     
           
     
  CopyRight 2002-2016 newfreesoft.com, All Rights Reserved.