Tuning MySQL

 1. To know current default values for mysqld give               $ mysqld –verbose –help 2. While Tuning MySQL, 2 values are most important      a. key_buffer_size  –> key_buffer_size is the size of the buffer used for index blocks. The key buffer is also known as the key cache.The maximum permissible setting for…