Re: MyISAM - Large Memory Footprint
Posted by:
DBA Lead
Date: September 07, 2010 11:12AM
W/o looking at the schema its kinda difficult to suggest anything
Set key_buffer_size=4G
Setting slave skip errors to all is quite dangerous, your tables can be out-of-sync bigtime.
Disable general query log if you don't really need hit.
You can remove table_cache=1200 and thread_concurrency lines ...
is your OS version 32-bit or 64-bit?
--------------------------------------------------------------------
Geeks Worldwide --
http://www.geeksww.com/keywords/tutorials/mysql/
Subject
Views
Written By
Posted
5365
July 30, 2010 06:17PM
2515
July 31, 2010 11:54PM
2414
September 06, 2010 03:09PM
2227
September 07, 2010 10:53AM
2137
September 07, 2010 08:34PM
Re: MyISAM - Large Memory Footprint
2009
September 07, 2010 11:12AM
2163
September 07, 2010 01:20PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.