How to select more suitable server hardware for MySQL

Fenng of DBA notes has published an article about choosing a more suitable hardware for MySQL. I picked it and commented on it based on my usage habits. in the following section, the red font is my words.

-------------------------------------------- Split line ----------------------------------------

MySQL fans
2008 after MySQL Conference & Expo ends, many documents can be seen. I read this article today
Scaling out MYSQL: hardware today and tomorrow. Interested friends do not want to download and study it.

What kind of hardware is used for MySQL. However, some key points can be summarized in this lecture.

CPU Selection

First, if possibleSelect 64-bit CPUIn this way, the 64-bit operating system can be installed, and a 64-bit operating system can make good use of larger memory. If you want to raise the bar, you can install a 64-bit operating system, that is, either a 64-bit chip or a 64-bit operating system.

Intel's em64t solution (which is not mentioned in this document ).

I personally prefer amd 64-bit CPU, Which is inexpensive and has good performance.

Note: MySQL has bugs on multiple cores.

(1. currently, the configured servers are basically 64-bit CPUs. for stability and system compatibility considerations, many administrators prefer to install a 32-bit operating system. I launched a 53xx quad-core Xeon CPU server in the previous section and installed the 64-bit Linux operating system [Ubuntu
Server 8.0.4] after testing, there seems to be no stability or software compatibility issues when running the web service.

2. number of CPUs, of course, the best two or four. however, if the pressure is not very high, I think a CPU is enough. save money to replace the hard disk and increase the memory, the effect will be more obvious)

Memory.

The second point is to configure as much memory as possible. Of course, only large memory is configured. If there is a problem with MySQL parameter configuration, you should also set the cache-related parameters for each engine, enough to write a book.

The memory on the market is getting cheaper and cheaper. I personally feel that the memory price is much more exaggerated than the CPU and hard disk prices. Therefore, considering that the manpower is getting more expensive and the memory is getting cheaper, you should not be too stingy when configuring servers.

(1. this is almost a consensus. I personally recommend 4 GB memory or above. in terms of parameter configuration and cache settings, I think the first is to test performance by yourself. adjust the parameters as needed. second, read the official manual carefully. The majority of the Manual is basically the truth .)

Hard Disk-fast

MySQL is used in China, and most of them are still directly on the local disk. The disk should be carefully selected. Try to select a 15 K disk instead of a 10 k slow disk. Most database disk problems are caused by speed. If you only spend 30% more money on the disk, you will get 30% of the overall performance, it is worth it, and the capacity will not be faulty in most cases. The current hard disk capacity is a large one.

Either SCSI or SAS is available for any type of disks. Sata is cheap enough. Consider the specific applications.

These three axes are simple, but in actual application scenarios, you may not be able to make better choices. Some of the simplest things do not know, do they?