Mon Nov 15 09:35:18 PST 2010
- Previous message: [Slony1-general] how to troubleshoot slony replication lag?
- Next message: [Slony1-general] how to troubleshoot slony replication lag?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
I have to add, the slave server is a bit sluggish at the command-line and it didn't used to be that way. load average is over 3 due to processes blocked on I/O. Looks like the system is I/O consists mainly of writing to disk ("bo" blocks out in vmstat 1). There is nothing on this system but postgres and slon. I've asked the on-site IT guys to eye ball the server to make sure there isn't a failed disk... # vmstat 1 procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------ r b swpd free buff cache si so bi bo in cs us sy id wa st 1 2 200 49656 51856 7659972 0 0 110 496 20 14 1 1 92 6 0 0 3 200 49656 51856 7659972 0 0 0 7200 1910 1522 0 1 82 17 0 0 3 200 49656 51856 7659972 0 0 0 6224 1738 1233 0 1 75 24 0 0 3 200 49656 51856 7659972 0 0 0 6176 1741 1283 0 1 75 24 0 0 3 200 49656 51856 7660092 0 0 0 6440 1957 1925 2 1 85 13 0 0 0 200 53408 51892 7655436 0 0 0 3880 1749 2263 3 1 87 9 0 0 0 200 53284 51892 7655716 0 0 0 284 1496 3169 6 1 92 0 0 1 0 200 53036 51892 7656056 0 0 0 264 1516 3186 6 1 92 0 0 0 0 200 52912 51892 7656336 0 0 0 272 1499 3222 7 1 92 0 0 1 0 200 68288 51892 7641144 0 0 0 656 2045 3826 5 1 94 0 0 0 2 200 67420 51892 7641888 0 0 0 6028 2330 3807 4 1 91 4 0 1 0 200 67420 51900 7642220 0 0 0 5868 1908 1723 1 1 87 11 0 0 0 200 66056 51900 7643764 0 0 0 1024 2136 4070 6 1 93 0 0 0 0 200 64692 51904 7644780 0 0 0 736 2027 3776 5 1 94 0 0 1 0 200 63204 51904 7646144 0 0 0 768 2086 3918 6 1 93 0 0 0 3 200 61716 51904 7646824 0 0 0 3388 2177 3430 4 1 91 4 0 0 5 200 61716 51904 7647092 0 0 0 6324 1738 1244 0 0 87 13 0 0 3 200 61592 51904 7647092 0 0 0 6236 1727 1287 0 0 87 13 0 0 4 200 61716 51904 7647100 0 0 0 7328 1861 1357 0 1 88 12 0 0 4 200 61716 51904 7647100 0 0 0 7188 1852 1284 0 1 87 12 0 0 3 200 61716 51904 7647164 0 0 0 6672 1804 1502 0 1 86 13 0 0 3 200 61716 51908 7647160 0 0 0 6072 1725 1328 0 0 86 14 0 0 3 200 61592 51908 7647224 0 0 0 6524 1877 1736 1 1 86 12 0 0 3 200 61344 51908 7647224 0 0 0 6316 1894 1536 0 1 74 25 0 0 3 200 61344 51908 7647496 0 0 0 6232 1724 1287 0 0 75 25 0 0 2 200 61220 51916 7647488 0 0 0 6748 1887 1522 0 1 76 22 0 0 0 200 61468 51924 7647600 0 0 0 4908 1824 1628 1 1 76 22 0 0 0 200 61040 51924 7648280 0 0 144 648 1489 2794 4 1 95 1 0 0 0 200 60916 51924 7648784 0 0 0 256 1443 2943 6 1 93 0 0 0 0 200 60420 51924 7649124 0 0 0 248 1415 2805 5 1 94 0 0 0 4 200 60172 51924 7649144 0 0 0 5612 1789 2176 2 1 87 10 0 0 6 200 60172 51924 7649144 0 0 0 6988 1835 1320 0 1 87 12 0 0 4 200 60172 51924 7649196 0 0 0 6488 1796 1498 0 1 81 18 0 0 4 200 60172 51924 7649196 0 0 0 6424 1768 1462 1 1 75 23 0 1 3 200 60048 51924 7649268 0 0 0 6704 1899 1616 0 1 75 24 0 0 3 200 59428 51924 7649268 0 0 0 6968 1876 1404 0 1 74 25 0 0 3 200 59676 51932 7649320 0 0 0 6344 1836 1640 1 1 80 18 0 0 3 200 59676 51932 7649320 0 0 0 6400 1788 1241 0 1 88 12 0 1 0 200 59924 51944 7649456 0 0 0 688 1469 2537 4 1 92 3 0
- Previous message: [Slony1-general] how to troubleshoot slony replication lag?
- Next message: [Slony1-general] how to troubleshoot slony replication lag?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list