WordPress.org

Support

Support » Plugins and Hacks » SEO SearchTerms Tagging 2 » [Resolved] About the table wp_stt2_meta

[Resolved] About the table wp_stt2_meta

  • Hi,

    How can i optimise the table wp_stt2_meta ?

    I have 2.670.937 rows and sometimes, i have slow query like that :

    # User@Host: xxxxxx[xxxxxx] @ localhost []
    # Query_time: 44.451019  Lock_time: 0.007172 Rows_sent: 0  Rows_examined: 0
    SET timestamp=1357596198;
    INSERT INTO wp_stt2_meta ( <code>post_id</code>,<code>meta_value</code>,<code>meta_count</code> ) VALUES ( '6318', 'sqsdqd dkj  jdjq sqd sqdqsd', 1 )
    			ON DUPLICATE KEY UPDATE <code>meta_count</code> = <code>meta_count</code> + 1;

    Any idea or help?

    Thank’s

    Portekoi

    http://wordpress.org/extend/plugins/searchterms-tagging-2/

Viewing 2 replies - 1 through 2 (of 2 total)
  • If your wp_stt2_meta table has 2,670,937 rows, its overly large and needs to be reset. Easily fixed by going to Settings > SEO Searchterm 2.

    Look for setting “Auto clean up unused search terms after: 90”

    Change 90 to 7

    To start fresh scroll to bottom of settings page and click “Delete all (Reset)” button

    Sorry for the late of my response but thank you very much 🙂

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘[Resolved] About the table wp_stt2_meta’ is closed to new replies.
Skip to toolbar