PostgreSQL 9.2.9 基于归档主从,从的赶不上master 相差大概6天左右

bst 发布于 2015/01/16 17:26
阅读 499
收藏 1

PostgreSQL 9.2.9 基于归档主从,从的赶不上master 相差大概6天左右

在master上面一般周末产生的log比较快,一分钟大概产生25个log左右,在从的上面大概一分钟可以恢复40个左右。

但是平时master上面一分钟生成数3个左右log,从的上面一分钟也恢复大概3个左右。最近发现比较慢了。

主从硬件配置都很高,基本都是180G以上内存,cpuIntel(R) Xeon(R) CPU           X5650  @ 2.67GHz*2

硬盘做的raid10,data目录、pg_log和pg_xlog目录都分别放在不同的分区。

slave上面恢复的速度如下:

015-01-16 00:00:00 CST [7459]: [14870-1] user=,db=,host= LOG:  restored log file "00000001000039B400000026" from archive
2015-01-16 00:00:03 CST [7459]: [14871-1] user=,db=,host= LOG:  restored log file "00000001000039B400000027" from archive
2015-01-16 00:00:05 CST [7459]: [14872-1] user=,db=,host= LOG:  restored log file "00000001000039B400000028" from archive
2015-01-16 00:00:11 CST [7459]: [14873-1] user=,db=,host= LOG:  restored log file "00000001000039B400000029" from archive
2015-01-16 00:00:15 CST [7459]: [14874-1] user=,db=,host= LOG:  restored log file "00000001000039B40000002A" from archive
2015-01-16 00:00:17 CST [7459]: [14875-1] user=,db=,host= LOG:  restored log file "00000001000039B40000002B" from archive
2015-01-16 00:00:19 CST [7459]: [14876-1] user=,db=,host= LOG:  restored log file "00000001000039B40000002C" from archive
2015-01-16 00:00:23 CST [7459]: [14877-1] user=,db=,host= LOG:  restored log file "00000001000039B40000002D" from archive
2015-01-16 00:00:25 CST [7459]: [14878-1] user=,db=,host= LOG:  restored log file "00000001000039B40000002E" from archive
2015-01-16 00:00:26 CST [7459]: [14879-1] user=,db=,host= LOG:  restored log file "00000001000039B40000002F" from archive
2015-01-16 00:00:28 CST [7459]: [14880-1] user=,db=,host= LOG:  restored log file "00000001000039B400000030" from archive
2015-01-16 00:00:31 CST [7459]: [14881-1] user=,db=,host= LOG:  restored log file "00000001000039B400000031" from archive
2015-01-16 00:00:33 CST [7459]: [14882-1] user=,db=,host= LOG:  restored log file "00000001000039B400000032" from archive
2015-01-16 00:00:34 CST [7459]: [14883-1] user=,db=,host= LOG:  restored log file "00000001000039B400000033" from archive
2015-01-16 00:00:40 CST [7459]: [14884-1] user=,db=,host= LOG:  restored log file "00000001000039B400000034" from archive
2015-01-16 00:00:42 CST [7459]: [14885-1] user=,db=,host= LOG:  restored log file "00000001000039B400000035" from archive
2015-01-16 00:00:44 CST [7459]: [14886-1] user=,db=,host= LOG:  restored log file "00000001000039B400000036" from archive
2015-01-16 00:00:46 CST [7459]: [14887-1] user=,db=,host= LOG:  restored log file "00000001000039B400000037" from archive
2015-01-16 00:00:51 CST [7459]: [14888-1] user=,db=,host= LOG:  restored log file "00000001000039B400000038" from archive
2015-01-16 00:00:59 CST [7459]: [14889-1] user=,db=,host= LOG:  restored log file "00000001000039B400000039" from archive
2015-01-16 00:01:01 CST [7459]: [14890-1] user=,db=,host= LOG:  restored log file "00000001000039B40000003A" from archive
2015-01-16 00:01:04 CST [7459]: [14891-1] user=,db=,host= LOG:  restored log file "00000001000039B40000003B" from archive

系统负载还好,

17:25:54 up 122 days, 13:31,  4 users,  load average: 4.88, 6.14, 5.95

硬盘读写如下:

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
          15.54    0.00    2.68    7.93    0.00   73.85


