WordPress.org

Ready to get started?Download WordPress

Forums

High Traffic Database Tips (3 posts)

  1. nickaster
    Member
    Posted 4 years ago #

    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!

  2. Samuel B
    moderator
    Posted 4 years ago #

    http://codex.wordpress.org/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

  3. bolonki
    Member
    Posted 4 years ago #

    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

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.