Hi. We have our pgpool-II configured with num_init_children = 64
and I see the number of processes in the run queue goes from nothing to 64 then to nothing again; this causes the load average to spike sharply which rings alarm bells in the monitoring system. I don't suppose it's possible to spread this workload out a bit so it does not spike so sharp? "vmstat 1" snapshot - 2nd line from bottom shows the run queue spike. procs -----------memory---------- ---swap-- -----io---- --system-- -----cpu------ r b swpd free buff cache si so bi bo in cs us sy id wa st 0 0 92280 685036 12496 143376 0 2 20 47 1 1 1 2 96 0 0 0 0 92280 685152 12496 143388 0 0 0 0 9193 34249 3 7 90 0 0 0 0 92280 685160 12496 143400 0 0 0 0 5194 13704 2 4 94 0 0 0 0 92280 685160 12496 143404 0 0 0 0 5025 12832 1 1 98 0 0 0 0 92280 685284 12496 143404 0 0 0 0 4925 12793 1 1 99 0 0 0 0 92280 685152 12504 143404 0 0 0 148 5834 13347 1 3 93 3 0 0 0 92280 685036 12504 143404 0 0 0 0 9146 34482 2 9 89 0 0 0 0 92280 685036 12504 143408 0 0 0 0 5289 13459 1 1 98 0 0 0 0 92280 685068 12504 143408 0 0 0 0 4706 12600 4 8 89 0 0 0 0 92280 685068 12504 143380 0 0 0 0 5194 13831 3 7 90 0 0 0 0 92280 685036 12512 143372 0 0 0 140 5338 14249 2 5 93 0 0 0 0 92280 684904 12512 143384 0 0 0 0 9374 35821 3 12 85 0 0 0 0 92280 684912 12512 143428 0 0 0 52 5208 13600 2 3 96 0 0 0 0 92280 684912 12512 143432 0 0 0 0 4894 12424 1 2 97 0 0 0 0 92280 684912 12512 143432 0 0 0 0 5069 12996 0 1 98 0 0 0 0 92280 684912 12520 143432 0 0 0 164 5750 13538 2 5 94 1 0 0 0 92280 684812 12520 143432 0 0 0 0 7563 27639 2 6 92 0 0 0 0 92280 684944 12520 143436 0 0 0 0 6135 18035 1 2 98 0 0 0 0 92280 684944 12520 143436 0 0 0 0 5176 13451 1 2 98 0 0 0 0 92280 684944 12520 143440 0 0 0 0 5158 13466 5 9 87 0 0 0 0 92280 684812 12528 143404 0 0 0 132 5222 14620 1 4 94 0 0 0 0 92280 684656 12528 143412 0 0 0 0 9315 35294 5 10 85 0 0 0 0 92280 684788 12528 143456 0 0 0 0 5234 14240 2 8 91 0 0 0 0 92280 684788 12528 143460 0 0 0 0 4949 12671 1 3 97 0 0 0 0 92280 684788 12528 143460 0 0 0 0 5066 13119 1 3 96 0 0 0 0 92280 684788 12536 143460 0 0 0 196 5948 13308 2 4 95 0 0 61 0 92280 684656 12536 143460 0 0 0 0 8248 30625 3 7 91 0 0 0 0 92280 684664 12536 143464 0 0 0 88 5796 16733 1 3 97 0 0 Sincerely Aleksey Tsalolikhin System Administrator _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