Device:         rrqm/s   wrqm/s     r/s     w/s    rMB/s    wMB/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.22     4.82    0.19    1.77     0.00     0.03    30.75     0.00    2.13   1.33   0.26
sdb               0.00     0.00   65.48  241.38     1.96     4.87    45.60     0.06    1.53   1.03  31.46
sdc               0.00     0.00    0.10    1.87     0.00     0.56   589.42     0.10   48.55   3.06   0.60
sdd               0.00     0.00   77.85  638.36     2.05     5.45    21.44     0.34    0.48   0.35  24.90
sde               0.00     0.00   57.71  229.46     2.22     4.64    48.86     0.22    0.75   1.01  28.86


avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           8.49    0.00    3.51   23.30    0.00   64.69


Device:         rrqm/s   wrqm/s     r/s     w/s    rMB/s    wMB/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     1.00    0.50    1.50     0.00     0.01    14.00     0.01    5.00   5.00   1.00
sdb               0.00     0.00   22.00 1058.50     0.54    13.64    26.88   127.36  118.72   0.92  99.50
sdc               0.00     0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sdd               0.00     0.00    4.00 1578.00     0.05    12.67    16.47    30.71   19.30   0.61  96.00
sde               0.00     0.00    1.00  561.50     0.01     6.36    23.21     4.46    7.92   0.49  27.50


avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           7.85    0.00    3.31   16.46    0.00   72.38


Device:         rrqm/s   wrqm/s     r/s     w/s    rMB/s    wMB/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     3.50    0.00    2.50     0.00     0.02    19.20     0.11   46.00  18.00   4.50
sdb               0.00     0.00    8.50  596.00     0.26    44.66   152.17   128.00  190.65   1.65 100.00
sdc               0.00     0.00    0.00    0.50     0.00     0.00     8.00     0.00    0.00   0.00   0.00
sdd               0.00     0.00    1.00 1347.50     0.01    10.74    16.32    31.99   23.15   0.74 100.00
sde               0.00     0.00    2.50    8.00     0.02     1.85   364.95     0.07    6.19   5.71   6.00


avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           8.14    0.00    2.95   17.40    0.00   71.51


Device:         rrqm/s   wrqm/s     r/s     w/s    rMB/s    wMB/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     0.50    0.00    1.00     0.00     0.01    12.00     0.01   10.00  10.00   1.00
sdb               0.00     0.00    8.00 1576.50     0.42    83.84   108.92   123.37   81.63   0.63 100.00
sdc               0.00     0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sdd               0.00     0.00    1.50  792.50     0.01     6.47    16.71    14.72   19.68   1.24  98.50
sde               0.00     0.00   13.50  478.00     0.14     7.43    31.57     3.71    7.55   0.44  21.50


