About the table wp_stt2_meta

  • Resolved Portekoi

    (@portekoi)


    12 years, 2 months 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

    https://www.ads-software.com/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

    Thread Starter Portekoi

    (@portekoi)

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

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