Designing Your Application PartII

最新推荐文章于 2023-03-08 11:47:38 发布
最新推荐文章于 2023-03-08 11:47:38 发布
阅读量967 收藏
点赞数
分类专栏： MongoDB海洋航线 文章标签： mongodb
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u011868279/article/details/123992102
版权

Chapter 5 Indexes

In this chapter we will cover:

  • What indexes are and why you'd want to use them.
  • How to choose which fields to index
  • How to enforce and evaluate index usage
  • Administrative details on creating and removing indexes.

Introduction to Indexes

A query that does not use an index is called a collection scan,which mean that the server has to "look through the whole book" to find query's results.

> 
> for (i=0;i<1000000;i++){
...     db.users.insertOne(
...         {
...              "i":i,
...              "username":"user"+i,
...              "age": Math.floor(Math.random()*120),
...              "created": new Date()
...         }
...     );
... }
{
        "acknowledged" : true,
        "insertedId" : ObjectId("624d9142e5e7e0a95c1ee18a")
}
> 
> db.users.find({"username": "user101"}).explain("executionStats")
{
        "queryPlanner" : {
                "plannerVersion" : 1,
                "namespace" : "users.users",
                "indexFilterSet" : false,
                "parsedQuery" : {
                        "username" : {
                                "$eq" : "user101"
                        }
                },
                "winningPlan" : {
                        "stage" : "COLLSCAN",
                        "filter" : {
                                "username" : {
                                        "$eq" : "user101"
                                }
                        },
                        "direction" : "forward"
                },
                "rejectedPlans" : [ ]
        },
        "executionStats" : {
                "executionSuccess" : true,
                "nReturned" : 1,
                "executionTimeMillis" : 808,
                "totalKeysExamined" : 0,
                "totalDocsExamined" : 1000001,
                "executionStages" : {
                        "stage" : "COLLSCAN",
                        "filter" : {
                                "username" : {
                                        "$eq" : "user101"
                                }
                        },
                        "nReturned" : 1,
                        "executionTimeMillisEstimate" : 71,
                        "works" : 1000003,
                        "advanced" : 1,
                        "needTime" : 1000001,
                        "needYield" : 0,
                        "saveState" : 1000,
                        "restoreState" : 1000,
                        "isEOF" : 1,
                        "direction" : "forward",
                        "docsExamined" : 1000001
                }
        },
        "serverInfo" : {
                "host" : "DBAMAXWELL",
                "port" : 27017,
                "version" : "4.4.13",
                "gitVersion" : "df25c71b8674a78e17468f48bcda5285decb9246"
        },
        "ok" : 1
}
> 

> 
> db.users.createIndex({"username": 1})
{
        "createdCollectionAutomatically" : false,
        "numIndexesBefore" : 1,
        "numIndexesAfter" : 2,
        "ok" : 1
}
> db.users.find({"username": "user101"}).explain("executionStats")
{
        "queryPlanner" : {
                "plannerVersion" : 1,
                "namespace" : "users.users",
                "indexFilterSet" : false,
                "parsedQuery" : {
                        "username" : {
                                "$eq" : "user101"
                        }
                },
                "winningPlan" : {
                        "stage" : "FETCH",
                        "inputStage" : {
                                "stage" : "IXSCAN",
                                "keyPattern" : {
                                        "username" : 1
                                },
                                "indexName" : "username_1",
                                "isMultiKey" : false,
                                "multiKeyPaths" : {
                                        "username" : [ ]
                                },
                                "isUnique" : false,
                                "isSparse" : false,
                                "isPartial" : false,
                                "indexVersion" : 2,
                                "direction" : "forward",
                                "indexBounds" : {
                                        "username" : [
                                                "[\"user101\", \"user101\"]"
                                        ]
                                }
                        }
                },
                "rejectedPlans" : [ ]
        },
        "executionStats" : {
                "executionSuccess" : true,
                "nReturned" : 1,
                "executionTimeMillis" : 1,
                "totalKeysExamined" : 1,
                "totalDocsExamined" : 1,
                "executionStages" : {
                        "stage" : "FETCH",
                        "nReturned" : 1,
                        "executionTimeMillisEstimate" : 0,
                        "works" : 2,
                        "advanced" : 1,
                        "needTime" : 0,
                        "needYield" : 0,
                        "saveState" : 0,
                        "restoreState" : 0,
                        "isEOF" : 1,
                        "docsExamined" : 1,
                        "alreadyHasObj" : 0,
                        "inputStage" : {
                                "stage" : "IXSCAN",
                                "nReturned" : 1,
                                "executionTimeMillisEstimate" : 0,
                                "works" : 2,
                                "advanced" : 1,
                                "needTime" : 0,
                                "needYield" : 0,
                                "saveState" : 0,
                                "restoreState" : 0,
                                "isEOF" : 1,
                                "keyPattern" : {
                                        "username" : 1
                                },
                                "indexName" : "username_1",
                                "isMultiKey" : false,
                                "multiKeyPaths" : {
                                        "username" : [ ]
                                },
                                "isUnique" : false,
                                "isSparse" : false,
                                "isPartial" : false,
                                "indexVersion" : 2,
                                "direction" : "forward",
                                "indexBounds" : {
                                        "username" : [
                                                "[\"user101\", \"user101\"]"
                                        ]
                                },
                                "keysExamined" : 1,
                                "seeks" : 1,
                                "dupsTested" : 0,
                                "dupsDropped" : 0
                        }
                }
        },
        "serverInfo" : {
                "host" : "DBAMAXWELL",
                "port" : 27017,
                "version" : "4.4.13",
                "gitVersion" : "df25c71b8674a78e17468f48bcda5285decb9246"
        },
        "ok" : 1
}
> 

