zastavra
Active member
Hello,
I run Xenforo on a VPS, 2GB, Ubuntu 12.04 lts, nginx/1.1.19, PHP 5.4.23, Zend OPcache v7.0.2, memcached and mysql percona 5.5. Can you please take a look at my.conf to see if it's OK?
Thanks.
I run Xenforo on a VPS, 2GB, Ubuntu 12.04 lts, nginx/1.1.19, PHP 5.4.23, Zend OPcache v7.0.2, memcached and mysql percona 5.5. Can you please take a look at my.conf to see if it's OK?
Code:
[client]
port =
socket = /var/run/mysqld/mysqld.sock
#
[mysqld_safe]
socket = /var/run/mysqld/mysqld.sock
nice = 0
#
[mysqld]
local-infile=0
user = mysql
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port =
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
lc-messages-dir =/usr/share/mysql
skip-external-locking
#
key_buffer = 96M
max_allowed_packet = 16M
thread_stack = 192K
thread_cache_size = 8
myisam-recover = BACKUP
table_cache = 64M
#
query_cache_limit = 32M
query_cache_size = 16M
#
log_error = /var/log/mysql/error.log
log_slow_queries = /var/log/mysql/mysql-slow.log
long_query_time = 2
log-queries-not-using-indexes
expire_logs_days = 10
max_binlog_size = 100M
#
innodb_flush_method = O_DIRECT
innodb_log_buffer_size = 500K
innodb_log_files_in_group = 2
innodb_flush_log_at_trx_commit = 1
innodb_file_per_table = 1
innodb_buffer_pool_size = 1456M
innodb_additional_mem_pool_size = 500K
innodb_thread_concurrency = 2
#
[mysqldump]
quick
quote-names
max_allowed_packet = 16M
#
[isamchk]
key_buffer = 16M
#
#
Thanks.
Last edited: