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
2521
November 29, 2005 02:40PM
3098
November 29, 2005 06:51PM
1624
November 29, 2005 08:24PM
1568
November 29, 2005 08:31PM
1670
November 29, 2005 09:36PM
1456
November 30, 2005 02:36AM
1575
November 29, 2005 09:42PM
Re: PLEASE HELP - performance is horrible!
1758
November 30, 2005 09:48PM
1705
December 05, 2005 07:13AM
1669
December 08, 2005 06:59AM
1627
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.