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

[VPS] Need optimization

Discussion in 'Server Configuration and Hosting' started by Big Dan, Feb 25, 2012.

  1. Big Dan

    Big Dan Active Member

    Howdy Folks,

    I'm running a medium sized XF board (37k threads, 465k posts) on a VPS with 1280MB RAM. It's a standard LAMP server running cPanel minus Apache; I'm running Litespeed. I do have memcache installed but not activated with XF; I'd read on the boards that performance increase was negligible on a single server. I've had the server techs tweak mySQL and it helped for a little while but it's feeling sluggish again.

    The biggest problem I'm seeing is database commits. Posting threads, replies, conversations, etc. intermittently hangs for quite a bit and sometimes triggers the dreaded Server did not respond in time error. RAM is only at ~70% utilization at any given time so I doubt it's a lack of memory problem. Page loads are generally pretty fast.

    Within the next couple of months I'll be moving the board to a fully dedicated box but in the mean time it'd be nice if the site would hum along in the mean time. There are a couple of small Wordpress installs running on this server but they can be moved if certain tweaks wouldn't play well with WP.

    What files do you guys need to see?

    Thanks in advance,
    Dan

    Edit:

    I forgot to add I'm running Extended Search from XF too, if that tidbid helps.
     
  2. Luke F

    Luke F Well-Known Member

  3. Slavik

    Slavik XenForo Moderator Staff Member

    Can you post up your current my.cnf
     
    Big Dan likes this.
  4. Big Dan

    Big Dan Active Member


    Do you want me to run that perl script as root?

    my.cnf from /etc/my.cnf (I assume this is the only one?)

    Code:
    [mysqld]
    skip-bdb
    local-infile=0
    datadir=/var/lib/mysql
    skip-locking
    safe-show-database
    long_query_time=2
    query_cache_limit=1M
    query_cache_size=32M
    query_cache_type=1
    max_user_connections=30
    max_connections=200
    thread_cache_size=128
    table_cache=2048
    key_buffer=64M
    max_connect_errors=20
    max_allowed_packet=16M
    join_buffer=1M
    record_buffer=1M
    sort_buffer_size=1M
    read_buffer_size=1M
    read_rnd_buffer_size=1M
    thread_concurrency=4
    myisam_sort_buffer_size=16M
    open_files_limit=8192
    concurrent_insert=2
    local-infile=0 
     
  5. Luke F

    Luke F Well-Known Member

    Code:
    [mysqld]
    skip-bdb
    local-infile=0
    datadir=/var/lib/mysql
    skip-locking
    safe-show-database
    long_query_time=2
    query_cache_limit=16M
    query_cache_size=200M
    query_cache_type=1
    max_user_connections=30
    max_connections=200
    thread_cache_size=128
    table_cache=2048
    key_buffer=32M
    max_connect_errors=20
    max_allowed_packet=16M
    join_buffer=2M
    record_buffer=1M
    sort_buffer_size=16M
    read_buffer_size=2M
    read_rnd_buffer_size=2M
    thread_concurrency=4
    myisam_sort_buffer_size=16M
    open_files_limit=8192
    concurrent_insert=2
    local-infile=0
     
    innodb_buffer_pool_size = 400M
    innodb_thread_concurrency = 8
    innodb_flush_log_at_trx_commit = 0
    
    And yes, but there may be no need, see how that performs

    If you run out of RAM reduce innodb_buffer_pool_size
     
    Big Dan and Slavik like this.
  6. Big Dan

    Big Dan Active Member

    Thank you Dark! Just updated the config and restarted mySQL. The site seems faster. I'll see how it preforms during our busy days. :)
     

Share This Page