296 Part III . Administration Sample Configuration Files (Web server version)
296 Part III . Administration Sample Configuration Files Four sample configuration files come with MySQL. These files provide defaults based on the hardware that MySQL server will be run on. The sample configuration files can provide a good starting point for defaults. For most applications, the default settings will work just fine. Examination of the sample configuration files The sample configuration files can be found in the support-files directory of your MySQL installation. The four files range in recommended use from machines with less than 64MB RAM to machines with 1G to 2G RAM. For each of the files, I m going to examine the main server portion underneath the [mysqld]section, and also other changes that take place in the file to affect other applications such as Mysqldump and so on. The first file, for machines with less than 64MB RAM, is called my-small.cnf. MySQL AB recommends this configuration file for use where MySQL is not the primary application, and is only used now and then for minor database functions. The relevant section from my-small.cnf is shown in Figure 11-5. Figure 11-5: The [mysqld] section from the my-small.cnf example defaults file for MySQL
Looking for affordable and reliable webhost to host and run your business application? Then look no more and go to servlet web hosting services.