In high loaded enviroment I have problem with cpu performance. pgbouncer is single threaded application, it saturates all one core of cpu in mentioned enviroment. So I decided to run second instance of pgbouncer. Here is diff of init script: --- pgbouncer.orig 2013-07-16 14:47:25.246549587 +0200 +++ pgbouncer 2013-07-16 14:49:32.374490350 +0200 @@ -17,27 +17,27 @@ checkpath -d -m 755 -o pgbouncer:pgbouncer ${RUNDIR} ebegin "Starting pgbouncer" - start-stop-daemon --start --pidfile ${RUNDIR}/pgbouncer.pid \ - --exec /usr/bin/pgbouncer -- -q -d -u pgbouncer /etc/pgbouncer.conf - eend $? "Failed to start pgbouncer" + start-stop-daemon --start --pidfile ${RUNDIR}/${SVCNAME}.pid \ + --exec /usr/bin/pgbouncer -- -q -d -u pgbouncer /etc/${SVCNAME}.conf + eend $? "Failed to start ${SVCNAME}" } stop() { ebegin "Stopping pgbouncer" - start-stop-daemon --stop --quiet --pidfile ${RUNDIR}/pgbouncer.pid + start-stop-daemon --stop --quiet --pidfile ${RUNDIR}/${SVCNAME}.pid eend $? } reload() { - ebegin "Gracefully reloading pgbouncer" - kill -HUP $(head -n1 ${RUNDIR}/pgbouncer.pid) + ebegin "Gracefully reloading ${SVCNAME}" + kill -HUP $(head -n1 ${RUNDIR}/${SVCNAME}.pid) eend $? } upgrade() { - egrep -q "^unix_socket_dir" /etc/pgbouncer.conf || \ + egrep -q "^unix_socket_dir" /etc/${SVCNAME}.conf || \ eerror "Not running with unix sockets, cannot upgrade" - ebegin "Gracefully upgrading pgbouncer" - /usr/bin/pgbouncer -R -q -d -u pgbouncer /etc/pgbouncer.conf + ebegin "Gracefully upgrading ${SVCNAME}" + /usr/bin/pgbouncer -R -q -d -u pgbouncer /etc/${SVCNAME}.conf eend $? } \ No newline at end of file logrotate also needs small change. This init script isn't ideal, it should takes pidfile from config file. Reproducible: Always # emerge --info Portage 2.1.11.52 (default/linux/amd64/13.0, gcc-4.6.3, glibc-2.15-r3, 3.2.39-gentoo x86_64) ================================================================= System uname: Linux-3.2.39-gentoo-x86_64-Intel-R-_Xeon-R-_CPU_L7555_@_1.87GHz-with-gentoo-2.1 KiB Mem: 24647804 total, 22271864 free KiB Swap: 1048572 total, 1048572 free Timestamp of tree: Tue, 16 Jul 2013 10:30:01 +0000 ld GNU ld (GNU Binutils) 2.22 app-shells/bash: 4.2_p37 dev-lang/python: 2.7.3-r2, 3.2.3 dev-util/cmake: 2.8.9 dev-util/pkgconfig: 0.28 sys-apps/baselayout: 2.1-r1 sys-apps/openrc: 0.11.8 sys-apps/sandbox: 2.5 sys-devel/autoconf: 2.69 sys-devel/automake: 1.11.6 sys-devel/binutils: 2.22-r1 sys-devel/gcc: 4.6.3 sys-devel/gcc-config: 1.7.3 sys-devel/libtool: 2.4-r1 sys-devel/make: 3.82-r4 sys-kernel/linux-headers: 3.6 (virtual/os-headers) sys-libs/glibc: 2.15-r3 Repositories: gentoo x-cadera-overlay ACCEPT_KEYWORDS="amd64" ACCEPT_LICENSE="*" CBUILD="x86_64-pc-linux-gnu" CFLAGS="-O2 -pipe -march=corei7 -mtune=native" CHOST="x86_64-pc-linux-gnu" CONFIG_PROTECT="/etc" CONFIG_PROTECT_MASK="/etc/ca-certificates.conf /etc/env.d /etc/gconf /etc/gentoo-release /etc/revdep-rebuild /etc/sandbox.d /etc/terminfo" CXXFLAGS="-O2 -pipe -march=corei7 -mtune=native" DISTDIR="/usr/portage/distfiles" FCFLAGS="-O2 -pipe" FEATURES="assume-digests binpkg-logs config-protect-if-modified distlocks ebuild-locks fixlafiles merge-sync news parallel-fetch preserve-libs protect-owned sandbox sfperms strict unknown-features-warn unmerge-logs unmerge-orphans userfetch" FFLAGS="-O2 -pipe" GENTOO_MIRRORS="http://distfiles.gentoo.org" LANG="en_US.UTF-8" LC_ALL="en_US.UTF-8" LDFLAGS="-Wl,-O1 -Wl,--as-needed" MAKEOPTS="-j4" PKGDIR="/usr/portage/packages" PORTAGE_CONFIGROOT="/" PORTAGE_RSYNC_EXTRA_OPTS="-O" PORTAGE_RSYNC_OPTS="--recursive --links --safe-links --perms --times --compress --force --whole-file --delete --stats --human-readable --timeout=180 --exclude=/distfiles --exclude=/local --exclude=/packages" PORTAGE_TMPDIR="/var/tmp" PORTDIR="/usr/portage" PORTDIR_OVERLAY="/usr/portage/local/cadera-overlay" SYNC="rsync://rsync.gentoo.org/gentoo-portage" USE="acl acpi amd64 bash-completion bzip2 caps cli cracklib crypt cxx device-mapper fortran glibc-omitfp iconv idn mmap mmx mmxext modules mudflap multilib ncurses nls nptl openmp pam pcre readline session slang smp sse sse2 sse3 ssl ssse3 threads threadsafe unicode vim-syntax zlib" ABI_X86="64" ALSA_CARDS="ali5451 als4000 atiixp atiixp-modem bt87x ca0106 cmipci emu10k1x ens1370 ens1371 es1938 es1968 fm801 hda-intel intel8x0 intel8x0m maestro3 trident usb-audio via82xx via82xx-modem ymfpci" APACHE2_MODULES="actions alias auth_basic authn_alias authn_anon authn_default authn_file authz_default authz_groupfile authz_host authz_owner authz_user autoindex cache deflate dir disk_cache env expires ext_filter file_cache filter headers include info log_config logio mem_cache mime mime_magic negotiation rewrite setenvif status unique_id usertrack vhost_alias" APACHE2_MPMS="prefork" CALLIGRA_FEATURES="kexi words flow plan sheets stage tables krita karbon braindump author" CAMERAS="ptp2" COLLECTD_PLUGINS="df interface irq load memory rrdtool swap syslog" ELIBC="glibc" GPSD_PROTOCOLS="ashtech aivdm earthmate evermore fv18 garmin garmintxt gpsclock itrax mtk3301 nmea ntrip navcom oceanserver oldstyle oncore rtcm104v2 rtcm104v3 sirf superstar2 timing tsip tripmate tnt ubx" INPUT_DEVICES="keyboard mouse evdev" KERNEL="linux" LCD_DEVICES="bayrad cfontz cfontz633 glk hd44780 lb216 lcdm001 mtxorb ncurses text" LIBREOFFICE_EXTENSIONS="presenter-console presenter-minimizer" LINGUAS="en" NGINX_MODULES_HTTP="access gzip realip headers_more limit_req limit_zone rewrite stub_status" OFFICE_IMPLEMENTATION="libreoffice" PHP_TARGETS="php5-3" PYTHON_SINGLE_TARGET="python2_7" PYTHON_TARGETS="python2_7 python3_2" RUBY_TARGETS="ruby19 ruby18" USERLAND="GNU" VIDEO_CARDS="fbdev glint intel mach64 mga nouveau nv r128 radeon savage sis tdfx trident vesa via vmware dummy v4l" XTABLES_ADDONS="quota2 psd pknock lscan length2 ipv4options ipset ipp2p iface geoip fuzzy condition tee tarpit sysrq steal rawnat logmark ipmark dhcpmac delude chaos account" Unset: CPPFLAGS, CTARGET, EMERGE_DEFAULT_OPTS, INSTALL_MASK, PORTAGE_BUNZIP2_COMMAND, PORTAGE_COMPRESS, PORTAGE_COMPRESS_FLAGS, USE_PYTHON
Not quite the same as what you proposed, but you can cp the conf.d and init.d file to another name and define a different INIFILE where you can customize everything for that particular instance. *pgbouncer-1.5.4 (19 Jul 2013) 19 Jul 2013; Aaron W. Swenson <titanofold@gentoo.org> -pgbouncer-1.4.2.ebuild, -pgbouncer-1.5.ebuild, -pgbouncer-1.5.1.ebuild, -pgbouncer-1.5.2.ebuild, -pgbouncer-1.5.3.ebuild, -pgbouncer-1.5.3-r1.ebuild, +pgbouncer-1.5.4.ebuild, +files/logrotate, +files/pgbouncer.confd, +files/pgbouncer-dirs.patch, files/pgbouncer.initd, metadata.xml: Clean out old and insecure versions. Version bump. Fixes bugs 425480, 460310, 477062, and 425034.
Thanks for all fixes!
