1.问题分析
队列表数据庞大,执行成功的数据已没有参考意义,建议删除3天前的执行成功的数据(status=1)给数据库减压
2.解决方案:
手工删除这些状态为1的数据 select * from mq_msg_fail_config
select count(0) from m_mercadolibre_synclisting where status=1 -- 13086417
select count(0) from m_allegro_synclisting where status=1 -- 39863113
select count(0) from m_aliexpress_synclisting where status=1 -- 11680447
select count(0) from m_mercadolibre_syncautopublish where status=1 --
select count(0) from m_shopeev2_synclisting where status=1 -- 9522014
m_shopeev2_synclisting
m_mercadolibre_synclisting
m_allegro_synclisting
m_aliexpress_synclisting
m_allegro_syncautopublish
m_mercadolibre_fullproducts
p_product_sku_change
m_mercadolibre_syncautopublish
m_shopeeV2_syncautopublish
m_lazada_syncautopublish
m_aliexpress_syncautopublish
m_walmart_syncautopublish