Introduction to Compound Indexes

The purpose of an index is to make your queries as efficient as possible.For many query patterns it is necessary to build indexes based on two or more keys.

> 
> db.users.find().sort({"age": 1,"username": 1})
Error: error: {
        "ok" : 0,
        "errmsg" : "Executor error during find command :: caused by :: Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting.",
        "code" : 292,
        "codeName" : "QueryExceededMemoryLimitNoDiskUseAllowed"
}
> db.users.createIndex({"age": 1, "username": 1})
{
        "createdCollectionAutomatically" : false,
        "numIndexesBefore" : 2,
        "numIndexesAfter" : 3,
        "ok" : 1
}

This is called a compound index and is useful if your query has multiple sort directions or multiplle keys in the criteria.A compound index is an index on more than one field.
> db.users.find({},{"_id": 0, "i": 0, "created": 0})
{ "name" : "joe", "age" : 30, "sex" : "male", "location" : "Wisconsin" }
{ "username" : "user0", "age" : 93 }
{ "username" : "user1", "age" : 98 }
{ "username" : "user2", "age" : 61 }
{ "username" : "user3", "age" : 58 }
{ "username" : "user4", "age" : 67 }
{ "username" : "user5", "age" : 8 }
{ "username" : "user6", "age" : 93 }
{ "username" : "user7", "age" : 14 }
{ "username" : "user8", "age" : 58 }
{ "username" : "user9", "age" : 77 }
{ "username" : "user10", "age" : 97 }
{ "username" : "user11", "age" : 53 }
{ "username" : "user12", "age" : 57 }
{ "username" : "user13", "age" : 94 }
{ "username" : "user14", "age" : 20 }
{ "username" : "user15", "age" : 87 }
{ "username" : "user16", "age" : 57 }
{ "username" : "user17", "age" : 17 }
{ "username" : "user18", "age" : 50 }
Type "it" for more
> 

The way MongoDB uses this index depends on the type of query you're doing.These are the three most common ways:

  • This is an equality query, which searches for a single value.

