-
Book Overview & Buying
-
Table Of Contents
MariaDB High Performance
By :
MariaDB is able to run on multiple kinds of operating systems:
MariaDB has a special thread-pool implementation that allows it to perform much better than MySQL under heavy loads (lots of connections).
In this book, every exercise will be on Debian GNU/Linux Wheezy amd64 version. Of course, all MariaDB tuning will be portable to any operating system, so you won't be lost. For the operating system performance tuning, we'll focus on Linux amd64 (Debian GNU/Linux), as it's free and open source, and of course MariaDB works very well on it.
To easily test the following parameters, you can use the following Vagrant file that provides you with the necessary virtual machine with MariaDB installed. The requirements are as follows:
Here is the associated Vagrant file:
# -*- mode: ruby -*-
# vi: set ft=ruby :
# Vagrantfile API/syntax version. Don't touch unless you know what you're doing!
#
VAGRANTFILE_API_VERSION = "2"
# Insert all your Vms with configs
boxes = [
{ :name => :mariadb },
]
$install = <<INSTALL
aptitude update
DEBIAN_FRONTEND=noninteractive aptitude -y -o Dpkg::Options::="--force-confdef" -o Dpkg::Options::="--force-confold" install python-software-properties
apt-key adv --recv-keys --keyserver keyserver.ubuntu.com 0xcbcb082a1bb943db
add-apt-repository 'deb http://ftp.igh.cnrs.fr/pub/mariadb/repo/10.0/debian wheezy main'
aptitude update
DEBIAN_FRONTEND=noninteractive aptitude -y -o Dpkg::Options::="--force-confdef" -o Dpkg::Options::="--force-confold" install mariadb-server
INSTALL
Vagrant::Config.run do |config|
# Default box OS
vm_default = proc do |boxcnf|
boxcnf.vm.box = "deimosfr/debian-wheezy"
end
# For each VM, add a public and private card. Then install Ceph
boxes.each do |opts|
vm_default.call(config)
config.vm.define opts[:name] do |config|
config.vm.customize ["modifyvm", :id, "--cpus", 4]
config.vm.host_name = "%s.vm" % opts[:name].to_s
file_to_disk = 'ext4-journal_' + opts[:name].to_s + '.vdi'
config.vm.customize ['createhd', '--filename', file_to_disk, '--size', 250]
config.vm.customize ['storageattach', :id, '--storagectl', 'SATA Controller', '--port', 1, '--device', 0, '--type', 'hdd', '--medium', file_to_disk]
config.vm.provision "shell", inline: $install
end
end
end
Change the font size
Change margin width
Change background colour