
請參照:
0. 把 io scheduler 修改成 noop
- Use noop IO scheduler
https://access.redhat.com/solutions/109223
1. 安裝 mariadb 10.2.x
https://mariadb.com/kb/en/library/configuring-linux-for-mariadb/
這裡來安裝 mariadb。就這麼簡單?! 對。就這麼簡單。
2. 修改 /etc/security/limits.conf
加入一行,把 open files 放寬
* – nofile 32768
3. 這是我常用的一組 my.conf
innodb_buffer_pool_size = 16G
# innodb_log_file_size = 2G
innodb_flush_log_at_trx_commit = 0
innodb_file_per_table
default-storage-engine = innodb
# innodb_log_files_in_group = 4
# innodb_log_file_size = 16G
# innodb_log_buffer_size = 8M
large-pages
#datadir = /var/lib/mysql
#datadir = /mysql/data
# Networking
wait_timeout=57600
max_allowed_packet=1G
skip-name-resolve
bind=0.0.0.0
max_connections=1000
有一篇不錯的文可以看看
https://www.custompcreview.com/articles/top-five-mysql-mariadb-settings-tune-best-performance/
change db location to a new one on centos7
PS:
1. securing your db
https://www.digitalocean.com/community/tutorials/how-to-install-mariadb-on-centos-7
2. 記得 mariadb db & log file system 要用 LVM striping 起來
blog 有其他文可以參考
mariaDB 是一個效能不錯開源 DB, 也許改天有空研究一下她的 scaling cluster