任务描述

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

历史记录  
  1. 2023-04-19 09:27:53, 由 陈少军 创建。
  2. 2023-04-23 09:52:41, 由 程伟 编辑。
    修改了 指派给 ,旧值为 "chengwei",新值为 "zhusiwen"。
    修改了 任务描述,区别为:
    007- select count(0) from m_mercadolibre_synclisting where status=1 -- 13086417select count(0) from m_allegro_synclisting where status=1 -- 39863113select count(0) from m_aliexpress_synclisting where status=1 -- 11680447select count(0) from m_mercadolibre_syncautopublish where status=1 --select count(0) from m_shopeev2_synclisting where status=1 -- 9522014
    007+ select count(0) from m_mercadolibre_synclisting where status=1 -- 13086417select count(0) from m_allegro_synclisting where status=1 -- 39863113select count(0) from m_aliexpress_synclisting where status=1 -- 11680447select count(0) from m_mercadolibre_syncautopublish where status=1 --select count(0) from m_shopeev2_synclisting where status=1 -- 9522014
    008- m_shopeev2_synclistingm_mercadolibre_synclistingm_allegro_synclistingm_aliexpress_synclistingm_allegro_syncautopublishm_mercadolibre_fullproductsp_product_sku_changem_mercadolibre_syncautopublishm_shopeeV2_syncautopublishm_lazada_syncautopublishm_aliexpress_syncautopublishm_walmart_syncautopublish
    008+ m_shopeev2_synclistingm_mercadolibre_synclistingm_allegro_synclistingm_aliexpress_synclistingm_allegro_syncautopublishm_mercadolibre_fullproductsp_product_sku_changem_mercadolibre_syncautopublishm_shopeeV2_syncautopublishm_lazada_syncautopublishm_aliexpress_syncautopublishm_walmart_syncautopublish
    007- <p>select count(0) from m_mercadolibre_synclisting where status=1 -- 13086417<br />select count(0) from m_allegro_synclisting where status=1 -- 39863113<br />select count(0) from m_aliexpress_synclisting where status=1 -- 11680447<br />select count(0) from m_mercadolibre_syncautopublish where status=1 --<br />select count(0) from m_shopeev2_synclisting where status=1 -- 9522014<br /></p>
    007+ <p>select count(0) from m_mercadolibre_synclisting where status=1 -- 13086417<br />select count(0) from m_allegro_synclisting where status=1 -- 39863113<br />select count(0) from m_aliexpress_synclisting where status=1 -- 11680447<br />select count(0) from m_mercadolibre_syncautopublish where status=1 --<br />select count(0) from m_shopeev2_synclisting where status=1 -- 9522014</p>
    008- <p>m_shopeev2_synclisting<br />m_mercadolibre_synclisting<br />m_allegro_synclisting<br />m_aliexpress_synclisting<br />m_allegro_syncautopublish<br />m_mercadolibre_fullproducts<br />p_product_sku_change<br />m_mercadolibre_syncautopublish<br />m_shopeeV2_syncautopublish<br />m_lazada_syncautopublish<br />m_aliexpress_syncautopublish<br />m_walmart_syncautopublish<br /></p>
    008+ <p>m_shopeev2_synclisting<br />m_mercadolibre_synclisting<br />m_allegro_synclisting<br />m_aliexpress_synclisting<br />m_allegro_syncautopublish<br />m_mercadolibre_fullproducts<br />p_product_sku_change<br />m_mercadolibre_syncautopublish<br />m_shopeeV2_syncautopublish<br />m_lazada_syncautopublish<br />m_aliexpress_syncautopublish<br />m_walmart_syncautopublish</p>
  3. 2023-06-29 17:39:37, 由 朱思文 编辑。
    修改了 任务状态,旧值为 "wait",新值为 "closed"。
    修改了 由谁关闭,旧值为 "",新值为 "zhusiwen"。
    修改了 关闭原因,旧值为 "",新值为 "done"。
    修改了 关闭时间,旧值为 "",新值为 "2023-06-29 17:39:37"。
  4. 2023-07-13 14:47:38, 由 朱思文 编辑。
    修改了 指派给,旧值为 "zhusiwen",新值为 "closed"。
所属迭代 系统管理部 - 系统服务优化
所属模块 /
相关需求 暂无
指派给 Closed 于 2023-07-13 14:47:38
任务类型 后端
任务标签 初始
开发组 有品开发组
任务状态 已关闭
进度 0%
优先级 P2
关键词
抄送给 许瑞丰
由谁创建 陈少军 于 2023-04-19 09:27:53
由谁完成 暂无
由谁取消 暂无
由谁关闭 朱思文 于 2023-06-29 17:39:37
关闭原因 已完成
最后编辑 朱思文 于 2023-07-13 14:47:38
团队 最初预计 总计消耗 预计剩余
工时信息
最初预计 0工时
总计消耗 0工时
预计剩余 0工时
预计开始 2023-04-19
实际开始 0000-00-00
截止日期 2023-04-19