What is this SQL code doing?

  • rughooker

    (@rughooker)


    12 years, 3 months ago

    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 INTOwp_options(option_name,option_value,autoload) VALUES ('_transient_doing_cron', '1327097261', 'yes') ON DUPLICATE KEY UPDATEoption_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.