this type of query is very efficient: MongoDB can jump directly to do the correct and doesn't need to sort the results because traversing the index returns the data in the correct order.
> db.users.find({"age": 21}).sort({"username": -1})
{ "_id" : ObjectId("624d9141e5e7e0a95c1ee129"), "i" : 999902, "username" : "user999902", "age" : 21, "created" : ISODate("2022-04-06T13:10:25.954Z") }
{ "_id" : ObjectId("624d9141e5e7e0a95c1ee091"), "i" : 999750, "username" : "user999750", "age" : 21, "created" : ISODate("2022-04-06T13:10:25.764Z") }
{ "_id" : ObjectId("624d9141e5e7e0a95c1ee086"), "i" : 999739, "username" : "user999739", "age" : 21, "created" : ISODate("2022-04-06T13:10:25.754Z") }
{ "_id" : ObjectId("624d9141e5e7e0a95c1ee07b"), "i" : 999728, "username" : "user999728", "age" : 21, "created" : ISODate("2022-04-06T13:10:25.735Z") }
{ "_id" : ObjectId("624d9141e5e7e0a95c1ee051"), "i" : 999686, "username" : "user999686", "age" : 21, "created" : ISODate("2022-04-06T13:10:25.695Z") }
{ "_id" : ObjectId("624d9141e5e7e0a95c1ee04a"), "i" : 999679, "username" : "user999679", "age" : 21, "created" : ISODate("2022-04-06T13:10:25.690Z") }
{ "_id" : ObjectId("624d9141e5e7e0a95c1ee017"), "i" : 999628, "username" : "user999628", "age" : 21, "created" : ISODate("2022-04-06T13:10:25.621Z") }
{ "_id" : ObjectId("624d9141e5e7e0a95c1edfb3"), "i" : 999528, "username" : "user999528", "age" : 21, "created" : ISODate("2022-04-06T13:10:25.301Z") }
{ "_id" : ObjectId("624d9141e5e7e0a95c1edf9b"), "i" : 999504, "username" : "user999504", "age" : 21, "created" : ISODate("2022-04-06T13:10:25.274Z") }
{ "_id" : ObjectId("624d9141e5e7e0a95c1edef4"), "i" : 999337, "username" : "user999337", "age" : 21, "created" : ISODate("2022-04-06T13:10:25.038Z") }
{ "_id" : ObjectId("624d9140e5e7e0a95c1edebe"), "i" : 999283, "username" : "user999283", "age" : 21, "created" : ISODate("2022-04-06T13:10:24.974Z") }
{ "_id" : ObjectId("624d9140e5e7e0a95c1ede64"), "i" : 999193, "username" : "user999193", "age" : 21, "created" : ISODate("2022-04-06T13:10:24.874Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c112585"), "i" : 99898, "username" : "user99898", "age" : 21, "created" : ISODate("2022-04-06T12:51:59.448Z") }
{ "_id" : ObjectId("624d9140e5e7e0a95c1edcd7"), "i" : 998796, "username" : "user998796", "age" : 21, "created" : ISODate("2022-04-06T13:10:24.397Z") }
{ "_id" : ObjectId("624d9140e5e7e0a95c1edc7b"), "i" : 998704, "username" : "user998704", "age" : 21, "created" : ISODate("2022-04-06T13:10:24.285Z") }
{ "_id" : ObjectId("624d9140e5e7e0a95c1edc1e"), "i" : 998611, "username" : "user998611", "age" : 21, "created" : ISODate("2022-04-06T13:10:24.147Z") }
{ "_id" : ObjectId("624d913fe5e7e0a95c1edba7"), "i" : 998492, "username" : "user998492", "age" : 21, "created" : ISODate("2022-04-06T13:10:23.983Z") }
{ "_id" : ObjectId("624d913fe5e7e0a95c1ed9cd"), "i" : 998018, "username" : "user998018", "age" : 21, "created" : ISODate("2022-04-06T13:10:23.356Z") }
{ "_id" : ObjectId("624d913fe5e7e0a95c1ed9ae"), "i" : 997987, "username" : "user997987", "age" : 21, "created" : ISODate("2022-04-06T13:10:23.327Z") }
{ "_id" : ObjectId("624d913fe5e7e0a95c1ed9ac"), "i" : 997985, "username" : "user997985", "age" : 21, "created" : ISODate("2022-04-06T13:10:23.325Z") }
Type "it" for more
> 

  • This is range query, which looks for documents matching multiple values(in this case,all ages between 21 and 30).MongoDB will use the first key in the index,"age", to return the matching documents.

