databases/mariadb55-server fails to package with oqgraph option

Michael Gmelin freebsd at
Sat May 31 14:18:51 UTC 2014

On Sat, 31 May 2014 01:44:39 -0700 (PDT)
Beeblebrox <zaphod at> 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/" 
> >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 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 <aria_log.00000001 \ aria_log_control>
> 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/ ended

Seems like you have to configure a different default storage engine,
adding "--default-storage-engine=myisam" to mysql_args should do the

> Thanks again & Regards.

You're welcome.

- Michael

> -----
> FreeBSD-11-current_amd64_root-on-zfs_RadeonKMS
> --
> View this message in context:
> Sent from the freebsd-ports mailing list archive at
> _______________________________________________
> freebsd-ports at mailing list
> To
> unsubscribe, send any mail to "freebsd-ports-unsubscribe at"

Michael Gmelin

More information about the freebsd-ports mailing list