Title: High Traffic Database Tips
Last modified: August 19, 2016

---

# High Traffic Database Tips

 *  [nickaster](https://wordpress.org/support/users/nickaster/)
 * (@nickaster)
 * [16 years, 8 months ago](https://wordpress.org/support/topic/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)

 *  [Samuel B](https://wordpress.org/support/users/samboll/)
 * (@samboll)
 * [16 years, 8 months ago](https://wordpress.org/support/topic/high-traffic-database-tips/#post-1216024)
 * [http://codex.wordpress.org/WordPress_Optimization](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
 *  [bolonki](https://wordpress.org/support/users/bolonki/)
 * (@bolonki)
 * [16 years, 7 months ago](https://wordpress.org/support/topic/high-traffic-database-tips/#post-1216284)
 * 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.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 3 participants
 * Last reply from: [bolonki](https://wordpress.org/support/users/bolonki/)
 * Last activity: [16 years, 7 months ago](https://wordpress.org/support/topic/high-traffic-database-tips/#post-1216284)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics