Shulou(Shulou.com)05/31 Report--

How to analyze the MySQL database disk IAccord O adjustment and optimization, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain in detail for you, people with this need can come to learn, I hope you can gain something.

At present, most of the applications of web are mainly based on Imax O-intensive, and the development of storage technology is not as rapid as that of other systems in computers. Although there are many high-end storage devices, the price is too expensive for the public to afford. Based on the current situation, it is more likely that we use general SAS disks combined with applications to use different RAID combinations to achieve our civilian storage. In order to get better performance, then the adjustment and optimization related to Imax O is essential. For our database tuning, disk Ipicuro optimization is the most important tuning focus, we all know the barrel principle, the absolute overall quality of the short board, and this deficiency in the database system is caused by the weakest disk in the hardware equipment we use. Most of the time, we will find that the CPU in the system is tired to death, while the CPU is waiting idle, mainly because the response time of the execution is too long, and the processing speed of reading and writing lags far behind the processing speed of the CPU. At this time, we will try our best to put the operation into memory, from the relationship between disk and CPU to the relationship between memory and CPU. However, we can not avoid the weakness of disk Iripo, and optimization is necessary.

We can have a lot of ideas about the characteristics of database in daily application.

1. The load of random read and write can be expanded by increasing the number of hard drives.

two。 The pressure of sequential reading and writing can be solved by selecting disks with relatively higher bandwidth.

3. RAID 5 and RAID 10 are both good principles for database applications.

4. Of course, based on the criticality and cost of their own business, Fusion-io card (excellent read and write performance) and SSD (excellent random read) are both ideal choices.

5. In the operating system, it is advantageous for database applications to choose deadline as the scheduling mode of Imax O Scheduler. Command: echo deadline > / sys/block//queue/scheduler

6. The nr_requests parameter in the operating system can improve the throughput of the system. It seems that the bigger the better, but the request queue should not be too large, because it will consume a lot of memory space. The adjustment of this value needs to combine a number of factors, such as: file system, sheduler type, io characteristics. Command: the size of echo xxx > / sys/block//queue/nr_requests,nr_requests is at least twice the size of / sys/block//device / queue_depth, so be careful when modifying nr_requtests.

7. There is also a pre-read parameter read_ahead_kb under the system directory / sys/block//queue. The increase of this parameter will only improve the sequential read operation, while most applications such as databases are random read. The effect of modified pre-reading can be tested by using the command hdparm-t / dev/sda {,}.

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.