Chapter 11 . (Photoshop web design) Server Configurations 297 The second
Chapter 11 . Server Configurations 297 The second file, my-medium.cnf, is for machines with smaller amounts of memory (under 128MB). If MySQL is the sole application (or one of a few primary applications) running on a machine like this, then the medium configuration file may be for you. In addition, if you have 128MB to 256MB and MySQL will be working with other applications (such as Apache or other services), the medium configuration would be a good starting point for a configuration file. The example section of the configuration file for [mysqld]is shown in Figure 11-6. The third configuration file, my-large.cnf, is meant for systems that have more than 512MB RAM, though less than 1GB RAM. The server is mainly responsible for database tasks with MySQL therefore it isn t running many other services. Of course, running a Web server for an interface would probably be acceptable. However, a production Web server for public use would be better run on a separate server. Figure 11-6: The [mysqld] section from the my-medium.cnf example defaults file for MySQL The [mysqld] section for my-large.cnf is shown in Figure 11-7. Finally, the example configuration file for the largest configurations is myhuge. cnf. This file is meant as an example file for systems with 1GB RAM or more, where MySQL is the sole application or service running on the server. If you intend to run any other applications or services, you should run them servers other than the MySQL server and you can use this example file as a good starting point. If you are running a MySQL server in such an environment, you will probably have to set other variables specifically to match your application.
Please visit our professional web hosting services to find out about cheap and reliable webhost service that will surely answer all your demands.