The following is a detailed description of the system configuration that affects MongoDB, especially in the production environment.1, the production environment recommended platform
Amazon Linux
Debian 7.1
Red Hat/centos 6.2+
Today I saw the official document of MongoDB Wiredtiger Storage engine, said I Wiredtiger Storage engine understanding!After the mongodb3.2 version, the Wiredtiger storage engine is the default storage engine.Document level ConcurrencyWiredtiger
AIX details user/process memory usage Description: topas indicates that % comp memory is used 98% Problem Analysis: 1, process ps aux | head-1; ps aux | sort-rn + 3 | head-10 in ascending order of 10 memory usage. For details, see process: ps-ealf |
MySQL5.6 basic optimization configuration with the improvement of a large number of default options, MySQL 5.6 has fewer options to be optimized than previous versions. in this article, I will describe the configuration items to be optimized.
Mysql optimization Summary (1)
I. SQL _mode mode of mysql:
(1) This mode means that the SQL mode can control server operations, and the SQL mode exists at the global and session level. If you want to know the current value of global or session-level
SummaryIntroducing the internal principles of Elasticsearch Shard from the bottom and answering why is it necessary to understand the internal workings of Lucene using Elasticsearch?
Understand the cost of the Elasticsearch API
Laravel provides five cache driver modes:• File system• Database• Memcached• APC• Redis• Memory (Arrays)By default, Laravel is configured to use the file system cache driver, which does not need to be configured. the file system driver stores cached
It is often necessary to monitor the running status of memcached on the server, such as the number of cache queries and hit rate. ButThe memcached-tool is written in Perl in Linux, and I have never tried whether it can be used in windows. Later, I
In the Apache server, keepalive is a Boolean value. On indicates opening, and off indicates disabling. This command exists in many other HTTPd servers.The keepalive configuration command determines whether to immediately close the TCP connection
The figure above summarizes the logical and physical architecture components, locks and transactions, backup policies, and tuning advantages of innodb mysql. The following describes each point.
In terms of thread processing, Mysql is a
Windows Embedded Compact 7 (WEC7) supports a variety of common File systems, including three different types of FAT (File Allocation Tabe) File systems. Applications can access files through file I/O functions without worrying about how the
Db file async I/O submit waiting for event optimization, asyncsubmit
Db file async I/O submit wait for event Optimization
I. Data Generation db file async I/O submit
We often see Wait events for high db file async I/O submit from the database awr
The strace in Linux can help us track program system calls. LGWR is an important process in Oracle and is responsible for writing redo logs into online redo logs.
Let's try to use strace to peat LGWR behavior.
First, find the LGWR process Number:
Differences between mysql status and variables First, you can use the following two commands to view the corresponding mysql system parameters.Show status like '% abc % ';Show variables like '% abc % '; However, many people do not understand the
In the Apache server, keepalive is a Boolean value. On indicates opening, and off indicates disabling. This command exists in many other HTTPd servers.
The keepalive configuration command determines whether to immediately close the TCP connection
Objective:After grunt, gulp to achieve automation, Webpack also lead the front-end packaging trends, it is well known that VUE-CLI scaffolding is based on the Webpack project packaging. While Webpack is still rising momentum, another package
ObjectiveThe content of this chapter, design more things. There will be a file system, disk, CPU and other aspects of knowledge, as well as related to the performance of the investigation and so on.TermsThe file system alleviates the impact of disk
Basic ideas
The use of MongoDB as a memory database (In-memory db), which is not allowing MongoDB to save data to disk, has aroused more and more people's interest. This usage is very useful for the following applications:
Write-intensive
With the improvement of a large number of default options, MySQL 5.6 has significantly fewer options than previous versions need to tune. In this article I will describe the configuration items that need to be optimized.
InnoDB settings
1.innodb_
As a database, in the system resources (CPU, memory, SSD, disk, etc.) certain premise, we want to:
stored data more: using compression, the world has a variety of compression algorithms;
Faster access: faster compression (write)/extract
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.