DanBrother的部落格

drop procedure if exists sp_array_test;

DELIMITER //

Extracts, orders, and then prints grants for MySQL user accounts (pt-show-grants)

# Extracts, orders, and then prints grants for MySQL user accounts

MySQL Stored Procedure - Nested Loop Example

DELIMITER $$

Metabase H2 DB Migration to MySQL 5.7

#### On Aurora New MySQL ####################

MySQL 5.7 :  Steps for Upgrading Percona-Toolkit to the Latest Version

pt-online-schema-change --version

MySQL Slave - Skip Replication for A Particular Table

mysql> stop slave sql_thread;

Export Table Data:
mysql -utest_usr -p"xxx"-h127.0.0.1 -P3306 -e "select * from test_usr.test_table where flag = 1" > test_usr.test_table.txt 2>/dev/null

check_table_fragmentation.sql
>>
MySQL > source check_table_fragmentation.sql

cat log_file_viewer.sh
>>
#################################

There're MySQL global variable settings that will help for improving the speed of SQL apply in slave db.
That would solve the issue of slave lagging.