List:General Discussion« Previous MessageNext Message »
From:Gleb Paharenko Date:March 31 2005 1:52am
Subject:Re: Changed Logging Table from InnoDB to MyIsam, what memory buffers to tune?
View as plain text  
Hello.

SHOW STATUS usually helps others to give you a good advice. I think
you should send the output of this statement to the list. Why have you
changed the type of engine? Did it gave you a great performance hit?




"Thomas Lekai" <Thomas.Lekai@stripped> wrote:
> We finally split our huge logging aspect of an application to its own =
> system, and we changed the table type from InnoDB to MyIsam.  This is a =
> logging table, 1 log writer, many, many selects from customer care reps =
> looking up the last 500 or so records.  These are logs of timed events, =
> so they always need to see the most recent 500 records.
> 
> The memory buffers that are set for now are as follows:
> 
> ### OPERATIONAL SETTINGS
> key_buffer_size=3D416M
> myisam_sort_buffer_size=3D128M
> join_buffer_size=3D128M
> read_buffer_size=3D16M
> sort_buffer=3D256M
> read_rnd_buffer_size=3D32M
> query_cache_size=3D32M
> 
> The box has 4 GB, it is Linux, so I am thinking I can use up to 3 GB.  I =
> did not size these initial settings but the more I see on what others =
> use, I learn of all kinds of buffers I never thought of using before.  I =
> understand that some of these buffers will degrade performance if too =
> large, while others can grow to the sky, and only improve performance.
> 
> I would appreciate some additional input on these settings, and advice =
> how I could optimize these even further to obtain as much through-put as =
> possible from the system.  Are there any other buffers I could set?  The =
> majority of all action are inserts from the log writer, and selects from =
> customer care reps.
> 
> One other thing, what can be optimized if the log writer is split into =
> multiple threads, and many insert processes are happening at once?
> 
> Regards,
> 
> Thomas A. Lekai
> Vonage Holdings
> thomas.lekai@stripped <mailto:thomas.lekai@stripped>
> 
> 


-- 
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
Changed Logging Table from InnoDB to MyIsam, what memory buffers to tune?Thomas Lekai30 Mar
  • Re: Changed Logging Table from InnoDB to MyIsam, what memory buffers to tune?Gleb Paharenko31 Mar