Monday, December 22, 2014

Installing MariaDB with yum

Installing MariaDB & Tokudb with yum

----------------------------------------------------------------
nano /etc/yum.repos.d/MariaDB.repo

insert follow text:

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

yum install MariaDB-server MariaDB-client
chkconfig --add mysql

service mysql start


edit file /etc/my.cnf.d/tokudb.cnf
replace uncomment line

plugin-load-add=ha_tokudb.so



You can check the status of Transparent Hugepages as follows:
cat /sys/kernel/mm/transparent_hugepage/enabled
[always] madvise never
If the path does not exist, they are not enabled and you may continue.
To disable them, pass "transparent_hugepage=never" to the kernel in your bootloader (grub, lilo, etc.). For example, for SUSE, add transparent_hugepage=never to Optional Kernel Command Line Parameter at the end, such as after "showopts", and press OK. The setting will take effect on the next reboot.
You can also disable with:
echo never > /sys/kernel/mm/transparent_hugepage/enabled
echo never > /sys/kernel/mm/transparent_hugepage/defrag