and write disk can be imagined. Therefore, the disk I/O is generally considered to be one of the biggest constraints on MySQL performance, for the average daily access to more than 1 million PV discuz! forum, due to disk I/O constraints, MySQL performance will be very low! To address this constraint, consider the following solutions: Using the raid-0+1 disk array, it is important not to try to use Raid-5,mysql on the RAID-5 disk array as quickly as you might expect.②CPU for MySQL applications,
constraint, consider the following solutions: Using the raid-0+1 disk array, it is important not to try to use Raid-5,mysql on the RAID-5 disk array as quickly as you might expect.②CPU for MySQL applications, it is recommended to use S.M.P. Architecture's multi-symmetric CPU, for example: two Intel Xeon 3.6GHz CPUs can be used, now I would rather recommend 4U servers dedicated to database server, not just for MySQL.③ physical memory for a database se
front-End cache cache provides performance assurancemenmcached, Redis Database CacheMIGLEFD Distributed File System (becomes a server by multiple machine groups) NTFS fatFastdfsDNS name ResolutionAnsible puppet operation and maintenance automation* Avoid a single point of failure: a point of failure global failure Server classification by Form factor Tower Server (size not standard) currently less usedRack-Mount ServersRack height of about 2m (42U), Width 19 inches (48.26cm) height in units o
Background environment:Two servers, configure 4u (per U6 core), 48G memory, install a good system;Problem:SQL Server clusters cannot be installed properly, and the cluster does not support 24-core CPUs.Workaround:After the CPU is changed to 8 cores, it can be successfully installed and then upgraded to the SP3 patch to support 24 cores.Reference:http://903706.blog.51cto.com/893706/406110This article comes from the "Ricky's blog" blog, please be sure t
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.