• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Is my.conf OK?

zastavra

Formally Stevez
#1
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?

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: