tailieunhanh - Hướng dẫn sử dụng MySQL part 6

Giới thiệu Hiệu suất điều chỉnh là một phần quan trọng trong nỗ lực phát triển đáng kể. Nhìn chung, MySQL được thiết kế với tốc độ trong tâm trí. Tuy nhiên, có một số yếu tố có thể tác động ứng dụng và / hoặc hiệu suất cơ sở dữ liệu. Trọng tâm của chương này sẽ giới thiệu bạn với một số các nguyên tắc điều chỉnh hiệu năng và một số công cụ bạn có theo ý của bạn. | DRAFT 8 24 01 6 Performance Tuning Introduction Performance tuning is an important part of every significant development effort. In general MySQL is designed with speed in mind. However there are a number of factors that can impact application and or database performance. The focus of this chapter will be to introduce you to some of the principles of performance tuning and some of the tools you have at your disposal. Performance Tuning Methodology When performance tuning a MySQL application there are four main areas that you consider the application the database server the operating system and the hardware. These should be ranked in terms of bang for the buck. For example adding memory or upgrading your processor will usually improve the performance of your application s but you should be able to get greater gains for less cost if you tune your application code and database server first. In addition any performance tuning on the MySQL server will apply to all applications using that server. Characteristics that are advantageous for one particular application may not improve that performance of another. Based on these factors as a general methodology we recommend that you look at application tuning issues in the following order 1. SQL Query tuning 2. Database server tuning 3. Operating system Copyright 2001 O Reilly Associates Inc. 1 DRAFT 8 24 01 4. Hardware Detailed coverage of operating system and hardware tuning are beyond the scope of this book. That is not to say that these are unimportant parts of the performance equation. However the wide variety of Oses and hardware types make it impractical to cover these topics in adequate detail. Application Performance Tuning There are really two parts to applicaton performance tuning host application tuning . C C Java Perl etc. and SQL query tuning. First we will look at host application considerations. Good application design and programming practices are crucial to getting good performance from you MySQL .