want to take full advantage of MongoDB performance, it is recommended to adopt the Insert method without "_id", and then index the related fields to query .8.2 Testing issues that require further attentionThe read test for MongoDB is poorly thought out, although this is just an extra test. In this test, it is necessar
the database as long as the data reaches tens of millions, without making the index of a database very huge. Note the following issues during the test:
1) when the data volume is large and the service is restarted, although the data query and modification can be accepted in the initialization phase of the Service Startup, the performance is poor at this time, because m
change the library-level lock to a document-level lock. Performance issues caused by library-level locks should be expected to be significantly improved. Scenario Four: Micro-shardingThe definition of a differentiator is the use of MongoDB's Shard technology, but multiple or all Shard Mongod run on the same server (the server can be a physical or virtual machine). Because of the existence of library-level
Statement: The article is mainly from the "MongoDB Real Combat" a book, the main want to learn MongoDB knowledge through the book, deepen understanding, so write in their blog, as recorded in the last chapter, there will be a collection of MongoDB database application Java EE Web application.1, MongostatThis tool provides a quick view of statistics for a set of r
MongoDB Performance Analysis method:explain ()To demonstrate the effect, let's start by creating a record with 2 million documents. (My own computer took about 15 minutes to insert the completed.) If you want to plug in more documents It's okay, just be patient and wait. )1 for (var i=0;i) {2 db.person.insert ({"Name": "Ryan" +i, "age": i}); 3 }After MongoDB
data volume was measured due to time at the end, it can prove how powerful MongoDB is. Another reason is that, in many cases, we may split the database as long as the data reaches tens of millions, without making the index of a database very huge. Note the following issues during the test:
1) when the data volume is large and the service is restarted, although the data query and modification can be accep
. Another reason is that, in many cases, we may split the database as long as the data reaches tens of millions, without making the index of a database very huge. Note the following issues during the test:
1) when the data volume is large and the service is restarted, although the data query and modification can be accepted in the initialization phase of the Service Startup, the performance is poor at thi
reason is that in many cases it is possible that the data will only be up to the point where we split the library and not make the index of a library very large.Several issues need to be noted in the course of testing:1) In the case of a large amount of data, the service is restarted, then the initialization phase of the service startup, although it can accept the data query and modification, but at this time poor
Test conclusion
1. Compared to MySQL, theMongoDB database is more suitable for those task models that read the job more heavily . MongoDB can take full advantage of the machine's memory resources. MongoDB's query efficiency can be much faster if the machine's memory resources are plentiful.
2. When inserting data with "_id", the efficiency of MongoDB insertion is not high. If you want to t
Chapter III index operations and performance testing
The importance of indexes under big data is not much to say.The following test used a MongoDB client tool Robomongo, you can choose to download on the Internet. Inserting test dataInsert 1 million test data first for (var i=1;i1000000; i++) { var person={name: "Jack" +i,age:i,address:["Henan", "Wuhan"],course:[{name: "Shuxue", Score:i },{Name: "Wu
tecmint.com.ssh > 115.113.134.3.static-mumbai.vsnl.net.in.28472:p 116:232 ($) Ack 1 win 964822:08:59.617916 IP 115.113.134.3.static-mumbai.vsnl.net.in.28472 > Tecmint.com.ssh:. ACK-$ win 643475.netstat-Network Status statisticsNetstat is a command-line tool for monitoring packet and network interface statistics for incoming and outgoing networks. It is a very useful tool that system administrators can use to monitor network performance, locate and tr
. I think Data Forwarding may be a cause of performance loss, although mongos is on the press machine, but the data is always transferred once ).
5) the disk space usage is similar to that of the two. Some of the gaps may be due to the fact that multiple processes allocate more space, in addition, a single process occupies more disk space than a single process, while those that occupy less space than a single process are actually the starting encoding
I used to pursue new things, and found the foundation is the most important, this year's main goal is to master SQL query and SQL performance optimization.This series of "T-SQL Fundamentals" is primarily a summary of the T-SQL Foundation."T-SQL Basics" 01. Single-Table query-several SQL query questions"T-SQL Basics" 02. Join Query"T-SQL Basics" 03. Subqueries"T-SQL Basics" 04. Table Expression-Previous"T-SQL Basics" 04. Table Expression-Next"T-SQL Bas
-mumbai.vsnl.net.in.28472:p 2,532,133,365:2,532,133,481 (116) Ack 3561562349 win 964822:09:07.653466 IP tecmint.com.ssh > 115.113.134.3.static-mumbai.vsnl.net.in.28472:p 116:232 ($) Ack 1 win 964822:08:59.617916 IP 115.113.134.3.static-mumbai.vsnl.net.in.28472 > Tecmint.com.ssh:. ACK-$ win 643475.netstat-Network Status statisticsNetstat is a command-line tool for monitoring packet and network interface statistics for incoming and outgoing networks. It is a very useful tool that system administra
Tags: Lucene style blog Color http intHubbledotnet starting from 1.2.3 version in the official code to support and MongoDB docking, MongoDB is a 10gen company developed No-sql database, its read and write performance than traditional relational database is much faster, and can be very convenient distributed deployment. Hubbledotnet also provides No-sql solutions
Tags: blog http io os ar for SP CTI onPlaceholderHttps://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=2082062510193540id=1366133.1_ afrwindowmode=0_adf.ctrl-state=rru77dj7v_139Note:1417774.1-faq:sql Health Check (SQLHC) Frequently asked QuestionsNOTE:224270.1-TRCANLZR (TRCA): sql_trace/event 10046 TRACE File analyzer-tool for interpreting Raw SQL tracesNote:1627387.1-how to determine the sql_id for a SQL StatementNote:1455583.1-sql Tuning Health-check Script (SQLHC) VideoNOTE:215187.1
data returned by the server and also requires a process (or time)We in the SQL optimization process, if a SQL performance problem, we should stand in a global perspective to analyze the problem, from the CPU resources, network bandwidth, disk IO, execution plan and other aspects to analyze, so as to help you analyze, locate the root cause of the problem, and not as long as the SQL response is slow, Just a reflex: this is a database problem. The datab
are free open-source databases. There are many basic differences between MySQL and MongoDB, including data representation, querying, relationships, transactions, schema design and definition, standardization (normalization), speed and performance. By comparing MySQL and MongoDB, we are actually comparing relational and non-relational databases. Read more4. How d
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.