MySQL Forums
Forum List  »  Optimizer & Parser

Re: A popular forum not able to take load.. my.cnf optimization needed
Posted by: Adrian Chapela Cordeiro
Date: August 29, 2007 04:50AM

If you use innodb you can try to up the memory values:

# Set buffer pool size to 50-80% of your computer's memory,
# but make sure on Linux x86 total memory usage is < 2GB
innodb_buffer_pool_size=1200M
innodb_additional_mem_pool_size=200M
innodb_log_files_in_group=2
#
# Set the log file size to about 25% of the buffer pool size
innodb_log_file_size=300M
innodb_log_buffer_size=8M

But the problem could be at invision board.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: A popular forum not able to take load.. my.cnf optimization needed
2770
August 29, 2007 04:50AM


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.