ports/160209: [NEW PORT] databases/pinba-engine Realtime monitoring/statistics server for PHP

Fri Aug 26 12:40:03 UTC 2011

>Number:         160209
>Category:       ports
>Synopsis:       [NEW PORT] databases/pinba-engine Realtime monitoring/statistics server for PHP
>Confidential:   no
>Severity:       non-critical
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Fri Aug 26 12:40:02 UTC 2011
>Closed-Date:
>Last-Modified:
>Originator:     Valery Komarov
>Release:        
>Organization:
>Environment:
>Description:
PINBA - Php Is Not a Bottleneck Anymore

Pinba is a realtime monitoring/statistics server for PHP
using MySQL as a read-only interface.

It accumulates and processes data sent over UDP by multiple
PHP processes and displays statistics in a nice human-readable
form of simple "reports", also providing read-only interface
to the raw data in order to make possible generation of more
sophisticated reports and stats.

WWW: http://pinba.org
>How-To-Repeat:

>Fix:

Patch attached with submission follows:

# This is a shell archive.  Save it in a file, remove anything before
# this line, and then unpack it by entering "sh file".  Note, it may
# create directories; files and directories will be owned by you and
# have default permissions.
#
# This archive contains:
#
#	./pinba-engine
#	./pinba-engine/Makefile
#	./pinba-engine/distinfo
#	./pinba-engine/files
#	./pinba-engine/files/patch-src__ha_pinba.cc
#	./pinba-engine/files/pkg-message.in
#	./pinba-engine/pkg-descr
#	./pinba-engine/pkg-message
#	./pinba-engine/pkg-plist
#
echo c - ./pinba-engine
mkdir -p ./pinba-engine > /dev/null 2>&1
echo x - ./pinba-engine/Makefile
sed 's/^X//' >./pinba-engine/Makefile << '38fd2d4058f8ec146cde660f19d81e52'
X# New ports collection makefile for:	pinba-engine
X# Date created:				2011-08-26
X# Whom:					Valery Komarov <komarov at valerka.net>
X#
X# $FreeBSD$
X
XPORTNAME=	pinba-engine
XPORTVERSION=	2011.08.18
XCATEGORIES=	databases
XMASTER_SITES=	http://valerka.net/ports/
XDISTNAME=	pinba_engine-201108181155
X
XMAINTAINER=	komarov at valerka.net
XCOMMENT=	Realtime monitoring/statistics server for PHP
X
XLIB_DEPENDS=	protobuf.7:${PORTSDIR}/devel/protobuf \
X		Judy.1:${PORTSDIR}/devel/judy \
X		event-1.4:${PORTSDIR}/devel/libevent
X
XUSE_AUTOTOOLS=	autoconf autoheader:env automake libtool
X
XUSE_GMAKE=	yes
XGNU_CONFIGURE=	yes
XUSE_MYSQL=	embedded
X
XBUILD_DEPENDS=>${NONEXISTENT}:${PORTSDIR}/databases/mysql55-server:configure
XEXTRAS_WRKSRC=	`cd ${PORTSDIR}/databases/mysql${MYSQL_VER}-server && ${MAKE} -V WRKSRC`
X
XCONFIGURE_ARGS+=	--with-mysql=${EXTRAS_WRKSRC} \
X		--with-protobuf=${LOCALBASE} \
X		--with-judy=${LOCALBASE} \
X		--libdir=${PREFIX}/lib/mysql/plugin
X
XMAKE_ENV=	PTHREAD_CFLAGS="${PTHREAD_CFLAGS}" \
X		PTHREAD_LIBS="${PTHREAD_LIBS}"
X
X#OPTIONS=	HOARD "Build with libhoard" off 
X
XSUB_FILES=	pkg-message
X
X.include <bsd.port.pre.mk>
X
X#.if !defined(WITHOUT_HOARD)
X#    CONFIGURE_ARGS+=	--with-hoard=${LOCALBASE}
X#    LIB_DEPENDS+=	hoard.1:${PORTSDIR}/devel/libhoard
X#    MAKE_ENV+=		WITH_HOARD=1
X#    PLIST_SUB+=		WITH_HOARD=""
X#.else
X#    PLIST_SUB+=		WITH_HOARD="@comment "
X#.endif
X
Xdo-install:
X	@${MKDIR} ${PREFIX}/share/pinba
X	@${CP} ${WRKSRC}/src/.libs/libpinba_engine.so.0 ${PREFIX}/lib/mysql/plugin/libpinba_engine.so
X	@${CP} ${WRKSRC}/default_tables.sql ${PREFIX}/share/pinba/default_tables.sql
X
Xpost-install:
X	@${CAT} ${PKGMESSAGE}
X
X.include <bsd.port.post.mk>
38fd2d4058f8ec146cde660f19d81e52
echo x - ./pinba-engine/distinfo
sed 's/^X//' >./pinba-engine/distinfo << '7cef1bc5e6b7cb4f821fbf14516e967f'
XSHA256 (pinba_engine-201108181155.tar.gz) = 5e8a4aa7e436f57c7709dc13933240aa97023aea0148b541e9cb2154280b97a4
XSIZE (pinba_engine-201108181155.tar.gz) = 627420
7cef1bc5e6b7cb4f821fbf14516e967f
echo c - ./pinba-engine/files
mkdir -p ./pinba-engine/files > /dev/null 2>&1
echo x - ./pinba-engine/files/patch-src__ha_pinba.cc
sed 's/^X//' >./pinba-engine/files/patch-src__ha_pinba.cc << 'b80f8f6c8b12ade5d2ddf51e8167a35a'
X--- ./src/ha_pinba.cc.orig	2011-08-18 11:55:05.000000000 +0400
X+++ ./src/ha_pinba.cc	2011-08-20 14:18:55.000000000 +0400
X@@ -45,6 +45,10 @@
X 
X #include "ha_pinba.h"
X 
X+#ifdef PINBA_ENGINE_HAVE_PTHREAD_SETAFFINITY_NP
X+#include <pthread_np.h>
X+#endif
X+
X #ifdef PINBA_ENGINE_MYSQL_VERSION_5_5
X # define pinba_free(a, b) my_free(a)
X #else
X@@ -427,13 +431,13 @@
X 		unsigned long mask;
X 
X 		mask = 1;
X-		pthread_setaffinity_np(collector_thread, sizeof(mask), (cpu_set_t *)&mask);
X+		pthread_setaffinity_np(collector_thread, sizeof(mask), (cpuset_t *)&mask);
X 		
X 		mask = 2;
X-		pthread_setaffinity_np(data_thread, sizeof(mask), (cpu_set_t *)&mask);
X+		pthread_setaffinity_np(data_thread, sizeof(mask), (cpuset_t *)&mask);
X 		
X 		mask = 4;
X-		pthread_setaffinity_np(stats_thread, sizeof(mask), (cpu_set_t *)&mask);
X+		pthread_setaffinity_np(stats_thread, sizeof(mask), (cpuset_t *)&mask);
X #endif
X 	}
X 
b80f8f6c8b12ade5d2ddf51e8167a35a
echo x - ./pinba-engine/files/pkg-message.in
sed 's/^X//' >./pinba-engine/files/pkg-message.in << 'c002ea000e8ce5017d208ca3b841cc0c'
X=========================================================================
XPlugin installation
X
XAnd then in MySQL console execute:
Xmysql> INSTALL PLUGIN pinba SONAME 'libpinba_engine.so';
X
XI'd also suggest you to create a separate database, this way:
Xmysql> CREATE DATABASE pinba;
X
XAnd then create the default tables:
X# mysql -D pinba < %%PREFIX%%/share/pinba/default_tables.sql
X=========================================================================
c002ea000e8ce5017d208ca3b841cc0c
echo x - ./pinba-engine/pkg-descr
sed 's/^X//' >./pinba-engine/pkg-descr << 'efe718b2c3dd13cb7c88ba6c7ebdbc79'
XPINBA - Php Is Not a Bottleneck Anymore
X
XPinba is a realtime monitoring/statistics server for PHP
Xusing MySQL as a read-only interface.
X
XIt accumulates and processes data sent over UDP by multiple
XPHP processes and displays statistics in a nice human-readable
Xform of simple "reports", also providing read-only interface
Xto the raw data in order to make possible generation of more
Xsophisticated reports and stats.
X
XWWW: http://pinba.org
efe718b2c3dd13cb7c88ba6c7ebdbc79
echo x - ./pinba-engine/pkg-message
sed 's/^X//' >./pinba-engine/pkg-message << '97022604205e92e577cefdad9ad2425e'
97022604205e92e577cefdad9ad2425e
echo x - ./pinba-engine/pkg-plist
sed 's/^X//' >./pinba-engine/pkg-plist << '471d11bd2b07d61555c5f24d614ee117'
Xlib/mysql/plugin/libpinba_engine.so
X at exec mkdir -p %D/share/pinba
Xshare/pinba/default_tables.sql
X at dirrm share/pinba
471d11bd2b07d61555c5f24d614ee117
exit

>Release-Note:
>Audit-Trail:
>Unformatted: