WordPress.org

Ready to get started?Download WordPress

Forums

SEO SearchTerms Tagging 2
[resolved] About the table wp_stt2_meta (3 posts)

  1. Portekoi
    Member
    Posted 1 year ago #

    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/

  2. Melbourne Cup Odds
    Member
    Posted 1 year ago #

    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

  3. Portekoi
    Member
    Posted 1 year ago #

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

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic

Tags

No tags yet.