my board slows too slow

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • George L
    Former vBulletin Support
    • May 2000
    • 32996
    • 3.8.x

    #16
    ask your web host to try this new /etc/my.cnf file settings

    [client]
    port = 3306
    socket = /var/lib/mysql/mysql.sock

    [mysqld]
    port = 3306
    socket = /var/lib/mysql/mysql.sock
    skip-locking
    set-variable = max_connections=1024
    set-variable = key_buffer=16M
    set-variable = myisam_sort_buffer_size=64M
    set-variable = join_buffer=2M
    set-variable = record_buffer=2M
    set-variable = sort_buffer=3M
    set-variable = table_cache=1024
    set-variable = thread_cache_size=256
    set-variable = wait_timeout=3600
    set-variable = connect_timeout=10

    [safe_mysqld]
    open-files-limit=8192

    [mysqldump]
    quick
    set-variable = max_allowed_packet=64M

    [myisamchk]
    set-variable = key_buffer=128M
    set-variable = sort_buffer=128M
    set-variable = read_buffer=16M
    set-variable = write_buffer=16M
    restart mysql

    of course change mysql.sock path to what ever your host has it at
    :: Always Back Up Forum Database + Attachments BEFORE upgrading !
    :: Nginx SPDY SSL - World Flags Demo [video results]
    :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

    Comment

    • opus
      New Member
      • Jun 2001
      • 22

      #17
      my host said that made it much worse

      Comment

      • George L
        Former vBulletin Support
        • May 2000
        • 32996
        • 3.8.x

        #18
        Originally posted by opus
        my host said that made it much worse
        what server specs are they using cpu ? ram ? hdd type etc ?

        specific linux kernel version ? etc
        :: Always Back Up Forum Database + Attachments BEFORE upgrading !
        :: Nginx SPDY SSL - World Flags Demo [video results]
        :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

        Comment

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