High Traffic Database Tips

  • So we’re graduating into being a pretty high traffic site. And once in a while I get database errors – either the site doesn’t load at all, or you get an error when trying to publish or something. I don’t think this affects readers because we’ve got super cache on, but I worry these problems will start to get more frequent as traffic goes up.

    I really know nothing about databases, so wonder two things:

    1) A good 101 resource, specific to WP sites, that could get me started
    2) An easy 1st or 2nd tip that I could use to get to a better place – even if it’s just something I should ask my host to do (mediatemple)

    Thanks!

Viewing 2 replies - 1 through 2 (of 2 total)

  • https://codex.www.ads-software.com/WordPress_Optimization
    this page explains a lot and at the bottom has some great resources

    when the traffic reaches a certain point, shared servers will kill you – the only option may be a dedicated one

    Here are some WordPress MySQL optimization recommendations from Matt Mullenweg:

    From: Matt Mullenweg
    Date: April 23, 2008
    Subject: Making WordPress Sing

    Here’s what I’d recommend [for MySQL configuration], after the tmpdir stuff under [mysqld]: (Some of these are high, but you’ll never reach them and based on your available memory not a big deal.)

    skip-external-locking
    skip-slave-start
    skip-bdb
    skip-innodb
    skip-name-resolve

    # Global mem settings
    key_buffer = 24M

    max_connections = 200

    # Per client mem settings

    sort_buffer_size = 4M
    read_buffer_size = 4M
    binlog_cache_size = 2M

    max_allowed_packet = 12M
    thread_stack = 128K

    table_cache = 128
    thread_cache = 256
    thread_concurrency = 4

    myisam_sort_buffer_size = 1M
    tmp_table_size = 12M
    max_heap_table_size = 12M

    wait_timeout = 200
    interactive_timeout = 300
    max_connect_errors = 10000

    query_cache_type = 1
    query_cache_limit = 1M
    query_cache_size = 16M

    [mysqldump]
    quick
    quote-names
    max_allowed_packet = 16M

    [mysql]
    #no-auto-rehash # faster start of mysql but no tab completition

    [isamchk]
    key_buffer = 16M

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘High Traffic Database Tips’ is closed to new replies.