Not the answer you need?
Register and ask your own question!

New server settings suggestion

newtomysqlnewtomysql ContributorCurrent User Role Beginner
Hi All,
We will have a server with 32 Gb ram capacity running on linux platform. The problem it that it will be also running a socket application based on java. So we cant give nearly 80% of the ram to mysql as per normal suggestion. But below is what we plan to set accordingly.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

innodb_file_per_table
innodb_lock_wait_timeout=120
innodb_buffer_pool=21G
innodb_log_file_size=512M

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
bind-address=127.0.0.1
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.