MySQL Forums
Forum List  »  Performance

Re: PLEASE HELP - performance is horrible!
Posted by: mike
Date: November 30, 2005 09:48PM

someone suggested this somewhere else:

increase your key_buffer size, try 384M.
increase your table_cache, try 256.
your sort_buffer_size is too large and taken up memory, try 4M.
set query_cache_size to 16M or 32M.
set thread_concurrency to 4.

do these sound like good tweaks?

please reply to my thread about mysql usage - i'd like to collect some data! thanks!
http://forums.mysql.com/read.php?11,57080

Options: ReplyQuote


Subject
Views
Written By
Posted
2623
November 29, 2005 02:40PM
3219
November 29, 2005 06:51PM
1678
November 29, 2005 08:24PM
1624
November 29, 2005 08:31PM
1730
November 29, 2005 09:36PM
1525
November 30, 2005 02:36AM
1629
November 29, 2005 09:42PM
Re: PLEASE HELP - performance is horrible!
1818
November 30, 2005 09:48PM
1770
December 05, 2005 07:13AM
1725
December 08, 2005 06:59AM
1687
December 08, 2005 07:15AM


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.