MongoDB : Document-Oriented NoSQL Database
0
votes
1answer
434 views
What does reslen and other means in mongodb log?
database.tablebusiness query: { LongitudeLatitude: { $nearSphere: [ 106.772835, -6.186753 ], $maxDistance: 0.04498373205078301 }, Prominent: { $gte: 15 }, indexContents: { $all: [ /^aru/, /^op/ ] } } ...
0
votes
1answer
169 views
Where can I find manual and tutorial for rockmongo?
I tried to find it in google and couldn't find it.
Most just tell how to install. None tell how to use execute, for example.
0
votes
1answer
61 views
MongoDB: Can I perform a second query if the first doesn't match
When querying MongoDB is it possible to perform a query and if it isn't matched perform a second query. I could perform an $or which will do booth queries and return the results for booth but I only ...
0
votes
1answer
39 views
admin user can not login to other databases after upgrading to mongodb 2.4
I had a mongodb 2.2 database with auth enabled. but after upgrading to 2.4 my admin user can not login to any database other than admin database. I removed it from system.users then created another ...
0
votes
1answer
171 views
MongoDB Master and Slave Replication - Windows or Linux
I have recently moved my MS SQL Server Database to MongoDB (2.0) on Windows Server 2008. Its containing 2 databases with following stats. (both databases get around 100 reads/writes per second). These ...
0
votes
1answer
33 views
How to save mongodb data sub data more properly in this case?
I have a business collection.
The businesses are reviewed by users.
Each user can only review a business once. Future reviews will simply replace the former one.
This is how we store it:
...
0
votes
1answer
127 views
RegEx bug in MongoDB
I run the following queries on a collection that have a lot of entries that contain [ and ].
db.test.find({word:/[\[]/}); // could not be run in console
db.test.find({word:/\[/ }); ...
0
votes
1answer
74 views
Moving a collection to a new database (v2.2)
To take advantage of the improved concurrency in Mongodb 2.2--namely database level locking--we would like to move a sharded collection to a new database.
I have been unable to find any documentation ...
0
votes
1answer
78 views
Why searching with $all in Mongodb is FAR SLOWER than the EQUIVALENT search?
$all with only one item is equivalent with normal search right?
Here is the log without $all (I used 4700 test cases with 30 thread):
Thu Sep 20 17:27:05 [conn11] query newisikotagte15.tablebusiness ...
0
votes
1answer
56 views
Is Index Used for This Query
If so, which one?
How do we know?
I have 3 indexes in a query. Actually only the first 2 should be useful
{
"v": NumberInt(1),
"key": {
"LongitudeLatitude": "2d",
"Prominent"▼: ...
0
votes
1answer
115 views
The sort column must be the last column used in the index - MongoDB Indexing Advice
MongoDB docs advices that:
The sort column must be the last column used in the index
Here is the example:
db.foo.ensureIndex({a: 1, b: 1, c: 1})
Good:
find(a=1).sort(a)
find(a=1).sort(b)
...
0
votes
0answers
14 views
Is it possible to upgrade mongodb cluster without upgrading arbiters?
Is it possible to have running real nodes with version 2.4 and arbiter nodes with 2.0 or 1.8 in the replica set?
Upgrade guides for version 2.2 and 2.4, did not tell anything about upgrading ...
0
votes
0answers
35 views
MongoDB master - slave not syncing anymore
I have a setup with two MongoDB instances, one master and one slave. The sync worked perfectly fine for quite a while now, but suddenly stopped. The major problem is, that the guy who setup the ...
0
votes
0answers
31 views
The best approach to index dynamic query in MongoDB
I am working on log managment system where user will be able to upload logs from file. I have 'event' collection where I store all events from all sources (each source can have different log format ...
0
votes
1answer
55 views
Getting next and previous document
In a mongo collection I have a list of words (millions words).
{word:'a'}
{word:'b'}
{word:'x'}
{word:'y'}
{word:'z'}
I need to get lexical adjacent of a word. I am looking for most efficient ...
0
votes
0answers
27 views
MongoDB: move documents before capping
The cappedCollection concept works well for most of my projects where cleaning old data without care makes sense.
For another projects, I need a more complex and safe concept. The requirement is ...
0
votes
0answers
36 views
MongoDB: Aggregation workaround by helper collection
Since I regularly run against mongodb's document size limit and also aggregation framework's group limitations >16M, depending on the amount of data I need to process, I look for a simple workaround.
...
0
votes
0answers
63 views
MongoDB: group and document size limitation with aggregation and MapReduce
Hitting the limitations of MongoDB (in a single machine environment), I wonder which part of MapReduce and aggregation with group/$group is causing the troubles.
Usually I use a mix of MR/Aggregation ...
0
votes
0answers
28 views
AWS Marketplace Mongo, how to create replica
I am new to mongo, one of the first things it appears needs to be done is to create mongo replica sets as this avoids mongo write locking issues.
I set up mongo on AWS by getting mongo off the AWS ...
0
votes
0answers
12 views
Mongo replication lag slowly increasing [duplicate]
I am running a replica-set in production with slaveOk = false using mongo 2.0.7 in AWS The replication lag on one of the servers is close to 58 hours. This replication lag is sometimes decreasing ( at ...
0
votes
0answers
88 views
To scale horizontally, is MySQL with sharding, memcache and master-slave replication better than MongoDB
I am building an api, to share discounts between users. Each discount can be linked with several users, using joins and many to many relationships.
Currently I am using MySQL and I am looking to ...
0
votes
1answer
134 views
Choosing shard key and friendly URL Ids for my MongoDB
I have decided to use MongoDB as my Database for a web application. However, I have some difficulties to get started and I hope that you can help me out with a few questions.
I am developing my ...
0
votes
0answers
139 views
Why this query takes 500 seconds to complete even though I got all the compound index right?
I tried this query
db.tablebusiness.find({ "LongitudeLatitude" : { "$nearSphere" : [106.772835, -6.186753], "$maxDistance" : 0.053980478460939611 }, "Prominent" : { "$gte" : 15 }, "indexContents" : { ...
0
votes
0answers
62 views
How can we combine $within and $nearSphere in mongodb
Say I am looking for the nearest location that contain the word seaworld.
I don't want mongodb to "scan" an area too wide.
So I want to limit it
I send
db.tablebusiness.find({ "LongitudeLatitude" ...
-1
votes
2answers
166 views
MongoDB replication to one machine
Does MonogDB supports replication where I have many machines with MongoDB that have different data and I want to replicate this data to one, and only one MongoDB?
-2
votes
1answer
148 views
Compare MongoDB and MySQL
Can anyone help me to make right decision for choosing scalable and reliable database?
I have to create 3-4 tables with around 200 columns each and these tables will have around 5000 data records. As ...
