Details
-
Bug
-
Resolution: Unresolved
-
Major - P3
-
None
-
3.4.4
-
Catalog and Routing
-
ALL
-
-
(copied to CRM)
-
3
Description
Hi team,
We are using a 10 shards (Primary / Secondary / Arbiter) cluster to host around 20k databases.
We noticed that creating new databases take lot of time, around 10s :
2017-09-11T09:48:52.763+0000 I SHARDING [conn641] distributed lock 'anthony110920175' acquired for 'createDatabase', ts : 59b65c04bb2f983e7e106b2c
|
2017-09-11T09:49:02.438+0000 I SHARDING [conn641] Placing [anthony110920175] on: clust-1-sh1
|
2017-09-11T09:49:02.448+0000 I SHARDING [conn641] distributed lock with ts: 59b65c04bb2f983e7e106b2c' unlocked.
|
It looks like a
db.runCommand({listDatabases:1}) |
Adding the "nameOnly:true" option make the query almost instantaneous. Maybe it should be added when a mongos check database existency ?
Regards,
Anthony
Attachments
Issue Links
- is related to
-
SERVER-35431 rollback does not correct sizeStorer data sizes
-
- Backlog
-
- related to
-
SERVER-31083 Allow passing primary shard to "enableSharding" command for a new database
-
- Closed
-