Shulou(Shulou.com)06/01 Report--

1. Alarm content: [seconds_behind_master] [INSERT LOW_PRIORITY IGNORE INT]

2. Log in to the database show slave status\ G; it is found that the slave delay is already 0!

3. Problem analysis:

1) the main direct cause of the delay caused by the visible title is INSERT. Checking whether there is / * pt-online-schema-change 102937 copy nibble*/ in the email SQL can directly determine whether it is caused by adding an index.

2) if you need to check ganglia (YZ) or grafana (KDDI) according to the general idea, to see if there is a system bottleneck or high concurrency.

3) analyze whether there are too many inserts in the alarm phase of binglog query!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.