sync_binlog =1 后有所提高,原来默认是 0 , 在 io 写很低的时候 Exec_Master_Log_Pos 就可能不变化
----total-cpu-usage---- -dsk/total- -net/total- ---paging-- ---system--
usr sys idl wai hiq siq| read writ| recv send| in out | int csw
12 2 85 0 0 0| 23M 10M| 0 0 |8858B 13k|9401 35k
5 0 94 2 0 0|8192B 268k| 566k 553k| 0 0 |9062 904
4 0 93 2 0 0| 972k 260k| 680k 675k| 0 0 |9078 1092
4 0 95 1 0 0|4096B 96k|2163k 2171k| 0 0 | 23k 1166
5 0 95 0 0 0| 544k 7272k|6727k 6758k|8192B 0 | 25k 3557
4 0 93 2 0 0|8192B 348k|5035k 5287k| 0 0 |9239 1189
4 0 93 2 0 0| 24k 324k| 684k 734k| 0 0 | 13k 1312
5 0 93 2 0 0| 116k 324k|3260k 3272k| 0 0 | 15k 1170
4 0 93 2 0 0| 200k 840k|3221k 3540k| 0 0 | 11k 1174
4 0 95 1 0 0| 0 64k|1052k 1066k| 0 0 |8521 801
5 0 95 0 0 0| 0 60k| 642k 605k| 0 0 |8366 876
5 0 95 0 0 0| 0 56k| 666k 652k| 0 0 |9142 939
4 0 95 1 0 0| 60k 452k| 691k 677k| 0 0 | 11k 1191
7 1 92 0 0 0| 0 8192B| 997k 1090k| 0 0 | 11k 1339
5 0 95 0 0 0|4096B 8532k| 660k 631k| 0 0 | 12k 1980
4 0 96 0 0 0| 0 64k|2906k 3024k| 0 0 | 23k 765
4 0 96 0 0 0| 0 0 |6685k 6642k| 0 0 | 19k 749
4 0 96 0 0 0| 0 0 |3793k 3754k| 0 0 |9121 729
5 0 93 1 0 0| 32k 68k| 700k 663k| 0 0 | 13k 2067
5 0 95 0 0 0| 0 312k|4309k 4509k| 0 0 | 16k 1608
5 0 95 0 0 0|4096B 128k|3281k 3290k| 0 0 | 13k 953
4 0 96 0 0 0| 0 0 |1323k 1297k| 0 0 | 11k 911
5 0 95 0 0 0| 0 0 | 765k 703k| 0 0 | 11k 1190
4 0 95 0 0 0|4096B 68k| 773k 729k| 0 0 | 10k 1154
6 2 92 0 0 0|1012k 932k| 900k 981k| 20k 0 | 18k 5842
4 1 94 0 0 0|4096B 292k| 909k 953k| 0 0 | 12k 1624
4 0 96 0 0 0| 0 0 | 797k 746k| 0 0 | 13k 917
4 0 95 0 0 0| 0 112k|3545k 3505k| 0 0 | 23k 818
mysql> show slave status\G;
*************************** 1. row ***************************
Slave_IO_State: Waiting for master to send event
Master_Host: 10.0.1.10
Master_User: slaver
Master_Port: 3306
Connect_Retry: 60
Master_Log_File: mysql-bin.006524
Read_Master_Log_Pos: 46913321
Relay_Log_File: rep_relay_log.003406
Relay_Log_Pos: 653699241
Relay_Master_Log_File: mysql-bin.006509
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
Replicate_Do_DB:
Replicate_Ignore_DB:
Replicate_Do_Table:
Replicate_Ignore_Table:
Replicate_Wild_Do_Table:
Replicate_Wild_Ignore_Table:
Last_Errno: 0
Last_Error:
Skip_Counter: 0
Exec_Master_Log_Pos: 653699095
Relay_Log_Space: 16153580669
Until_Condition: None
Until_Log_File:
Until_Log_Pos: 0
Master_SSL_Allowed: No
Master_SSL_CA_File:
Master_SSL_CA_Path:
Master_SSL_Cert:
Master_SSL_Cipher:
Master_SSL_Key:
Seconds_Behind_Master: 110932
Master_SSL_Verify_Server_Cert: No
Last_IO_Errno: 0
Last_IO_Error:
Last_SQL_Errno: 0
Last_SQL_Error:
Replicate_Ignore_Server_Ids:
Master_Server_Id: 603333
1 row in set (0.00 sec)
ERROR:
No query specified