Chapter 11 . Server Configurations 291 Although the (Web file server)
Chapter 11 . Server Configurations 291 Although the SHOW VARIABLES output given here does contain even more variables, these are beyond the scope of this chapter. So many variables, so little time As you can see from Table 11-1 and the variable printout, I speak the truth about the large number of server variables and settings available for an administrator to work with. When you add capabilities such as replication, even more variables and settings must be considered. At this point you may be asking, Which variables and settings do I really have to change and which ones can be left at the defaults? I certainly can t preach that all variables must be set for each server; in my view, that s neither true nor practical. Responding to testing and feedback from users of MySQL, MySQL AB has set defaults for most variables that will work well. Another reason not to set all the variables is that the MySQL server itself is quite efficient for most uses of the database anywhere from just a few records to a few hundred thousand or more. I ve worked with large databases (millions of rows) on what I would consider normal hardware Pentium-class computers with 128MB RAM and noticed no performance problems that would make me want to change too many server variables. However, working with specific applications or databases may require that you set or change variables to improve performance of the MySQL server. Some reasons you may have to set variables include the following: . A specific application performs operations on the database slow or cause the server to lag. . The use of lower-end hardware or small amounts of resources. . Using MySQL on a server that runs many other applications and services. . Inefficient or poorly written applications that cause problems for the server or database. . A desire to improve your server s performance. Coming back to the original question in this section, how do you know which variables to set if you want optimal performance from MySQL? Luckily, MySQL AB has done some of the homework for many implementations; two features of its installation program can help you optimize MySQL: . A suite of applications helps you benchmark your server s performance. MySQL also includes another set of tests known as the Crash-me tests. Together with the MySQL Benchmark applications, the Crash-me tests help you give your server a vigorous test. These applications and scripts help determine and test the limits of your server by simulating real-world scenarios. The benchmarking applications are a series of tests contained in the sqlbench directory within your MySQL installation. The Crash-me tests are
Looking for affordable and reliable webhost to host and run your business application? Then look no more and go to servlet web hosting services.