Title: Optimize wp_options table
Last modified: August 19, 2016

---

# Optimize wp_options table

 *  [willmacdonald](https://wordpress.org/support/users/willmacdonald/)
 * (@willmacdonald)
 * [16 years, 2 months ago](https://wordpress.org/support/topic/optimize-wp_options-table/)
 * Hi,
 * I was looking through some MySQL logs on my server, checking for slow queries
   and non-indexed queries. There seem to be a lot of queries like this:
    SELECT
   option_name, option_value FROM wp_options WHERE autoload = ‘yes’
 * Autoload is not indexed, shouldn’t it be ?
 * The column type is set to var, wouldn’t be more efficient to be enum(‘yes’,’no’)?
 * Will Macdonald

Viewing 1 replies (of 1 total)

 *  [MichaelH](https://wordpress.org/support/users/michaelh/)
 * (@michaelh)
 * [16 years, 2 months ago](https://wordpress.org/support/topic/optimize-wp_options-table/#post-1443755)
 * It was there and now it is not, but can’t explain more than to direct you to 
   [https://core.trac.wordpress.org/changeset/12329](https://core.trac.wordpress.org/changeset/12329)
   
   [https://core.trac.wordpress.org/ticket/11322](https://core.trac.wordpress.org/ticket/11322)
   [https://core.trac.wordpress.org/ticket/2699](https://core.trac.wordpress.org/ticket/2699)

Viewing 1 replies (of 1 total)

The topic ‘Optimize wp_options table’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 2 participants
 * Last reply from: [MichaelH](https://wordpress.org/support/users/michaelh/)
 * Last activity: [16 years, 2 months ago](https://wordpress.org/support/topic/optimize-wp_options-table/#post-1443755)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics