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

Is my.conf OK?

Discussion in 'Server Configuration and Hosting' started by zastavra, Jan 2, 2014.

  1. zastavra

    zastavra Formally Stevez

    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: Jan 2, 2014

Share This Page