基于mysql做存储时间长了会不会影响性能？

dtm-labs / dtm

A distributed transaction framework, supports workflow, saga, tcc, xa, 2-phase message, outbox patterns, supports many languages.

http://d.dtm.pub

BSD 3-Clause "New" or "Revised" License

10.13k stars 971 forks source link

Closed yb19890724 closed 9 months ago

yb19890724 commented 11 months ago

dtm基于mysql数据表方式做存储，时间长了存储数据过多会不会影响检索性能？从而导致整体性能下降？

yedf2 commented 10 months ago

对于mysql存储数据，通常大家都会定期清理掉无用的历史数据，建议让你们的DBA定期清理掉一个月或一周以前的数据

yb19890724 commented 9 months ago

@yedf2 感谢