From IT Mission Linux Tips, Hacks, Tutorials, Howtos - Itmission.org

Main: HowToTuneMysqldServerParameters

  [mysqld]
  skip-external-locking
  max_connections=200
  read_buffer_size=1M
  sort_buffer_size=1M
  #
  # Set key_buffer to 5 - 50% of your RAM depending on how much
  # you use MyISAM tables, but keep key_buffer_size + InnoDB
  # buffer pool size < 80% of your RAM
  key_buffer_size=value

The following examples indicate some typical variable values for different runtime configurations.

      shell> mysqld_safe --key_buffer_size=64M --table_cache=256 --sort_buffer_size=4M --read_buffer_size=1M &
      shell> mysqld_safe --key_buffer_size=16M --sort_buffer_size=1M

If there are very many simultaneous connections, swapping problems may occur unless mysqld has been configured to use very little memory for each connection. mysqld performs better if you have enough memory for all connections.

      shell> mysqld_safe --key_buffer_size=512K --sort_buffer_size=100K --read_buffer_size=100K &

Reference : http://dev.mysql.com/doc/refman/5.0/en/server-parameters.html

Retrieved from http://www.itmission.org/Main/HowToTuneMysqldServerParameters
Page last modified on July 10, 2007, at 03:19 AM