MySQL optimizaions

  • DSmidge

    (@dsmidgy)


    14 years, 10 months ago

    Hi.
    Table “wp_term_taxonomy” has a “term_id_taxonomy” combined index. Watching the Slow query logs in MySQL I found out (after creating a separate indexes for the two columns included in a combined index) that this combined index is not optimally used and a separate indexes should be created for a more optimal performance.
    Example of usage: … FROM wp_terms AS t INNER JOIN wp_term_taxonomy AS tt ON t.term_id = tt.term_id WHERE tt.taxonomy IN (‘ …
    Best regards, Domen

Viewing 1 replies (of 1 total)
  • Thread Starter DSmidge

    (@dsmidgy)

    14 years, 10 months ago

    Column “autoload” in “wp_options” table should also be indexed.
    I’m using atahualpa3 theme. Should any of my suggestions be addressed to them and not to WordPress?

Viewing 1 replies (of 1 total)
  • The topic ‘MySQL optimizaions’ is closed to new replies.

Tags