Skip to content

Instantly share code, notes, and snippets.

Created September 12, 2019 09:34
What would you like to do?
sudo apt-get install gnupg -y
cd /tmp
wget -c
sudo dpkg -i mysql-apt-config_0.8.13-1_all.deb
sudo apt-get update
sudo apt-get install mysql-server
echo [mysqld] >> /etc/mysql/my.cnf
echo innodb_dedicated_server = ON >> /etc/mysql/my.cnf
echo sort_buffer_size = 16M >> /etc/mysql/my.cnf
echo join_buffer_size = 16M >> /etc/mysql/my.cnf
echo innodb_buffer_pool_size = 4G >> /etc/mysql/my.cnf
echo innodb_log_file_size = 16M >> /etc/mysql/my.cnf
echo innodb_lock_wait_timeout=100 >> /etc/mysql/my.cnf
echo innodb_change_buffering=all >> /etc/mysql/my.cnf
echo innodb_change_buffer_max_size=25 >> /etc/mysql/my.cnf
echo innodb_buffer_pool_instances=1 >> /etc/mysql/my.cnf
echo innodb_log_buffer_size=128M >> /etc/mysql/my.cnf
echo innodb_flush_log_at_trx_commit=1 >> /etc/mysql/my.cnf
echo skip-innodb_doublewrite >> /etc/mysql/my.cnf
echo innodb_doublewrite = 0 >> /etc/mysql/my.cnf
service mysql restart
#zfs set recordsize=16K primarycache=metadata rpool/vmdata/subvol-801-disk-0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment