MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:July 26 2004 3:50pm
Subject:Re: Tuning MySQL for Large Database
View as plain text  
"Michael Sleman" <michael@stripped> wrote:


> key_buffer = 384M

Try to enlarge this up to, say, 1G and check it out how that helps. 

> sort_buffer_size = 2M

You may want to enlarge this as well. 





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com



Thread
Tuning MySQL for Large DatabaseMichael Sleman21 Jul
  • Re: Tuning MySQL for Large DatabaseMatthew McNicol22 Jul
  • Re: Tuning MySQL for Large DatabaseEgor Egorov26 Jul