to disk I/O constraints, MySQL performance will be very low! To solve this problem, consider the following solutions: Use a RAID 1 + 0 disk array. Do not try RAID-5, the efficiency of MySQL on the RAID-5 disk array is not as fast as you expected.
② For MySQL applications, we recommend that you use DELL R710, E5620 @ 2.40 GHz (4 core) * 2. I like DELL R710 now and use it as a akg virtualization application;
③ For a Database Server using MySQL, we reco
speed.The hardware environment is as follows:
CPU: INTER Nehalem E5620 2.4GHZx2
Memory: PC-8500 4 GB * 8
Hard Disk: 300G 10 k * 2, RAID: 1
Flash: SSD 160GB_MLC X25-M G2 x 6
NIC: Gigabit
Data volume: 117 GBTest procedure description:
The test is divided into two sets of programs:
A. Storage Test
A) the storage test program uses pread/pwrite for storage testing. The speed of the blockchain traversal is based on the block chain library developed by Fr.
Environment Description:A friend company performs a database migration. Due to setup problems, all database table storage engines are set to MyISAM, based on business needs,Some database tables must be: InnoDB; otherwise, transaction execution may fail and will not be effective. Therefore, change the database table storage engine from MyISAM to InnoDB,There are more than 300 tables in the database, of which nearly 1/3 need to be modified to InnoDB, and the rest will continue to use the MyISAM en
reverse order ), and the performance of 10 records is returned after the Skip100 records. The impact of Skip and Order on the performance is measured.
7) query the performance of 100 records (that is, KB) is not sorted and there are no conditions). This test is the impact of query results of large data volumes on the performance.
8) count the total disk usage, index disk usage, and data disk usage as the test progresses.
In addition, each test uses a single-process Mongodb instance and the same
on the market is competent. The server mainly considers stability. Although a general PC can be competent in terms of performance, it is recommended to purchase professional server hardware considering the need for long-term uninterrupted operation.
For the convenience of users, we provide two configuration references:
A. General Software Configuration:
CPU (Intel E5606 @ 2.1 GHZ) memory 2 GB) Nic 320 m Nic) Hard Disk GB)
B. Recommended hardware configuration
CPU (Intel
Due to some work needs, ROM development on the Android platform is required. during the development process, the official documentation is very simple and there are many problems. Therefore, we need to organize the complete personal development process, share it with you. please correct me if you have any questions.To compile a custom Android ROM, the first step is to build a reasonable hardware and software development environment. I. hardware development environment: 16 GB memory or above, hig
), and the performance of the 10 records is returned after the Skip100 record.This is the effect of skip and order on performance7) query 100 records (that is, 100KB) performance (no sorting, no conditions), this is measured by the large data volume of the query results on the performance of the impact8) Statistics as the test progresses, total disk usage, index disk usage, and number of data disks occupiedAnd each test uses a single process of MongoDB and the same server to open three MongoDB p
is required.
Data WarehouseOLAP/Data mining
Large commercial data storage, cataloguing, indexing, and data analysis. For example, OLAP (online transaction processing), high-speed commercial computing, requires good IO performance.
Basic applications and web Services
E-commerce ECommerce
The function is the same as that of a typical application server. The performance depends on the number of commercial applications and users, and may require a certain amount
can perform the same patch update. Intel chip products include 6-8 generations of core processors, X Series processors, and Xeon Scalable and Xeon D chips.
Supported list
Firmware updates released by Intel support the following chip products:
Anniedale/Moorefield, Apollo Lake, Avoton/Rangeley, Broxton, Cherry View, Coffee Lake, Cougar Mountain, Denverton, Gemini Lake, Kaby Lake, Knights Landing, Knights Mi
1.Vista's kernel version number is: Windows 6.0;The Windows 7 kernel is: Windows 6.1;The Windows 8 kernel is: Windows 6.2Win7 compatible with all Vista-enabled programs, WIN8 is compatible with all Win7 programs, because they are based on the same underlying core.So Vista, Win7, win8 differ little, the main difference is only the small change in the UI interface.2.Xeon (Intel Xeon series)Baidu Encyclopedia
Translator: ye Jinrong (Email :), source: imysql.cn 1. preface recently, we have optimized the discuz Forum (dz for short) as needed. Of course, it only involves database optimization. let's talk about the data volume of the server and dz, 2 * Intel (R) Xeon (TM) CPU2.40GHz, 4 GBmem, SCISC hard drive. mySQL version 4.0.23. quantity
Ye Jinrong, source: http://imysql.cn 1. preface recently, we have optimized the discuz Forum (dz for short) as needed. Of
latest CPUs support dual-core or hyper-threading. Even if you are using a single CPU, it is hard to ensure that you upgrade it one day :).
??
?? 3) Processor type and features --> Processor family
?? This is a single-choice entry to specify a specific CPU model for optimization. You should select it with caution. If you select an incorrect option, the kernel may not work properly. For example, if you select Athlon/Duron/K7, the kernel uses 3 DNow when performing memcpy! Version with optimized i
entry-level server system to up to 32-way mainframe systems. In terms of structure, it can be either a rack or a cabinet. Its Unix product line has unique advantages in scalability. Currently, the mainstream pseries products are p630 and p650 models.
X Series: This is an Intel-Based Server series of IBM. This product line of IBM is very rich, including all levels of server products from entry level to enterprise level. In terms of server structure, there are both traditional tower and new rack
websites will no longer have functional redundancy.
This significantly improves service availability.
Symbiosis disadvantages:
This increases the workload for system administrators. Since services all use independent infrastructure, this will bring more attention to administrators.
It is difficult to maintain backward compatibility. After one year of maintenance, the API method has undergone countless changes. So when the problem occurs, they will inevitably undermine backward compatibility,
A simple program to test the single-core processing capability of the database server. The author claims to have tested hundreds of different U types, the fastest being the IntelXeonX56803.33GHzsix running on linux-
A simple program to test the single-core processing capability of database servers, the author claims to have tested hundreds of different U, the fastest running Intel Xeon X5680 3.33 GHz six-on linux-
The storage process from Julian Dy
), and there is an I/O APIC to handle interrupts caused by I/O devices, the I/O APIC is installed on the motherboard, but the APIC on each CPU is indispensable, Otherwise, you will not be able to handle interrupt coordination between multiple CPUs.2, the same product model, the same type of CPU core. For example, while both Xeon and Opteron have built-in APIC units, it is impossible to make them work together to build an SMP system, and even if the CP
can we choose a server product suitable for enterprise development? First, it is necessary to master some server knowledge.
As we all know, in enterprise operations, servers usually perform data storage, applications, and other tasks. different services have different requirements for server configuration. For example, generally, database servers have high requirements on server hard disk capacity, WEB application servers have high requirements on processors and memory, and game servers have hi
contrast, PCI and PCI-X can only be sent or received at a specific point in time, and a sending process must wait until the receiving process ends, resulting in latency. This delay will not occur when PCIe is used.
Support for intel? I/O acceleration technology makes network data transmission more effectiveIntel? I/O acceleration is an upgraded platform technology that solves multiple problems that cause server I/O bottlenecks and does not need to change existing or future applications.Progra
three websites are used to upgrade the operating system of the original server. Hardware details MySQL Server: dualxeon 5335/8 GB memory/73 gb sas hard drive (raid0 + 1)/centos5.1-x86_64/mysql5 The three web servers are as follows: N1. dual Xeon 3.0 2 GB memory N1. dual Xeon 3.0 4 GB memory N1. dual Xeon 3.0 (dual-core) 4G memory In addition, three gb scs
shows Lenovo's newest 10-Gigabit T200 2100 workgroup server. It uses a dual Intel Xeon 533mhz processor and the latest SATA technology in a PC; the right figure shows HP's ProLiant ml350g3 workgroup server, which can use 1-2 intel GHZ-kb Xeon server dedicated CPUs and support hyper-Threading Technology.
3. Department-level servers
This type of server is a mid-range server. Generally, it supports a dual
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.