当前位置： 首页 > news >正文

湖北标书设计制作360手机优化大师下载

news 2025/7/25 22:48:34
湖北标书设计制作,360手机优化大师下载,合川招聘合优网,自己做充值网站我用mongoDB管理股票行情数据，目前已保存行情数据约120GB，在一个Quote集合中包含ticks(448903576条记录)和bids(622612318条记录)两个数据表，两个数据表都建立有日期和代码索引。使用的是mongoDB 3.0.7版64位版本。最近发现写入数据时会非常慢…

我用mongoDB管理股票行情数据，目前已保存行情数据约120GB，在一个Quote集合中包含ticks(448903576条记录)和bids(622612318条记录)两个数据表，两个数据表都建立有日期和代码索引。使用的是mongoDB 3.0.7版64位版本。

最近发现写入数据时会非常慢，经常有时写入一条记录要10多秒，正常时写入一条记录是100ms左右。朋友用的服务器远不如我的服务器配置，而且同样一个mongoDB表数据记录超过1亿条，依然能快速写入，不知为何。

摘取了部分log如下，能帮我分析一下原因吗？

2015-11-01T21:45:47.444+0800 I WRITE [conn31] insert quote.bids query: { _id: ObjectId('563617890bda790fc8b98d17'), code: "000893", price: 3.552713678800501e-015, volume: 2, flag: "00C", dt: new Date(1446212410000) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 6, w: 6 } }, MMAPV1Journal: { acquireCount: { w: 702 }, acquireWaitCount: { w: 1 }, timeAcquiringMicros: { w: 109947 } }, Database: { acquireCount: { w: 6 } }, Collection: { acquireCount: { W: 6 } } } 110ms

2015-11-01T21:45:47.456+0800 I COMMAND [conn31] command quote.$cmd command: insert { insert: "bids", ordered: true, documents: 1000 } keyUpdates:0 writeConflicts:0 numYields:0 reslen:40 locks:{ Global: { acquireCount: { r: 9, w: 9 } }, MMAPV1Journal: { acquireCount: { w: 1009 }, acquireWaitCount: { w: 1 }, timeAcquiringMicros: { w: 109947 } }, Database: { acquireCount: { w: 9 } }, Collection: { acquireCount: { W: 9 } } } 144ms

2015-11-01T21:46:08.731+0800 I COMMAND [conn31] command quote.$cmd command: insert { insert: "bids", ordered: true, documents: 1000 } keyUpdates:0 writeConflicts:0 numYields:0 reslen:40 locks:{ Global: { acquireCount: { r: 9, w: 9 } }, MMAPV1Journal: { acquireCount: { w: 1009 }, acquireWaitCount: { w: 1 }, timeAcquiringMicros: { w: 69102 } }, Database: { acquireCount: { w: 9 } }, Collection: { acquireCount: { W: 9 } } } 104ms

2015-11-01T21:46:20.071+0800 I WRITE [conn31] insert quote.bids query: { _id: ObjectId('563617ab0bda790fc8bdf667'), code: "000916", price: 5.739999999999998, volume: 69, flag: "00B", dt: new Date(1446212949000) } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 4, w: 4 } }, MMAPV1Journal: { acquireCount: { w: 415 }, acquireWaitCount: { w: 1 }, timeAcquiringMicros: { w: 103010 } }, Database: { acquireCount: { w: 4 } }, Collection: { acquireCount: { W: 4 } } } 103ms

2015-11-01T21:46:20.093+0800 I COMMAND [conn31] command quote.$cmd command: insert { insert: "bids", ordered: true, documents: 1000 } keyUpdates:0 writeConflicts:0 numYields:0 reslen:40 locks:{ Global: { acquireCount: { r: 9, w: 9 } }, MMAPV1Journal: { acquireCount: { w: 1009 }, acquireWaitCount: { w: 1 }, timeAcquiringMicros: { w: 103010 } }, Database: { acquireCount: { w: 9 } }, Collection: { acquireCount: { W: 9 } } } 137ms

2015-11-01T21:46:26.793+0800 I COMMAND [conn31] command quote.$cmd command: insert { insert: "bids", ordered: true, documents: 1000 } keyUpdates:0 writeConflicts:0 numYields:0 reslen:40 locks:{ Global: { acquireCount: { r: 9, w: 9 } }, MMAPV1Journal: { acquireCount: { w: 1009 }, acquireWaitCount: { w: 1 }, timeAcquiringMicros: { w: 71011 } }, Database: { acquireCount: { w: 9 } }, Collection: { acquireCount: { W: 9 } } } 101ms

2015-11-01T21:46:36.054+0800 I COMMAND [conn31] command quote.$cmd command: insert { insert: "bids", ordered: true, documents: 1000 } keyUpdates:0 writeConflicts:0 numYields:0 reslen:40 locks:{ Global: { acquireCount: { r: 9, w: 9 } }, MMAPV1Journal: { acquireCount: { w: 1009 }, acquireWaitCount: { w: 1 }, timeAcquiringMicros: { w: 73748 } }, Database: { acquireCount: { w: 9 } }, Collection: { acquireCount: { W: 9 } } } 113ms

2015-11-01T21:46:51.225+0800 I STORAGE [DataFileSync] flushing mmaps took 63267ms for 12 files

*****以下是最近异常的log记录*****

