Figure 8 6   The Task Center console

8.6  Database configuration

Database configuration is an another very important task for database 

administrators. It involves setting up parameters for database, system, database 

manager, etc. to optimum values for getting the best performance for your 

application. In this section we discuss how MySQL and DB2 UDB database 

parameters are tuned.

8.6.1  MySQL configuration

MySQL database configuration involves setting up system level parameters, 

server parameters, and database parameters. You can use database 

parameters to define various characteristics of a database. When you install the 

MySQL, a default configuration is stored; either this configuration can be used or 

it can be modified to suit any specific requirements you may have.

 Chapter 8. Database administration 

249