Channel 4 China blog: MySQL more appropriate choice for the hardware

Friday, April 25, 2008

MySQL more appropriate choice for the hardware

by:dbanotes@gmail.com(Fenng)

Author:Fenngpublished in thedbanotes.net.

MySQL lovers concerned about the2008 MySQL Conference&Expoended, many documents can see Is up. Today, read the articleScaling Out MySQL: Hardware Today and Tomorrow. Not interested in the anti-downloaddown look.

what kind of hardware do MySQL, a few words can say is not really clear. However, the talks can be concluded in or out of a few key points.

CPU choice

First, if possible onchoose 64 CPU, so as to install 64-bit operating system, with 64 operating systems to be able to make good use of more memory. If insisted Taigang, it is not 64-bit chip can also be installed 64-bit operating system, which isIntel's EM64Tof Solution (which is not mentioned in the document).

But I personally prefer the AMD 64-bit CPU, affordable, performance is not bad.

Note: MySQL in multi-core on the Bug problem.

memory, Laizhebuju

The second point is, as far as possible the allocation of more memory, of course, only if the MySQL configuration memory configuration parameters of a problem, or display, how to set up the Cache various engine parameters, enough to write a book at all.

now on the market is more and cheaper memory. I personally feel the prices of memory and CPU than many hard drives are exaggerated. Therefore, taking into account the human increasingly expensive, more and cheaper memory, to configure the server when the Bietai stingy.

hard drive - but not fast break

domestic use MySQL, the vast majority of the machines are still directly on the disk. This disk should carefully choose a little bit. As far as possible choice of 15 K and 10 K will not slow disk, the majority of database problems in the disk speed, if only on disk to spend more than 30 percent of the money will be the overall performance of 30 per cent income, it is still worth it, while the capacity in most cases The problem does not arise, now the hard drive capacity is a major.

As for the choice of what type of disk, SCSI and SAS are optional, SATA But enough cheap, specific application to consider it.

look at these three axes is simple living, but the actual application of the scenes can not be made better choices. The most simple things some people do not know is not?

- EOF -

articles | Related Articles