MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
PLEASE HELP - performance is horrible!
2823
mike
November 29, 2005 02:40PM
Re: PLEASE HELP - performance is horrible!
3338
Jay Pipes
November 29, 2005 06:51PM
Re: PLEASE HELP - performance is horrible!
1779
mike
November 29, 2005 08:24PM
Re: PLEASE HELP - performance is horrible!
1724
mike
November 29, 2005 08:31PM
Re: PLEASE HELP - performance is horrible!
1839
Jay Pipes
November 29, 2005 09:36PM
Re: PLEASE HELP - performance is horrible!
1660
mike
November 30, 2005 02:36AM
Re: PLEASE HELP - performance is horrible!
1736
Jay Pipes
November 29, 2005 09:42PM
Re: PLEASE HELP - performance is horrible!
1933
mike
November 30, 2005 09:48PM
Re: PLEASE HELP - performance is horrible!
1898
Jay Pipes
December 05, 2005 07:13AM
Re: PLEASE HELP - performance is horrible!
1829
mike
December 08, 2005 06:59AM
Re: PLEASE HELP - performance is horrible!
1799
mike
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.