> 
> db.users.find({"age": {"$gte": 21, "$lte": 30}})
{ "_id" : ObjectId("624d8cefe5e7e0a95c11260a"), "i" : 100031, "username" : "user100031", "age" : 21, "created" : ISODate("2022-04-06T12:51:59.622Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c1126da"), "i" : 100239, "username" : "user100239", "age" : 21, "created" : ISODate("2022-04-06T12:51:59.864Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c112720"), "i" : 100309, "username" : "user100309", "age" : 21, "created" : ISODate("2022-04-06T12:51:59.935Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c112735"), "i" : 100330, "username" : "user100330", "age" : 21, "created" : ISODate("2022-04-06T12:51:59.958Z") }
{ "_id" : ObjectId("624d8cf0e5e7e0a95c11279d"), "i" : 100434, "username" : "user100434", "age" : 21, "created" : ISODate("2022-04-06T12:52:00.139Z") }
{ "_id" : ObjectId("624d8cf0e5e7e0a95c1127e5"), "i" : 100506, "username" : "user100506", "age" : 21, "created" : ISODate("2022-04-06T12:52:00.249Z") }
{ "_id" : ObjectId("624d8cf0e5e7e0a95c112842"), "i" : 100599, "username" : "user100599", "age" : 21, "created" : ISODate("2022-04-06T12:52:00.341Z") }
{ "_id" : ObjectId("624d8cf0e5e7e0a95c1128dc"), "i" : 100753, "username" : "user100753", "age" : 21, "created" : ISODate("2022-04-06T12:52:00.492Z") }
{ "_id" : ObjectId("624d8cf0e5e7e0a95c1128e2"), "i" : 100759, "username" : "user100759", "age" : 21, "created" : ISODate("2022-04-06T12:52:00.497Z") }
{ "_id" : ObjectId("624d8cf0e5e7e0a95c1128eb"), "i" : 100768, "username" : "user100768", "age" : 21, "created" : ISODate("2022-04-06T12:52:00.505Z") }
{ "_id" : ObjectId("624d8cf0e5e7e0a95c112921"), "i" : 100822, "username" : "user100822", "age" : 21, "created" : ISODate("2022-04-06T12:52:00.561Z") }
{ "_id" : ObjectId("624d8cf0e5e7e0a95c112a78"), "i" : 101165, "username" : "user101165", "age" : 21, "created" : ISODate("2022-04-06T12:52:00.951Z") }
{ "_id" : ObjectId("624d8cf0e5e7e0a95c112a91"), "i" : 101190, "username" : "user101190", "age" : 21, "created" : ISODate("2022-04-06T12:52:00.978Z") }
{ "_id" : ObjectId("624d8cf1e5e7e0a95c112aae"), "i" : 101219, "username" : "user101219", "age" : 21, "created" : ISODate("2022-04-06T12:52:01.014Z") }
{ "_id" : ObjectId("624d8cf1e5e7e0a95c112b98"), "i" : 101453, "username" : "user101453", "age" : 21, "created" : ISODate("2022-04-06T12:52:01.443Z") }
{ "_id" : ObjectId("624d8cf1e5e7e0a95c112be0"), "i" : 101525, "username" : "user101525", "age" : 21, "created" : ISODate("2022-04-06T12:52:01.536Z") }
{ "_id" : ObjectId("624d8cf1e5e7e0a95c112cd3"), "i" : 101768, "username" : "user101768", "age" : 21, "created" : ISODate("2022-04-06T12:52:01.881Z") }
{ "_id" : ObjectId("624d8c82e5e7e0a95c0fc716"), "i" : 10187, "username" : "user10187", "age" : 21, "created" : ISODate("2022-04-06T12:50:10.409Z") }
{ "_id" : ObjectId("624d8cf2e5e7e0a95c112d51"), "i" : 101894, "username" : "user101894", "age" : 21, "created" : ISODate("2022-04-06T12:52:02.048Z") }
{ "_id" : ObjectId("624d8c82e5e7e0a95c0fc71b"), "i" : 10192, "username" : "user10192", "age" : 21, "created" : ISODate("2022-04-06T12:50:10.510Z") }
Type "it" for more
>

In general , if MongoDB uses an index for a query it will return the resulting documents in index order.

  • This is a multivalue query,like the previous one, but this time it has a sort.