2015-11-29T08:29:59.714+0800 I WRITE [conn65] insert quote.ticks query: { _id: ObjectId('565a46d50bda79121c058f73'), code: "603066", price: 58.43, volume: 1.0, dt: new Date(1448631616000), side: "S" } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 115, w: 115 } }, MMAPV1Journal: { acquireCount: { w: 527 }, acquireWaitCount: { w: 12 }, timeAcquiringMicros: { w: 122008 } }, Database: { acquireCount: { w: 115 } }, Collection: { acquireCount: { W: 115 }, acquireWaitCount: { W: 115 }, timeAcquiringMicros: { W: 2526086 } } } 140ms

2015-11-29T08:29:59.714+0800 I WRITE [conn63] insert quote.ticks query: { _id: ObjectId('565a46f70bda791154306e11'), code: "600395", price: 8.050000000000001, volume: 78.0, dt: new Date(1448617010000), side: "S" } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 409, w: 409 } }, MMAPV1Journal: { acquireCount: { w: 1761 }, acquireWaitCount: { w: 25 }, timeAcquiringMicros: { w: 115750 } }, Database: { acquireCount: { w: 409 } }, Collection: { acquireCount: { W: 409 }, acquireWaitCount: { W: 409 }, timeAcquiringMicros: { W: 13637358 } } } 141ms

2015-11-29T08:29:59.714+0800 I WRITE [conn67] insert quote.ticks query: { _id: ObjectId('565a46e90bda79179838a80e'), code: "000790", price: 15.19, volume: 2.0, dt: new Date(1448619704000), side: "S" } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 224, w: 224 } }, MMAPV1Journal: { acquireCount: { w: 1255 }, acquireWaitCount: { w: 20 }, timeAcquiringMicros: { w: 50202 } }, Database: { acquireCount: { w: 224 } }, Collection: { acquireCount: { W: 224 }, acquireWaitCount: { W: 224 }, timeAcquiringMicros: { W: 5196956 } } } 141ms

2015-11-29T08:30:00.101+0800 I COMMAND [conn63] command quote.$cmd command: insert { insert: "ticks", ordered: true, documents: 1000 } keyUpdates:0 writeConflicts:0 numYields:0 reslen:40 locks:{ Global: { acquireCount: { r: 421, w: 421 } }, MMAPV1Journal: { acquireCount: { w: 1842 }, acquireWaitCount: { w: 27 }, timeAcquiringMicros: { w: 133006 } }, Database: { acquireCount: { w: 421 } }, Collection: { acquireCount: { W: 421 }, acquireWaitCount: { W: 421 }, timeAcquiringMicros: { W: 13865934 } } } 16363ms

2015-11-29T08:30:01.036+0800 I WRITE [conn65] insert quote.ticks query: { _id: ObjectId('565a46d50bda79121c058fdf'), code: "603066", price: 58.7, volume: 5.0, dt: new Date(1448631877000), side: "S" } ninserted:1 keyUpdates:0 writeConflicts:0 numYields:0 locks:{ Global: { acquireCount: { r: 153, w: 153 } }, MMAPV1Journal: { acquireCount: { w: 711 }, acquireWaitCount: { w: 16 }, timeAcquiringMicros: { w: 123164 } }, Database: { acquireCount: { w: 153 } }, Collection: { acquireCount: { W: 153 }, acquireWaitCount: { W: 153 }, timeAcquiringMicros: { W: 3215329 } } } 108ms

http://www.lbrq.cn/news/2458099.html

相关文章：

  • 杭州品格网站设计优化是什么意思
  • 青岛东八区创意做网站kol合作推广
  • 网页制作软件培训机构优化网站结构一般包括
  • 如何做企业网站规划在线资源链接
  • 大型的网页设计公司关键词优化是什么工作
  • wordpress网站百度不收录外贸平台
  • 微商怎么引流推广宁波seo链接优化
  • 今日重大新闻头条财经建站优化公司
  • 成品网站 修改首页亚洲长尾关键词挖掘
  • 织梦 网站复制什么是搜索引擎竞价推广
  • 哪个网站的地图可以做分析图网站推广seo教程
  • 北京公司请做网站工资免费友情链接网页
  • 零食铺网站建设策划书网站设计模板
  • 上海市城乡住房建设厅网站希爱力的功效及副作用
  • 专业简历制作软件长沙网站seo诊断
  • 企业在公司做的网站看不到查看今日头条
  • 网站如何做关键字收录网络营销工具介绍
  • 济宁网站建设有限公司深圳最新新闻事件今天
  • 网页美工设计流程为win7优化配置的方法
  • 相城网页设计seo案例
  • 苏州网站推广找苏州梦易行今日新闻最新
  • 音乐网站建设教程楚雄今日头条新闻
  • 社联网站建设的目的广州百度推广代理公司
  • phpcms 图片网站中央常委成员名单
  • 中铁三局招聘2022关键词优化怎么弄
  • wordpress 扒站教程seo推广方法有哪些
  • 房产交易网站建设策划案店铺推广软文300字
  • 做网站的项目职责怎么写网络营销站点推广的方法
  • wordpress使用云数据库连接全国最好网络优化公司
  • 西安本地十家做网站建设的公司网页优化最为重要的内容是
  • reflections：Java非常好用的反射工具包
  • rust-方法语法
  • 第三章：掌握 Redis 存储与获取数据的核心命令
  • 电商项目_秒杀_架构升级
  • langchain+本地embedding模型+milvus实现RAG
  • 【基于OpenCV的图像处理】图像预处理之图像色彩空间转换以及图像灰度化处理