root@testdb:~# iotop -bto |grep postgres
17:36:33 25737 be/4 postgres   37.00 K/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:33 25742 be/4 postgres    0.00 B/s  258.97 K/s  ?unavailable?  postgres: checkpointer process
17:36:33 25744 be/4 postgres    0.00 B/s  221.97 K/s  ?unavailable?  postgres: writer process
17:36:34 25737 be/4 postgres  573.62 K/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:34 25742 be/4 postgres    0.00 B/s   16.84 M/s  ?unavailable?  postgres: checkpointer process
17:36:34 25744 be/4 postgres    0.00 B/s   69.53 K/s  ?unavailable?  postgres: writer process
17:36:35 25742 be/4 postgres    0.00 B/s   15.71 M/s  ?unavailable?  postgres: checkpointer process
17:36:35 32495 be/4 postgres    0.00 B/s    3.51 K/s  ?unavailable?  pgbouncer -d /etc/pgbouncer/pgbouncer.ini
17:36:36 25737 be/4 postgres  174.95 K/s    7.00 K/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:36 25742 be/4 postgres    0.00 B/s   15.64 M/s  ?unavailable?  postgres: checkpointer process
17:36:36 25744 be/4 postgres    0.00 B/s    7.00 K/s  ?unavailable?  postgres: writer process
17:36:37 25737 be/4 postgres  160.45 K/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:37 25742 be/4 postgres    0.00 B/s   15.55 M/s  ?unavailable?  postgres: checkpointer process
17:36:38 25737 be/4 postgres   91.02 K/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:38 25742 be/4 postgres    0.00 B/s   17.07 M/s  ?unavailable?  postgres: checkpointer process
17:36:38 25744 be/4 postgres    0.00 B/s   14.00 K/s  ?unavailable?  postgres: writer process
17:36:39 25737 be/4 postgres   20.35 K/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:39 25742 be/4 postgres    0.00 B/s   15.92 M/s  ?unavailable?  postgres: checkpointer process
17:36:41 25737 be/4 postgres  627.51 K/s    6.90 K/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:41 25742 be/4 postgres    0.00 B/s   15.35 M/s  ?unavailable?  postgres: checkpointer process
17:36:41 25744 be/4 postgres    0.00 B/s   27.58 K/s  ?unavailable?  postgres: writer process
17:36:42 25737 be/4 postgres 1537.67 K/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:42 25742 be/4 postgres    0.00 B/s   15.48 M/s  ?unavailable?  postgres: checkpointer process
17:36:42 25744 be/4 postgres    0.00 B/s   20.87 K/s  ?unavailable?  postgres: writer process
17:36:43 25737 be/4 postgres    7.13 M/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:43 25742 be/4 postgres    0.00 B/s   15.44 M/s  ?unavailable?  postgres: checkpointer process
17:36:43 25744 be/4 postgres    0.00 B/s  204.52 K/s  ?unavailable?  postgres: writer process
17:36:44 25742 be/4 postgres    0.00 B/s   11.66 M/s  ?unavailable?  postgres: checkpointer process
17:36:45 25737 be/4 postgres  276.98 K/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:45 25742 be/4 postgres    0.00 B/s   20.85 M/s  ?unavailable?  postgres: checkpointer process
17:36:46 25737 be/4 postgres    4.98 M/s   27.91 K/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:46 25742 be/4 postgres    0.00 B/s   15.60 M/s  ?unavailable?  postgres: checkpointer process
17:36:46 25744 be/4 postgres    0.00 B/s  160.50 K/s  ?unavailable?  postgres: writer process
17:36:48 25737 be/4 postgres 1856.96 K/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:48 25742 be/4 postgres    0.00 B/s   15.48 M/s  ?unavailable?  postgres: checkpointer process
17:36:48 25744 be/4 postgres    0.00 B/s   13.91 K/s  ?unavailable?  postgres: writer process
17:36:49 25737 be/4 postgres  501.03 K/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:49 25742 be/4 postgres    0.00 B/s   15.86 M/s  ?unavailable?  postgres: checkpointer process
17:36:50 25737 be/4 postgres 1148.28 K/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:50 25742 be/4 postgres    0.00 B/s   15.43 M/s  ?unavailable?  postgres: checkpointer process
17:36:50 25744 be/4 postgres    0.00 B/s   34.69 K/s  ?unavailable?  postgres: writer process
17:36:51 25737 be/4 postgres    6.93 K/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:51 25742 be/4 postgres    0.00 B/s   16.17 M/s  ?unavailable?  postgres: checkpointer process
17:36:52 25737 be/4 postgres  187.82 K/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:52 25742 be/4 postgres    0.00 B/s   15.50 M/s  ?unavailable?  postgres: checkpointer process
17:36:53 25737 be/4 postgres  227.78 K/s    6.90 K/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:53 25742 be/4 postgres    0.00 B/s   15.46 M/s  ?unavailable?  postgres: checkpointer process
17:36:53 25744 be/4 postgres    0.00 B/s    6.90 K/s  ?unavailable?  postgres: writer process
17:36:54 25737 be/4 postgres  104.91 K/s    0.00 B/s  ?unavailable?  postgres: startup process   recovering 0000000100003A1200000010
17:36:54 25742 be/4 postgres    0.00 B/s   15.00 M/s  ?unavailable?  postgres: checkpointer process

请有经验帮忙看看,谢谢。

加载中
0
kenyon_君羊
kenyon_君羊
master上生成的xlog快不快?相比较slave上的恢复。 @mark35
0
b
bst
两边一样的速度的。
0
mark35
mark35
从连接主服务器正常么
0
b
bst

肯定正常的。

0
digoal
digoal
从库可以考虑更换IOPS能力更好的硬盘里.
0
kenyon_君羊
kenyon_君羊
从库的sdb与sdd的IO有问题,%util满了
0
b
bst

不是一直都100%的

0
b
bst

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           7.48    0.00    2.38    0.29    0.00   89.85

Device:         rrqm/s   wrqm/s     r/s     w/s    rMB/s    wMB/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     3.50    0.00    2.00     0.00     0.02    22.00     0.01    5.00   2.50   0.50
sdb               0.00     0.00   28.50    4.00     0.96     0.40    85.54     0.12    3.69   2.15   7.00
sdc               0.00     0.00    0.50   31.00     0.00    13.19   857.78     3.15   99.84   3.81  12.00
sdd               0.00     0.00    0.00    1.50     0.00     0.20   277.33     0.06  100.00  36.67   5.50
sde               0.00     0.00    0.50    0.00     0.00     0.00     8.00     0.00    0.00   0.00   0.00

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           6.08    0.00    2.31    3.29    0.00   88.32

Device:         rrqm/s   wrqm/s     r/s     w/s    rMB/s    wMB/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     1.00    0.00    1.00     0.00     0.01    16.00     0.00    0.00   0.00   0.00
sdb               0.00     0.00   37.50  493.50     1.38     3.44    18.58     4.62    8.70   0.96  51.00
sdc               0.00     0.00    0.00    1.00     0.00     0.03    60.00     0.01    5.00   5.00   0.50
sdd               0.00     0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sde               0.00     0.00    0.50    5.50     0.00     1.12   382.00     0.03    5.00   3.33   2.00

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
          11.15    0.00    3.03    8.41    0.00   77.41

Device:         rrqm/s   wrqm/s     r/s     w/s    rMB/s    wMB/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     2.50    0.00    3.00     0.00     0.02    14.67     0.03   10.00   3.33   1.00
sdb               0.00     0.00   41.00    0.00     0.92     0.00    45.85     2.88   10.85   9.27  38.00
sdc               0.00     0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sdd               0.00     0.00    0.00  217.50     0.00     1.70    16.02     1.37    6.30   0.21   4.50
sde               0.00     0.00    0.00  173.50     0.00    17.12   202.14    28.96  163.03   5.24  91.00

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           8.94    0.00    3.40   21.26    0.00   66.40

Device:         rrqm/s   wrqm/s     r/s     w/s    rMB/s    wMB/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sdb               0.00     0.00   70.00 1467.00     2.19    12.79    19.96    21.23   14.05   0.65 100.00
sdc               0.00     0.00    0.00   36.50     0.00    15.92   893.48     8.76  240.00   9.32  34.00
sdd               0.00     0.00    0.00    1.00     0.00     0.17   340.00     0.03   30.00  30.00   3.00
sde               0.00     0.00    0.00  268.00     0.00    46.37   354.33    20.89   80.50   2.54  68.00

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           7.87    0.00    2.64    0.93    0.00   88.56

Device:         rrqm/s   wrqm/s     r/s     w/s    rMB/s    wMB/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     1.00    0.00    1.00     0.00     0.01    16.00     0.00    0.00   0.00   0.00
sdb               0.00     0.00   58.00    0.00     2.48     0.00    87.72     0.77   49.14   2.84  16.50
sdc               0.00     0.00    0.50    1.00     0.00     0.03    42.67     0.01    3.33   3.33   0.50
sdd               0.00     0.00    0.50    8.00     0.00     0.05    12.24     0.01    0.59   0.59   0.50
sde               0.00     0.00    0.00    2.50     0.00     0.71   580.80     0.03   10.00   6.00   1.50

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           9.32    0.00    2.78    0.45    0.00   87.44

Device:         rrqm/s   wrqm/s     r/s     w/s    rMB/s    wMB/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     1.00    0.00    3.50     0.00     0.02    10.29     0.00    0.00   0.00   0.00
sdb               0.00     0.00   53.50    1.50     1.98     0.23    82.25     0.29    5.27   1.91  10.50
sdc               0.00     0.00    0.00   25.50     0.00    10.69   858.67     2.44   95.69   3.92  10.00
sdd               0.00     0.00    0.00  371.00     0.00     2.93    16.16     1.93    5.19   0.18   6.50
sde               0.00     0.00    0.50    2.00     0.00     0.65   531.20     0.01    6.00   4.00   1.00

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           6.88    0.00    4.24   22.94    0.00   65.93

