aws_index size

  • marketwo

    (@marketwo)


    4 years ago

    Hello, we have a problem with the indexing of the plugin. The aws_index table gets to weigh several GB and the reindex table button in the setting page doesn’t work.

    Running the following command in the db:
    SELECT id, count(*)
    FROM vg4EOb_aws_index
    group by id
    order by 2 desc
    limit 10

    we get these results
    id count(*)
    60416 788266
    60431 749892
    60427 557612
    80813 88
    97266 75
    64381 74
    74676 69
    62367 69
    65934 67
    100454 67

    Some products have thousands of records while normally they have between 50 and 80 records.

    Any solution?

    The page I need help with: [log in to see the link]

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

    (@marketwo)

    Hi, I solved it by emptying the aws_index table completely and having a full reindex re-do

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