table aws_index big size random

  • marketwo

    (@marketwo)


    4 years ago

    PRO version.
    hi,
    i contact because of the aws_index table problem that came up again. Randomly this table will generate millions of records on x products by creating a table of several gigabytes and dramatically slowing down the website.
    The only solution is to delete the table by hand in the db and have it recreated because clicking on reindex table in the plugin settings does not work when creating this bug.
    At the time of writing, 16 products have generated the bug on aws_index.

    Do you have any other definitive solution? We cannot always manually delete this table on a daily basis over and over again.

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

    id	count(*) 	
60416 	4876340
77031 	3413438
91129 	3413438
94147 	3413438
94148 	3413438
89485 	3413438
60417 	3413340
60418 	3413340
60419 	3413340
60420 	3413242
60421 	3413144
60422 	3413046
60423 	3413046
60424 	3413046
60425 	3412948
60426 	3412948
62367 	230
62371 	204
62372 	204
62373 	204
    • This topic was modified 4 years ago by marketwo.
Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)
  • The topic ‘table aws_index big size random’ is closed to new replies.