Page MenuHomeDevCentral

Provide a MySQL server on Eglide
Closed, ResolvedPublic

Description

Packages to install

  • Debian: mariadb-server (or mariadb-server-10.1, but it's autoselected)
  • FreeBSD: databases/mariadb101-server

Configuration

Keep RAM slightly lower than default configuration: there won't be a lot of traffic, optimize for 20 simultaneous connections perhaps.

Revisions and Commits

Event Timeline

innodb_buffer_pool_size

We'll let the default value of 8M, but that will need to be adjusted per http://dba.stackexchange.com/questions/27328/how-large-should-be-mysql-innodb-buffer-pool-size when we have some databases in prod.

My first impulse was to use 100M, but then, I'm note sure if we'll have heavy InnoDB data on Eglide.

max_connections

We'll cap at 50, with monitoring to detect when it reaches 40 and increase the value. That will allow to lower RAM consume to +- 305 MB