Re: Tuning MySQL for Large Database

2004-07-26 Thread Egor Egorov
"Michael Sleman" <[EMAIL PROTECTED]> 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 s

Re: Tuning MySQL for Large Database

2004-07-22 Thread Matthew McNicol
My 5 cents... tuning the MySQL database config file is half a solution. In my experience optimizing the application code and table/index structure delivers performance results. Michael Sleman wrote: Hello, We're running 1 web server (apache 2 & php) / 1 dedicated DB server (MySQL 4.0.20-standar