Device:         rrqm/s   wrqm/s     r/s     w/s    rMB/s    wMB/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00     0.00    0.00    0.00     0.00     0.00     0.00     0.00    0.00   0.00   0.00
sdb               0.00     0.00   22.00 1133.50     0.79    11.73    22.19    57.70   46.41   0.80  93.00
sdc               0.00     0.00    0.50    0.00     0.00     0.00     8.00     0.00    0.00   0.00   0.00
sdd               0.00     0.00    0.00    1.00     0.00     0.18   376.00     0.10  105.00 105.00  10.50
sde               0.00     0.00    1.00 1882.00     0.00    82.53    89.77    26.74   14.13   0.45  84.50

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
          12.05    0.00    2.50    2.44    0.00   83.01

Device:         rrqm/s   wrqm/s     r/s     w/s    rMB/s    wMB/s avgrq-sz avgqu-sz   await  svctm  %util
sda               0.00    17.00    0.00    5.50     0.00     0.09    32.73     0.03    4.55   4.55   2.50
sdb               0.00     0.00   85.00    0.00     2.37     0.00    57.04     0.78   57.12   2.24  19.00
sdc               0.00     0.00    0.00    1.00     0.00     0.03    60.00     0.00    0.00   0.00   0.00
sdd               0.00     0.00    0.50  613.00     0.00     4.82    16.11     3.23    5.26   0.19  11.50
sde               0.00     0.00    1.50  401.00     0.01    12.28    62.52     3.62    9.33   0.63  25.50

avg-cpu:  %user   %nice %system %iowait  %steal   %idle
           9.15    0.00    3.20    1.52    0.00   86.13

 

