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