Title: What is this SQL code doing?
Last modified: August 20, 2016

---

# What is this SQL code doing?

 *  [rughooker](https://wordpress.org/support/users/rughooker/)
 * (@rughooker)
 * [14 years, 4 months ago](https://wordpress.org/support/topic/what-is-this-sql-code-doing/)
 * I have a cache plugin, I’ve optimized and followed every tip I can find to reduce
   the cpu load of wordpress. I’ve just had a huge spike in cpu useage and this 
   showed up in tmp/slow_mysql_queries/.
 * `INSERT INTO`wp_options`(`option_name`,`option_value`,`autoload`) VALUES ('_transient_doing_cron','
   1327097261', 'yes') ON DUPLICATE KEY UPDATE`option_name`= VALUES(`option_name`),`
   option_value`= VALUES(`option_value`),`autoload`= VALUES(`autoload`)`
 * My wp_options table is 526 items long. A lot of the entries have an options name
   that begins with _transient_. What do these entries do and why are there so many?
   Can some be deleted? How do I thin this out?

The topic ‘What is this SQL code doing?’ is closed to new replies.

## Tags

 * [sql](https://wordpress.org/support/topic-tag/sql/)
 * [transient](https://wordpress.org/support/topic-tag/transient/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [rughooker](https://wordpress.org/support/users/rughooker/)
 * Last activity: [14 years, 4 months ago](https://wordpress.org/support/topic/what-is-this-sql-code-doing/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics