Ticket #318 (closed 需求: 已处理)

Opened 12 years ago

Last modified 11 years ago

数据优化

Reported by: chenguohao Owned by: libingyue
Priority: 最高级（1） Milestone:
Component: 亲子网论坛 Version: 亲子论坛BBS7.0.3
Keywords: Cc:
Due Date: 03/09/2014

Description

发现个人用户数据，主要用于显示“我的主题”、“我的回帖”、“我的精华”等数据出现不同程度的失准，原因多样（旧数据，特殊处理，脏数据），故进行一次数据优化处理，确保上述数据的准确性；

Attachments

亲子网7.0.3导数据脚本.zip Download (4.5 KB) - added by libingyue 12 years ago.
清除冗余数据.sql Download (21.0 KB) - added by libingyue 11 years ago.

Change History

comment:1 Changed 12 years ago by dingjianyong

  • Owner changed from dingjianyong to lijianwen
  • Status changed from new to assigned
  • Version set to 亲子论坛BBS7.0.2

comment:2 Changed 12 years ago by dingjianyong

  • Version changed from 亲子论坛BBS7.0.2 to 亲子论坛BBS7.0.3

comment:3 Changed 12 years ago by dingjianyong

  • Owner changed from lijianwen to libingyue

Changed 12 years ago by libingyue

comment:4 Changed 12 years ago by libingyue

相关操作请参照附件说明

comment:5 Changed 12 years ago by libingyue

  • Status changed from assigned to closed
  • Resolution set to 已处理

comment:6 Changed 11 years ago by libingyue

清除冗余数据部分的操作有更改：停止主从数据库复制，在从库上统计错误数据，统计完之后，再在主库上清除错误数据。
说明步骤详见附件：清除冗余数据.sql

Changed 11 years ago by libingyue

Note: See TracTickets for help on using tickets.