2015-01-22 17:45:45 CST [13591]: [14353-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000D0" from archive
2015-01-22 17:45:46 CST [13591]: [14354-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000D1" from archive
2015-01-22 17:45:48 CST [13591]: [14355-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000D2" from archive
2015-01-22 17:45:49 CST [13591]: [14356-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000D3" from archive
2015-01-22 17:45:50 CST [13591]: [14357-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000D4" from archive
2015-01-22 17:45:52 CST [13591]: [14358-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000D5" from archive
2015-01-22 17:45:53 CST [13591]: [14359-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000D6" from archive
2015-01-22 17:45:54 CST [13591]: [14360-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000D7" from archive
2015-01-22 17:45:55 CST [13591]: [14361-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000D8" from archive
2015-01-22 17:45:56 CST [13591]: [14362-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000D9" from archive
2015-01-22 17:45:58 CST [13591]: [14363-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000DA" from archive
2015-01-22 17:45:59 CST [13591]: [14364-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000DB" from archive
2015-01-22 17:46:00 CST [13591]: [14365-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000DC" from archive
2015-01-22 17:46:01 CST [13591]: [14366-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000DD" from archive
2015-01-22 17:46:02 CST [13591]: [14367-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000DE" from archive
2015-01-22 17:46:03 CST [13591]: [14368-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000DF" from archive
2015-01-22 17:46:04 CST [13591]: [14369-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000E0" from archive
2015-01-22 17:46:05 CST [13591]: [14370-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000E1" from archive
2015-01-22 17:46:06 CST [13591]: [14371-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000E2" from archive
2015-01-22 17:46:07 CST [13591]: [14372-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000E3" from archive
2015-01-22 17:46:09 CST [13591]: [14373-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000E4" from archive
2015-01-22 17:46:10 CST [13591]: [14374-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000E5" from archive
2015-01-22 17:46:12 CST [13591]: [14375-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000E6" from archive
2015-01-22 17:46:13 CST [13591]: [14376-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000E7" from archive
2015-01-22 17:46:15 CST [13591]: [14377-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000E8" from archive
2015-01-22 17:46:16 CST [13591]: [14378-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000E9" from archive
2015-01-22 17:46:18 CST [13591]: [14379-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000EA" from archive
2015-01-22 17:46:19 CST [13591]: [14380-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000EB" from archive
2015-01-22 17:46:20 CST [13591]: [14381-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000EC" from archive
2015-01-22 17:46:21 CST [13591]: [14382-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000ED" from archive
2015-01-22 17:46:22 CST [13591]: [14383-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000EE" from archive
2015-01-22 17:46:23 CST [13591]: [14384-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000EF" from archive
2015-01-22 17:46:24 CST [13591]: [14385-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000F0" from archive
2015-01-22 17:46:25 CST [13591]: [14386-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000F1" from archive
2015-01-22 17:46:26 CST [13591]: [14387-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000F2" from archive
2015-01-22 17:46:27 CST [13591]: [14388-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000F3" from archive
2015-01-22 17:46:28 CST [13591]: [14389-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000F4" from archive
2015-01-22 17:46:29 CST [13591]: [14390-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000F5" from archive
2015-01-22 17:46:30 CST [13591]: [14391-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000F6" from archive
2015-01-22 17:46:31 CST [13591]: [14392-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000F7" from archive
2015-01-22 17:46:32 CST [13591]: [14393-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000F8" from archive
2015-01-22 17:46:33 CST [13591]: [14394-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000F9" from archive
2015-01-22 17:46:34 CST [13591]: [14395-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000FA" from archive
2015-01-22 17:46:35 CST [13591]: [14396-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000FB" from archive
2015-01-22 17:46:36 CST [13591]: [14397-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000FC" from archive
2015-01-22 17:46:37 CST [13591]: [14398-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000FD" from archive
2015-01-22 17:46:38 CST [13591]: [14399-1] user=,db=,host= LOG:  restored log file "0000000100003A8A000000FE" from archive
2015-01-22 17:46:39 CST [13591]: [14400-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000000" from archive
2015-01-22 17:46:40 CST [13591]: [14401-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000001" from archive
2015-01-22 17:46:41 CST [13591]: [14402-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000002" from archive
2015-01-22 17:46:42 CST [13591]: [14403-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000003" from archive
2015-01-22 17:46:43 CST [13591]: [14404-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000004" from archive
2015-01-22 17:46:45 CST [13591]: [14405-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000005" from archive
2015-01-22 17:46:46 CST [13591]: [14406-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000006" from archive
2015-01-22 17:46:47 CST [13591]: [14407-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000007" from archive
2015-01-22 17:46:48 CST [13591]: [14408-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000008" from archive
2015-01-22 17:46:48 CST [13591]: [14409-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000009" from archive
2015-01-22 17:46:49 CST [13591]: [14410-1] user=,db=,host= LOG:  restored log file "0000000100003A8B0000000A" from archive
2015-01-22 17:46:51 CST [13591]: [14411-1] user=,db=,host= LOG:  restored log file "0000000100003A8B0000000B" from archive
2015-01-22 17:46:52 CST [13591]: [14412-1] user=,db=,host= LOG:  restored log file "0000000100003A8B0000000C" from archive
2015-01-22 17:46:53 CST [13591]: [14413-1] user=,db=,host= LOG:  restored log file "0000000100003A8B0000000D" from archive
2015-01-22 17:46:54 CST [13591]: [14414-1] user=,db=,host= LOG:  restored log file "0000000100003A8B0000000E" from archive
2015-01-22 17:46:55 CST [13591]: [14415-1] user=,db=,host= LOG:  restored log file "0000000100003A8B0000000F" from archive
2015-01-22 17:46:56 CST [13591]: [14416-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000010" from archive
2015-01-22 17:46:57 CST [13591]: [14417-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000011" from archive
2015-01-22 17:46:58 CST [13591]: [14418-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000012" from archive
2015-01-22 17:46:59 CST [13591]: [14419-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000013" from archive
2015-01-22 17:46:59 CST [13591]: [14420-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000014" from archive
2015-01-22 17:47:00 CST [13591]: [14421-1] user=,db=,host= LOG:  restored log file "0000000100003A8B00000015" from archive

现在是同步master17号的数据。反正周末都很快的,周一到周五很慢。

0
kenyon_君羊
kenyon_君羊
你周末的IO没有多大瓶颈啊,是不是平时还跑了其他东西
0
b
bst

今天在同步18号的数据,服务器有一个hadoop一直在跑的。我看io 也有100%的

返回顶部
顶部