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
2524
November 29, 2005 02:40PM
3108
November 29, 2005 06:51PM
1625
November 29, 2005 08:24PM
1571
November 29, 2005 08:31PM
1672
November 29, 2005 09:36PM
1460
November 30, 2005 02:36AM
1576
November 29, 2005 09:42PM
Re: PLEASE HELP - performance is horrible!
1761
November 30, 2005 09:48PM
1705
December 05, 2005 07:13AM
1670
December 08, 2005 06:59AM
1629
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.