298 Part III . Administration Figure 11-7: The
298 Part III . Administration Figure 11-7: The [mysqld] section from the my-large.cnf example configuration file for MySQL. The [mysqld] section from the example configuration file is shown in Figure 11-8. Notice how the configuration file examples differ from each other. In the example configuration file for Hugedatabase servers, the buffer sizes take advantage of the large amounts of RAM memory available for use. The configuration-file example for Small servers uses much less RAM for buffers and other parameters. Developing your own configuration file The first recommendation I have is to use an example file that closely matches your configuration not only of your machine, but also of your planned application(s). For example, I use the my-small.cnf file for the example server that I m using a Pentium 200MMX with 96MB RAM. After starting the database server, monitor the variables and performance through the use of the mysqladmin extended-status command. Of course, your users will tell you if the database is performing slowly.
From our experience, we can recommend PHP Web Hosting services, if you need affordable webhost to host and run your web application.