Mysql Database Performance tuning

Mysql provides a configuration file located in /etc/my.cnf. From here you can set all of the memory, table, and connection limits as well as a host of other options.
You can get the default buffer sizes used by the mysqld server with this command:

shell> mysqld –help

This command produces a list of all mysqld options and configurable variables. The output includes the default values and looks something like this: