Installing Percona instead of MySQL, checking DB engines, tunning

Mon, 03/11/2019

innodb_flush_log_at_trx_commit=2
innodb_buffer_pool_size = 384M
innodb_additional_mem_pool_size = 20M
innodb_log_buffer_size = 64M

Use this installation script
https://www.percona.com/doc/percona-server/5.7/installation/apt_repo.ht…

To check eningine used for DB tables, type

USE <database>;
SHOW TABLE STATUS\G

Script for basic MySql tunning

# cd /usr/local/src/
# wget http://day32.com/MySQL/tuning-primer.sh
# chmod u+x tuning-primer.sh
# ./tuning-primer.sh

Check INNODB settings

show variables like 'innodb%';

Check INNODB variables meaning 

https://www.percona.com/blog/2013/09/20/innodb-performance-optimization…

My settings so far

innodb-flush-log-at-trx-commit=2
innodb_buffer_pool_size = 512M
innodb_log_buffer_size = 128M
innodb_log_file_size = 100M