Price Editor/Database lag
DGPickett
dgpickett at aol.com
Tue Apr 3 12:35:32 EDT 2018
I started vmstat -tw 11 in a wide xterm and I do see a lot of swap out for
some but not all delays. The not-first delays seem to be smaller now. The
first delay did 3K+ so, later ones did 2K+, 300+ or almost no so. Almost no
so may indicate the container is not dealing well with the volume and
requests it gets, even when it has all the ram it desires. Is the tree
keyed on category, symbol, date reverse like the display?
*First:*
$ vmstat -tw 11
procs -----------------------memory---------------------- ---swap--
-----io---- -system-- --------cpu-------- -----timestamp-----
r b swpd free buff cache si so bi
bo in cs us sy id wa st EDT
5 0 2690184 146340 26604 788804 6 16 109
123 117 16 70 9 20 1 0 2018-04-03 12:17:40
6 1 2687992 127184 26896 793168 227 0 641
164 2051 5894 88 12 0 0 0 2018-04-03 12:17:51
5 2 2688552 288532 26828 778192 173 151 694
2167 2089 7312 78 18 3 0 0 2018-04-03 12:18:02
5 0 2688400 261316 27028 781584 26 0 329
143 1798 6898 68 30 2 0 0 2018-04-03 12:18:13
3 0 2685660 257964 28028 791768 214 0 486
1114 2294 7585 48 33 16 2 0 2018-04-03 12:18:24
2 0 2685636 245952 28076 791596 1 0 7
139 2496 7604 30 37 32 1 0 2018-04-03 12:18:35
1 0 2685272 237496 28280 791948 32 0 49
267 3459 8448 31 22 46 1 0 2018-04-03 12:18:46
0 0 2685244 175176 28980 793436 3 0 179
134 3407 8631 44 13 42 2 0 2018-04-03 12:18:57
0 0 2685204 219884 29200 793160 5 0 19
230 3655 8706 32 13 54 1 0 2018-04-03 12:19:08
2 0 2685056 193536 29260 812132 14 0 1700
118 2710 8191 61 10 27 2 0 2018-04-03 12:19:19
3 0 2685040 179452 29312 812216 2 0 2
124 1875 8148 81 9 10 0 0 2018-04-03 12:19:30
1 0 2722160 304164 22520 721880 20 3395 31
3555 2212 7960 78 10 11 0 0 2018-04-03 12:19:41
^C
*
Later:*
$ vmstat -tw 11
procs -----------------------memory---------------------- ---swap--
-----io---- -system-- --------cpu-------- -----timestamp-----
r b swpd free buff cache si so bi
bo in cs us sy id wa st EDT
3 0 2721700 263624 23340 735688 6 16 109
123 119 20 70 9 20 1 0 2018-04-03 12:20:23
2 0 2721676 259740 23392 735564 2 0 3
86 2907 8945 57 11 32 0 0 2018-04-03 12:20:34
0 0 2721640 256548 23476 735848 3 0 11
185 3634 8735 37 13 49 1 0 2018-04-03 12:20:45
1 0 2721616 250820 23540 735836 2 0 2
253 3601 8358 30 12 57 1 0 2018-04-03 12:20:56
6 0 2721604 250316 23596 735732 1 0 1
140 2443 8143 70 10 20 0 0 2018-04-03 12:21:07
6 0 2720948 245044 23672 735940 66 0 67
128 1901 7925 80 9 11 0 0 2018-04-03 12:21:18
1 0 2720932 239548 23736 736668 2 0 59
139 2719 8306 56 11 33 1 0 2018-04-03 12:21:29
2 0 2744192 305700 23672 687084 1 2115 2
2266 2686 8077 64 12 23 0 0 2018-04-03 12:21:40
2 0 2744148 297584 23760 687428 5 0 7
120 1975 8049 75 10 15 0 0 2018-04-03 12:21:51
5 0 2744060 261572 23852 689276 28 0 183
111 3459 8838 36 17 45 2 0 2018-04-03 12:22:02
5 0 2744048 287472 23900 689192 1 0 9
306 3690 8710 32 13 54 1 0 2018-04-03 12:22:13
1 0 2744008 283288 23968 689316 3 0 4
220 2173 8488 65 12 23 1 0 2018-04-03 12:22:24
3 0 2744004 279204 24028 689268 0 0 1
110 1773 8291 74 10 16 0 0 2018-04-03 12:22:35
3 0 2743988 276512 24112 689016 1 0 1
216 2224 8250 68 9 23 1 0 2018-04-03 12:22:46
5 1 2743188 264564 24160 689260 98 0 115
120 2628 8056 66 9 25 0 0 2018-04-03 12:22:57
3 0 2743156 275052 24208 689428 2 0 2
124 3673 8813 46 12 41 1 0 2018-04-03 12:23:08
2 0 2743128 271456 24284 689404 2 0 2
195 2569 8044 67 10 22 1 0 2018-04-03 12:23:19
2 0 2743080 265140 24336 689388 7 0 8
149 1651 8070 76 9 15 0 0 2018-04-03 12:23:30
0 0 2743036 260032 24388 689192 4 0 4
121 2802 8166 51 10 37 1 0 2018-04-03 12:23:41
1 0 2742988 255840 24424 689240 4 0 5
144 3905 8893 37 12 51 1 0 2018-04-03 12:23:52
4 0 2742956 251956 24488 689436 4 0 10
232 2448 7941 68 10 21 1 0 2018-04-03 12:24:03
1 0 2742928 286860 24544 694464 3 0 467
177 3538 8667 41 13 45 1 0 2018-04-03 12:24:14
procs -----------------------memory---------------------- ---swap--
-----io---- -system-- --------cpu-------- -----timestamp-----
r b swpd free buff cache si so bi
bo in cs us sy id wa st EDT
4 0 2742896 285092 24608 694632 3 0 4
133 2559 8079 69 10 21 1 0 2018-04-03 12:24:25
1 0 2742880 277912 24676 694720 1 0 1
278 1884 7718 81 8 11 0 0 2018-04-03 12:24:36
2 0 2747028 328792 24476 651368 20 397 21
500 2218 8420 79 10 11 0 0 2018-04-03 12:24:47
2 0 2747000 319120 24544 654328 3 0 287
140 3784 8942 50 15 34 2 0 2018-04-03 12:24:58
3 0 2746944 282404 25776 689032 6 0 3137
206 4490 10247 46 14 33 8 0 2018-04-03 12:25:09
1 0 2745936 269656 25884 689448 112 0 148
233 4139 9967 48 12 39 1 0 2018-04-03 12:25:20
2 0 2745900 270564 25976 691384 4 0 152
220 4623 11200 54 13 32 1 0 2018-04-03 12:25:31
0 0 2745872 260388 26096 692040 4 0 53
236 3707 9646 55 12 32 1 0 2018-04-03 12:25:42
2 1 2745848 263492 26196 692228 3 0 11
217 3666 9573 52 12 36 1 0 2018-04-03 12:25:53
4 0 2745832 256728 26244 692112 2 0 2
167 3795 9451 54 13 33 0 0 2018-04-03 12:26:04
4 0 2745764 249240 26896 694920 17 0 347
268 3689 8492 54 13 32 2 0 2018-04-03 12:26:15
0 0 2745728 241476 26956 695584 7 0 72
213 3625 8432 40 12 46 1 0 2018-04-03 12:26:26
2 0 2745692 248160 27024 695596 6 0 7
92 3392 7836 39 11 49 1 0 2018-04-03 12:26:37
1 1 2757852 294608 24900 639944 1677 1157 1684
1491 3423 8571 48 14 35 3 0 2018-04-03 12:26:48
3 0 2742428 438340 24968 641300 2437 0 2539
109 2820 9133 82 15 1 3 0 2018-04-03 12:26:59
1 0 2742192 484172 25008 641244 28 0 35
113 3354 8221 42 11 47 0 0 2018-04-03 12:27:10
0 0 2742132 423492 25368 695820 11 0 4993
250 3709 9547 42 13 39 6 0 2018-04-03 12:27:21
0 0 2740332 382012 26136 713756 698 0 2362
146 3577 8655 35 21 39 5 0 2018-04-03 12:27:32
0 0 2740300 378648 26176 714636 6 0 8
126 3739 8009 28 12 60 1 0 2018-04-03 12:27:43
1 0 2739640 389740 26244 714684 92 0 93
218 3797 8995 31 13 55 1 0 2018-04-03 12:27:54
0 0 2739520 438160 26292 714724 23 0 23
178 2258 7729 83 10 7 0 0 2018-04-03 12:28:05
4 0 2739448 439028 26368 714700 8 0 9
283 3365 7541 40 12 47 1 0 2018-04-03 12:28:16
procs -----------------------memory---------------------- ---swap--
-----io---- -system-- --------cpu-------- -----timestamp-----
r b swpd free buff cache si so bi
bo in cs us sy id wa st EDT
2 0 2739396 449768 26412 714764 5 0 11
140 3584 7895 36 12 51 1 0 2018-04-03 12:28:27
4 0 2739364 436512 26460 714896 2 0 2
171 3718 8617 42 12 46 1 0 2018-04-03 12:28:38
0 0 2739320 430216 26524 714504 6 0 7
130 4014 9168 37 12 50 1 0 2018-04-03 12:28:49
1 0 2739304 423460 26576 714868 2 0 3
111 3586 7887 27 11 60 1 0 2018-04-03 12:29:00
2 0 2739276 250176 26652 726448 2 0 1034
184 3562 8467 32 13 54 1 0 2018-04-03 12:29:11
0 1 2737228 227420 27672 731924 217 0 577
226 4099 9553 43 15 41 2 0 2018-04-03 12:29:22
1 0 2737216 220904 27728 732012 0 0 6
177 4147 9669 33 14 53 1 0 2018-04-03 12:29:33
0 0 2753024 319792 11196 636316 10 1448 37
1866 3372 9019 48 14 38 1 0 2018-04-03 12:29:44
1 0 2752988 312364 11300 636252 4 0 4
138 3565 8207 40 12 47 1 0 2018-04-03 12:29:55
1 0 2752932 315680 11368 637600 8 0 44
212 3485 7824 37 13 50 1 0 2018-04-03 12:30:06
5 0 2752912 308392 11432 637820 2 0 15
225 4226 9430 43 13 43 1 0 2018-04-03 12:30:17
1 0 2752904 301152 11460 637992 1 0 9
169 3984 8932 33 13 54 0 0 2018-04-03 12:30:28
0 0 2752892 299688 11508 637844 1 0 1
212 3950 8850 29 13 57 0 0 2018-04-03 12:30:39
1 0 2752696 292692 11600 638072 22 0 44
176 3825 8864 30 13 55 1 0 2018-04-03 12:30:50
1 0 2752656 280948 11656 644056 116 0 676
103 3593 7824 26 13 58 3 0 2018-04-03 12:31:01
2 0 2752624 274624 11976 646000 1 0 185
113 3509 7405 27 12 58 3 0 2018-04-03 12:31:12
0 0 2752616 269548 12040 646224 2 0 22
235 3521 7861 33 11 54 1 0 2018-04-03 12:31:23
4 0 2752600 284472 12108 646208 2 0 3
111 3754 8432 42 13 44 1 0 2018-04-03 12:31:34
^C
--
Sent from: http://gnucash.1415818.n4.nabble.com/GnuCash-User-f1415819.html
More information about the gnucash-user
mailing list