From owner-freebsd-ports@FreeBSD.ORG Fri May 30 17:26:17 2014 Return-Path: Delivered-To: freebsd-ports@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:1900:2254:206a::19:1]) (using TLSv1 with cipher ADH-AES256-SHA (256/256 bits)) (No client certificate requested) by hub.freebsd.org (Postfix) with ESMTPS id 472BE6D4 for ; Fri, 30 May 2014 17:26:17 +0000 (UTC) Received: from mail.grem.de (outcast.grem.de [213.239.217.27]) by mx1.freebsd.org (Postfix) with SMTP id 8CF1A2D3F for ; Fri, 30 May 2014 17:26:15 +0000 (UTC) Received: (qmail 462 invoked by uid 89); 30 May 2014 17:26:08 -0000 Received: from unknown (HELO bsd64.grem.de) (mg@grem.de@194.97.158.66) by mail.grem.de with ESMTPA; 30 May 2014 17:26:08 -0000 Date: Fri, 30 May 2014 19:26:20 +0200 From: Michael Gmelin To: Beeblebrox Subject: Re: databases/mariadb55-server fails to package with oqgraph option Message-ID: <20140530192620.6af98eeb@bsd64.grem.de> In-Reply-To: <1401459036178-5916444.post@n5.nabble.com> References: <1401440494269-5916414.post@n5.nabble.com> <1401459036178-5916444.post@n5.nabble.com> X-Mailer: Claws Mail 3.9.2 (GTK+ 2.24.18; amd64-portbld-freebsd9.1) Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Cc: freebsd-ports@freebsd.org X-BeenThere: freebsd-ports@freebsd.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: Porting software to FreeBSD List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 30 May 2014 17:26:17 -0000 On Fri, 30 May 2014 07:10:36 -0700 (PDT) Beeblebrox wrote: > I also have some questions about /usr/local/etc/mysql/my.cnf. I know > that my.cnf is not really necessary, but I dislike some of the > "standard behavior". > > * After 20140521 in UPDATING, I assume the "mysql_defaults_file=" is > no longer needed in /etc/rc.conf? This is correct. > > * Why do these files appear, and how can I a) not generate them b) > hide by placing them elsewhere? Do I even need InnoDB? > aria_log.00000001 \ aria_log_control \ ib_logfile0 \ ib_logfile1 > \ ibdata1 --skip-innodb, see below for details. > > * The hostname.err file shows below. Is this normal? I mean, server > starts up with mysqld_safe (normal) but I cannot tell whether it > later switches to normal mode or whether it remains in safe-mode for > the rest of operation. mysqld_safe Starting mysqld daemon with > databases from /var/db/mysql InnoDB: The InnoDB memory heap is > disabled InnoDB: Mutexes and rw_locks use GCC atomic builtins > InnoDB: Compressed tables use zlib 1.2.8 > InnoDB: Initializing buffer pool, size = 128.0M > InnoDB: Completed initialization of buffer pool > InnoDB: highest supported file format is Barracuda. > InnoDB: Waiting for the background threads to start > Percona XtraDB (http://www.percona.com) 5.5.35-MariaDB-33.0 started; > log sequence number 27993961 > [Note] Server socket created on IP: '0.0.0.0'. > [Note] Event Scheduler: Loaded 0 events > [Note] /usr/local/libexec/mysqld: ready for connections. > Version: '5.5.35-MariaDB' socket: '/tmp/mysql.sock' port: 3306 > FreeBSD Ports > ------------- > InnoDB: Starting shutdown... > InnoDB: Shutdown completed; log sequence number 27993961 > [Note] /usr/local/libexec/mysqld: Shutdown complete > mysqld_safe mysqld from pid file /var/db/mysql/q.rsb.pid ended Looks good ti me. Never forget running "mysql_upgrade" after updating mariadb though (unrelated, just crossed my mind) > > * Which of these in my.cnf are wrong / unnecessary? > [mysqld] > user = mysql > port = 3306 > pid-file = /var/run/mysqld/mysqld.pid > socket = /var/run/mysqld/mysqld.sock > log-error = /var/log/mysql.log > Use the following in /etc/rc.conf: mysql_limits="YES" mysql_pidfile="/var/run/mysqld/mysqld.pid" (setting the correct pid file this way is important for startup scripts) After doing that you can remove all but "socket" and "log-error". Personally I prefer to have it all in rc.conf, so you put this in /etc/rc.conf: mysql_args="--socket=/var/run/mysqld/mysqld.sock --log-error=/var/log/mysql.log" And remove all your my.cnf configuration options. If you want to start without innodb, add "--skip-innodb" to mysql_args in rc.conf. After doing all of this your my.cnf id empty (unless you tune more, which usually makes sense on a production system) and your /etc/rc.conf contains: mysql_enable="YES" mysql_limits="YES" mysql_pidfile="/var/run/mysqld/mysqld.pid" mysql_args="--skip-innodb --socket=/var/run/mysqld/mysqld.sock --log-error=/var/log/mysql.log" - Michael -- Michael Gmelin