Announcement

Collapse
No announcement yet.

Help Configuring my.ini

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Help Configuring my.ini

    The forum is running slow so I'm trying to tweak some things.

    I'm on a windows 2003 server with dual xeons @ 2.0 ghz. It has 4gb of ram.

    Here is what I have now.

    HTML Code:
    [client]
    
    port=3306
    
    [mysql]
    
    default-character-set=latin1
    
    
    [mysqld]
    
    
    port=3306
    
    
    
    basedir="C:/Program Files/MySQL/MySQL Server 5.0/"
    
    
    datadir="C:/Program Files/MySQL/MySQL Server 5.0/Data/"
    
    default-character-set=latin1
    
    
    default-storage-engine=INNODB
    
    
    sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"
    
    max_connections=500
    
    query_cache_size=0
    
    table_cache=256
    
    tmp_table_size=103M
    
    
    thread_cache_size=8
    
    myisam_max_sort_file_size=100G
    
    myisam_max_extra_sort_file_size=100G
    
    myisam_sort_buffer_size=205M
    
    key_buffer_size=175M
    
    read_buffer_size=64K
    read_rnd_buffer_size=256K
    
    sort_buffer_size=256K
    
    
    
    innodb_additional_mem_pool_size=10M
    
    innodb_flush_log_at_trx_commit=1
    
    innodb_log_buffer_size=3499K
    
    innodb_buffer_pool_size=600M
    
    
    innodb_log_file_size=170M
    
    innodb_thread_concurrency=10
    Thanks for the help!
    PowWows.com

  • #2
    One of the problems I'm noticing is that replies or new threads can take 15-30 seconds to post.

    Thanks!
    PowWows.com

    Comment


    • #3
      You'll get better help for server configuration over here - Server Configuration

      Please don't PM or VM me for support - I only help out in the threads.
      vBulletin Manual & vBulletin 4.0 Code Documentation (API)
      Want help modifying your vbulletin forum? Head on over to vbulletin.org
      If I post CSS and you don't know where it goes, throw it into the additional.css template.

      W3Schools <- awesome site for html/css help

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X