> 
> db.users.find({"age": {"$gte": 21, "$lte": 30}}).sort({"username":1})
{ "_id" : ObjectId("4b253b067525f35f94b60a31"), "name" : "joe", "age" : 30, "sex" : "male", "location" : "Wisconsin" }
{ "_id" : ObjectId("624d8c77e5e7e0a95c0fa333"), "i" : 1000, "username" : "user1000", "age" : 30, "created" : ISODate("2022-04-06T12:49:59.316Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c112604"), "i" : 100025, "username" : "user100025", "age" : 26, "created" : ISODate("2022-04-06T12:51:59.615Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c11260a"), "i" : 100031, "username" : "user100031", "age" : 21, "created" : ISODate("2022-04-06T12:51:59.622Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c112616"), "i" : 100043, "username" : "user100043", "age" : 28, "created" : ISODate("2022-04-06T12:51:59.634Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c112629"), "i" : 100062, "username" : "user100062", "age" : 22, "created" : ISODate("2022-04-06T12:51:59.654Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c112634"), "i" : 100073, "username" : "user100073", "age" : 30, "created" : ISODate("2022-04-06T12:51:59.669Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c11263c"), "i" : 100081, "username" : "user100081", "age" : 30, "created" : ISODate("2022-04-06T12:51:59.679Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c112656"), "i" : 100107, "username" : "user100107", "age" : 24, "created" : ISODate("2022-04-06T12:51:59.709Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c112667"), "i" : 100124, "username" : "user100124", "age" : 30, "created" : ISODate("2022-04-06T12:51:59.730Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c11267d"), "i" : 100146, "username" : "user100146", "age" : 24, "created" : ISODate("2022-04-06T12:51:59.754Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c11267e"), "i" : 100147, "username" : "user100147", "age" : 29, "created" : ISODate("2022-04-06T12:51:59.755Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c112691"), "i" : 100166, "username" : "user100166", "age" : 30, "created" : ISODate("2022-04-06T12:51:59.782Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c112698"), "i" : 100173, "username" : "user100173", "age" : 27, "created" : ISODate("2022-04-06T12:51:59.791Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c1126a2"), "i" : 100183, "username" : "user100183", "age" : 27, "created" : ISODate("2022-04-06T12:51:59.802Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c1126a6"), "i" : 100187, "username" : "user100187", "age" : 25, "created" : ISODate("2022-04-06T12:51:59.807Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c1126c8"), "i" : 100221, "username" : "user100221", "age" : 26, "created" : ISODate("2022-04-06T12:51:59.846Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c1126da"), "i" : 100239, "username" : "user100239", "age" : 21, "created" : ISODate("2022-04-06T12:51:59.864Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c1126e8"), "i" : 100253, "username" : "user100253", "age" : 29, "created" : ISODate("2022-04-06T12:51:59.879Z") }
{ "_id" : ObjectId("624d8cefe5e7e0a95c1126ea"), "i" : 100255, "username" : "user100255", "age" : 28, "created" : ISODate("2022-04-06T12:51:59.881Z") }
Type "it" for more
> 

 How MongoDB Select an Index

 Using Compound Indexes

In the previous sections,we've been using compound indexes,which are indexes with more than one key in them.

To recap, when designing a compound index:

• Keys for equality filters should appear first.

• Keys used for sorting should appear before multivalue fields.

• Keys for multivalue filters should appear last

Choosing key directions

Using covered queries

Implicit indexes

When Not to Index

Types of Indexes 

  • Unique Indexes

Unique indexes guarantee that each value will appear at most once in the index.

If a key does not exist, the index stores its value as null for that document.

  • Compound unique indexes

