22

Mysql骚操作：优化大分页查询-Java_老男孩

 4 years ago
source link: https://blog.51cto.com/14230003/2484686
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
背景系统结构如上图。经过排查是因为系统B拉取数据时间太长导致的推送超时。系统B拉取数据的方法是根据_tiemstamp(数据操作时间)分页查询系统A的接口,即：1SELECT字段名2FROM表名3WHERE_timestamp>=beginTimeAND_timestamp<=endTime4LIMITn,m;由于该数据是从其他数据源中导入的，所以_timestamp这个字段值几乎相同

report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK