From owner-freebsd-ports@FreeBSD.ORG Sat May 31 14:18:50 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 EAB79487 for ; Sat, 31 May 2014 14:18:50 +0000 (UTC) Received: from mail.grem.de (outcast.grem.de [213.239.217.27]) by mx1.freebsd.org (Postfix) with SMTP id 549312D02 for ; Sat, 31 May 2014 14:18:49 +0000 (UTC) Received: (qmail 19736 invoked by uid 89); 31 May 2014 14:18:47 -0000 Received: from unknown (HELO bsd64.grem.de) (mg@grem.de@88.217.180.104) by mail.grem.de with ESMTPA; 31 May 2014 14:18:47 -0000 Date: Sat, 31 May 2014 16:18:47 +0200 From: Michael Gmelin To: Beeblebrox Subject: Re: databases/mariadb55-server fails to package with oqgraph option Message-ID: <20140531161847.225901f8@bsd64.grem.de> In-Reply-To: <1401525879623-5916642.post@n5.nabble.com> References: <1401440494269-5916414.post@n5.nabble.com> <1401459036178-5916444.post@n5.nabble.com> <20140530192620.6af98eeb@bsd64.grem.de> <1401525879623-5916642.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: Sat, 31 May 2014 14:18:51 -0000 On Sat, 31 May 2014 01:44:39 -0700 (PDT) Beeblebrox wrote: > >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" > > That's beautiful man, thanks! > > * What does "mysql_limits=YES" do? less /usr/local/etc/rc.d/mysql-server # mysql_limits (bool): Set to "NO" by default. # Set it to yes to run `limits -e -U mysql` # just before mysql starts. > * What is Mutex vs Spinlock? As I understand, one is older (thus > slower) than the other? Is the question pointless if not using InnoDB? Spinlocks should be faster on multiprocessor machines (see http://en.wikipedia.org/wiki/Spinlock for details), but if it is actually beneficial might depend on your specific workload. > * Disabling InooDB did not work as planned (failed to start, log > below). It also re-created > despite having deleted those files. Should I just leave InnoDB alone? > If so, does it make any sense to redirect the InnoDB-related files to > a restricted / more protected folder? > mysqld_safe Starting mysqld daemon with databases from /var/db/mysql > [Note] Plugin 'InnoDB' is disabled. > [ERROR] Unknown/unsupported storage engine: InnoDB > [ERROR] Aborting > [Note] /usr/local/libexec/mysqld: Shutdown complete > mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended Seems like you have to configure a different default storage engine, adding "--default-storage-engine=myisam" to mysql_args should do the trick. > > Thanks again & Regards. You're welcome. - Michael > > > > ----- > FreeBSD-11-current_amd64_root-on-zfs_RadeonKMS > -- > View this message in context: > http://freebsd.1045724.n5.nabble.com/databases-mariadb55-server-fails-to-package-with-oqgraph-option-tp5916414p5916642.html > Sent from the freebsd-ports mailing list archive at Nabble.com. > _______________________________________________ > freebsd-ports@freebsd.org mailing list > http://lists.freebsd.org/mailman/listinfo/freebsd-ports To > unsubscribe, send any mail to "freebsd-ports-unsubscribe@freebsd.org" -- Michael Gmelin