ports/140641: [NEW PORT] databases/tuning-primer : MySQL performance tuning primer script

[Joe Horn]

>Number:         140641
>Category:       ports
>Synopsis:       [NEW PORT] databases/tuning-primer : MySQL performance tuning primer script
>Confidential:   no
>Severity:       non-critical
>Priority:       low
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          change-request
>Submitter-Id:   current-users
>Arrival-Date:   Tue Nov 17 16:50:01 UTC 2009
>Closed-Date:
>Last-Modified:
>Originator:     Joe Horn
>Release:        7.2-RELEASE-p4
>Organization:
Taiwanese User
>Environment:
FreeBSD joehorn.idv.tw 7.2-RELEASE-p4 FreeBSD 7.2-RELEASE-p4 #5: Sat Oct 24 13:15:52 CST 2009     root at joehorn.idv.tw:/usr/obj/usr/src/sys/joehorn  i386
>Description:
This script takes information from "SHOW STATUS LIKE..."
and "SHOW VARIABLES LIKE..." then attempts to produce
sane recommendations for tuning server variables.

It is compatible with all versions of MySQL 3.23 - 5.1.
>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:
#
#	/usr/ports/databases/tuning-primer
#	/usr/ports/databases/tuning-primer/Makefile
#	/usr/ports/databases/tuning-primer/distinfo
#	/usr/ports/databases/tuning-primer/pkg-descr
#
echo c - /usr/ports/databases/tuning-primer
mkdir -p /usr/ports/databases/tuning-primer > /dev/null 2>&1
echo x - /usr/ports/databases/tuning-primer/Makefile
sed 's/^X//' >/usr/ports/databases/tuning-primer/Makefile << '5a5c1e1f01892f1084fee0a3dd2e492d'
X# New ports collection makefile for: tuning-primer
X# Date created:		2009-11-18
X# Whom:			Joe Horn <joehorn at gmail.com>
X#
X# $FreeBSD$
X#
X
XPORTNAME=	tuning-primer
XPORTVERSION=	1.5.r4
XCATEGORIES=	databases
XMASTER_SITES=	https://code.launchpad.net/mysql-${PORTNAME}/trunk/${PORTVERSION:S/.r/-r/}/+download/
XDISTFILES=	${PORTNAME}.sh
XEXTRACT_ONLY=
X
XMAINTAINER=	joehorn at gmail.com
XCOMMENT=	MySQL performance tuning primer script
X
XNO_BUILD=	yes
X
XPLIST_FILES=	bin/${PORTNAME}.sh
X
X.include <bsd.port.pre.mk>
Xdo-install:
X	@${CP} ${DISTDIR}/${PORTNAME}.sh \
X		${PREFIX}/bin/${PORTNAME}.sh
X	@${CHMOD} 755 ${PREFIX}/bin/${PORTNAME}.sh
X	@${ECHO_CMD} '@exec ${CHMOD} 755 ${PREFIX}/bin/${PORTNAME}.sh' \
X		>> ${TMPPLIST}
X.include <bsd.port.post.mk>
5a5c1e1f01892f1084fee0a3dd2e492d
echo x - /usr/ports/databases/tuning-primer/distinfo
sed 's/^X//' >/usr/ports/databases/tuning-primer/distinfo << '11f311a79679b3a682a8f32f87c1817d'
XMD5 (tuning-primer.sh) = 0ae6b7b5d77ce27ab65c8bddd98436b3
XSHA256 (tuning-primer.sh) = 375d08a1ba93adfdb7ebd43cb64b174306581cf6a2e4159304b7e4ca78c3f363
XSIZE (tuning-primer.sh) = 48399
11f311a79679b3a682a8f32f87c1817d
echo x - /usr/ports/databases/tuning-primer/pkg-descr
sed 's/^X//' >/usr/ports/databases/tuning-primer/pkg-descr << 'fe382bcb4dd80c1a33fdbaf9bab7caf3'
XThis script takes information from "SHOW STATUS LIKE..."
Xand "SHOW VARIABLES LIKE..." then attempts to produce
Xsane recommendations for tuning server variables.
X
XIt is compatible with all versions of MySQL 3.23 - 5.1.
X
XWWW:	https://launchpad.net/mysql-tuning-primer
fe382bcb4dd80c1a33fdbaf9bab7caf3
exit



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