Please add index on aws_index table

  • Hi!

    On WordPress.com we have seen some performance issues (mainly with reindexing) because there is no index on the aws_index. This makes most operations on this table very very slow. Can you please add an index on the table. I think just adding an index on the id field should be enough but it’s possible that additional indexes will improve performance and possibly reliability (if you add UNIQUE constraints) even more.

    • This topic was modified 5 years, 5 months ago by Barry.
Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Author ILLID

    (@mihail-barinov)

    Hello,

    Thanks for letting me know about this problem. Indeed I will add some unique key for index table and release this change in the next plugin release.

    Regards

    Hello,

    We also have some clients who are using MariaDB (Galera) cluster or single servers using InnoDB with the innodb_force_primary_key=1 variable.

    In Galera cluster, the primary key is a requirement for the tables to replicate reliably and InnoDB with that setting won’t create the tables at all.

    Adding a primary or unique key to both tables (aws_index & aws_cache) would make our sysadmins life easier and improve performance on larger sites.

    Regards,
    Joonas

    Adam Henriksen

    (@ahenriksen)

    Was this ever fixed?

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Please add index on aws_index table’ is closed to new replies.