DB架构
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
Designing-Data-Intensive-Applications 英文高清完整下载
12-21
请复制该连接:https://pan.baidu.com/s/1slqjTDF ,下载.txt文档后,密码在文档中,直接粘贴即可下载,感谢支持
Designing Data-Intensive Applications 英文 pdf
09-30
《Designing Data-Intensive Applications》是一本专为IT专业人士编写的重要著作，专注于构建大规模、高可用性且可扩展的数据密集型应用。这本书由Martin Kleppmann撰写，深入探讨了现代数据存储、处理和分析的关键...
MongoDB 排序内存超出限制QueryExceededMemoryLimitNoDiskUseAllowed:Sort exceeded memory limit
qq_37975037的博客
04-26 3968
问题描述： 使用mongo进行排序时，报排序超出最大内存错误 org.springframework.data.mongodb.UncategorizedMongoDbException: Command failed with error 292 (QueryExceededMemoryLimitNoDiskUseAllowed): 'Error in $cursor stage :: caused by :: Sort exceeded memory limit of 104857600 bytes,
【Bug解决】pymongo.errors.OperationFailure: Executor error during find command :: caused by :: Sort exce
最新发布
兴趣使然的创作者
03-08 1748
使用pymongo时，这行代码触发如下报错：触发代码： 原因 查阅mongo中文文档(https://mongodb.net.cn/manual/reference/method/cursor.sort/#sort-limit-results)，得知此报错的原因是排序内容超越32MB的内存限制。文档解释：当无法从索引获取排序顺序时，MongoDB将对内存中的结果进行排序，这要求所排序的结果集小于32 MB。找到如下解决方法，参考：https://segmentfault.com/a/119000004098
解决MongoDB 排序超过内存限制的问题
09-09
最近小编遇到这样的问题：对集合执行一个大排序操作（如聚合），出现以下错误：（测试版本：MongoDB 3.0.6），怎么快速解决此问题呢？下面小编给大家分享MongoDB 排序超过内存限制的解决方法，一起看看吧
'Exceeded memory limit for $group, but didn't allow external sort. Pass allowDiskUse 解决 java 实例
亲测，只为展现最完美的有效！
01-17 2447
报错 ERROR[taskExecutorSchedule-13]o.s.s.s.TaskUtils$LoggingErrorHandler.handleError:95 -Unexpected error occurred in scheduled task org.springframework.data.mongodb.UncategorizedMongoDbException: Com...
mysql导入数据库报错解决方式
Bruce小鬼
03-21 4957
mysql导入数据库报错解决方式一、工具导入sql报错1、一般导入都是使用工具进行导入，但是在导入时候可能会报错，导致导入失败。如下：2、经过在网上查询，换了几种方式都没有解决。3、后来和开发人员聊天，发现了一种好用的方式。首先用格式化工具例如：Notepad++工具打开导出的sql文件。如下：4、复制全部sql语句。5、在mysql工具中粘贴，执行sql语句。导入成功。...
Designing A Common Sense Approach to Web & Mobile Application Design
08-14
Qualities of a great application 8 How Do You Design the Obvious? 10 Turn qualities into goals 10 The Framework for Obvious Design 12 Know what to build 14 Know what makes it great 14 Know the ...
Designing Data Intensive Applications epub
01-26
《》Designing Data Intensive Applications》epub版本
idea连接mysql报错
weixin_59061079的博客
11-18 774
解决idea连接虚拟机mysql报错的问题
yaml使用总结
qq_17200461的博客
01-26 1065
YAML 是专门用来写配置文件的语言，非常简洁和强大，远比 JSON 格式方便。 yaml基本语法 • key: value；kv之间有空格 k: v • 大小写敏感 • 使用缩进表示层级关系 • 缩进不允许使用tab，只允许空格 • 缩进的空格数不重要，只要相同层级的元素左对齐即可 • '#'表示注释 • 字符串默认不使用引号表示。如果字符串之中包含空格或特殊字符，需要放在引号之中。 单引号和双引号都可以使用，双引号不会对特殊字符转义。 单引号之中如果还有单引号，必须连续使用两个单引号转义。 字符串可以
FATAL can not read a block mapping entry解决办法
feinifi的博客
03-20 7500
通过hexo搭建博客，正常安装，启动，都没有问题，后来，配置了_config.yml文件，出现了如题错误： 最后发现竟然是配置时少写了空格，导致的。这个配置文件真是很奇怪。 每一个配置项都是名称+冒号+空格＋设置参数配置而成。这种就好像shell脚本里面赋值“=”号后面必须没有空格一样，这里必须有空格。
MongoDB分页及提示find查询错误/超内存的问题解决
qq_36014509的博客
04-08 2214
MongoDB的分页查询就需要先对数据进行一个排序，数据量过大的时候我们排序就会报错误。 error: "Internal Server Error",…}error:"Internal Server Error" message:"Query failed with error code 96 and error message 'Executor error during find c...
小狼-MongoDB数据多时报错
qq_44729800的博客
07-09 1012
Query failed with error code 292 and error message 'Executor error during find command :: caused by :: Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in.' on server 1
IDEA连接数据库报错
m0_67877471的博客
04-26 605
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Public Key Retrieval is not allowed 解决方法是在数据库连接后面添加 allowPublicKeyRetrieval=true 文档中(https://mysql-net.github.io/MySqlConnector/connection-options/)给出的解释是： 如果用户使用了 sha256_password 认证.
Mongo聚合函数使用Sort排序时内存不足导致查询失败,开启allowDiskUse=true
黄嚯嚯
12-18 8737
目录 1、问题描述 2、问题解决 1. Java代码方式解决办法 2. Mongo 原生聚合函数解决办法 1、问题描述 由于项目原因, 需要向数据存储至mongo，在使用过程中 , 单个document(集合)数据量大概在80万条左右 , 单条数据为16的栏位(属性) , 现有如下需求 , 根据某些特定条件一次性查出N条数据(大致数量在8万条左右) , 并进行 sort 排序,然后在使用Java代码查询时候, 直接抛出了异常 , 经过Debug跟踪发现在问题具体抛出点是在 进行Sort时导
自动化 BPM 应用设计指南
"Designing.Efficient.BPM.Applications.2016.3.pdf" 是一本关于如何设计高效业务流程管理（Business Process Management, BPM）应用的实用指南，适合业务分析师阅读。这本书由专家Christine McKinty和Antoine ...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值