List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:August 29 2005 8:40am
Subject:Re: Key Buffer Size
View as plain text  
Hello.

> =09To give you an idea of my database, I use Linux box with 6GB ram,
> MySQL version 4.0.15. Most of my configuration is in lines with
> my-huge.cnf.

Your version of MySQL is rather old, I strongly recommend you to upgrade
to the latest release (4.1.14 now). If your server has x86 architecture,
your mysqld process might not be able to use all 6G of your RAM.


> Greetings,
> =09In my database, all the tables use innodb engine. Since I don't use
> MYISAM, Is it safe to make the key_buffer size to 8 MB?

In my opinion, it is safe.



Manoj <manojsw@stripped> wrote:
> Greetings,
> =09In my database, all the tables use innodb engine. Since I don't use
> MYISAM, Is it safe to make the key_buffer size to 8 MB?
> 
> =09To give you an idea of my database, I use Linux box with 6GB ram,
> MySQL version 4.0.15. Most of my configuration is in lines with
> my-huge.cnf.
> 
>              Thanks in advance for your help.
> 
> Cheers
> 
> Manoj
> 


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



Thread
Key Buffer SizeManoj29 Aug
  • Re: Key Buffer SizeAlexey Polyakov29 Aug
  • Re: Key Buffer SizeGleb Paharenko29 Aug