recently re-spread on the database, the company's core database every day IO full, in the study with SAS 16*RAID10, or RAID10 ssd*6, or FIO;the principle, no raid-5 for database; eh; the root of all evil ;No.2 principle, most of the time, the database does not need too high CPU, now 2 sockets are basically enough, more MySQL is not used;No.3 principle, large memory, high IO, is the necessary condition of mo
low, but the speed is slow. Each MLC unit is 2bit, a whole lot more than the SLC. However, due to the large number of data stored in each MLC storage unit, the structure is relatively complex, the probability of error will increase and must be corrected, this action causes its performance significantly lag behind the structure of the simple SLC flash memory. In addition, the advantage of SLC flash memory is up to 100,000 times, 10 times times higher than MLC Flash. In addition, in order to ensu
compatibility with Sata hard disks. SAS interface technology is backward compatible with Sata.
In terms of interface standards, Sata is a sub-standard of SAS. Therefore, SAS controllers can directly control SATA hard disks, but SAS cannot be directly used in Sata environments, because the SATA controller cannot cont
Tags: SAS XFS SSDAn OLTP performance comparison test was previously done: SAS vs SSD various modes MySQL TPCC OLTP comparison test results, this time to do the OLAP comparison test.The comparison test results are shown below:650) this.width=650; "Src=" http://dp.imysql.com:8080/files/upload_yejr_imysql/SAS_VS_SSD_MySQL_OLAP_benchmarking _20121225.jpg "style=" bor
http://blog.csdn.net/killmice/article/details/42745937
The test tool FIO is read sequentially as an example, with the following commands: fio-name IOPS-RW = Read-bs = 4k-runtime = 60-iodepth 32-filename/dev/sda6-ioengin E Libaio-direct = 1 where rw = read for random reads, BS = 4k for each read 4k, filename specifies the corresponding partition, here I am/dev/sda6, direct = 1 means the cache through Linux Test SATA Hard Drive, SAS hard drive,
pre-conditions:1. InstallationLSI's megacli package Megacli642. query tool for installing SCSI devices LSSCSI Apt-get Install LSSCSIsteps:1. Find the drive letter according to OsdidCeph-disk List |Grep-a 1-b 1 osd.0 | Egrep "^/dev/sd*\b" |cut-d ': '-f1 2. Find the device based on the drive letterTarget IDLsscsi | grep/dev/sdd | awk ' {print $} ' | cut-d ': '-f33. Determine if the disk is a SAS disk perform the following command to return 2./megacli-ld
Reference: http://blog.csdn.net/tianlesoftware/article/details/6009110The main types of hard disk interfaces currently available are IDE, SATA, SCSI, SAS, FC, and so on.The IDE is commonly known as the port, SATA is commonly known as the serial port, both of the hard disk is the PC and low-end server common hard disk.SCSI is the abbreviation for "Small computer system dedicated interface", which is the hard disk with this interface.SAS is the SCSI int
In March of this year, we introduced SSD-based Elastic Block-level storage for Amazon EC2 instances. After a few months of release, this new method of choice, known as general-purpose storage (SSD), has accounted for 90% of the newly created EBS volumes, we learned from customers' feedback that they like this consistent performance very much (pre-configured stora
In a variety of test mix scenarios, the combination of 10 (combination 10:SSD * 2, RAID 0, Xfs,wb,nobarrier,noop) has the highest overall performance, so it is the benchmark, and the comparison of other schemes, the following table is the comparison of the combinations and combinations 10:650) this.width=650; "Src=" http://dp.imysql.com:8080/files/upload_yejr_imysql/SAS_VS_SSD_MySQL_OLTP%E5%AF%B9%E6% Af%94%e6%b5%8b%e8%af%95%e8%a1%a8-20120907.png "styl
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.