MySQL Forums
Forum List  »  Install & Repo

Re: High CPU usage
Posted by: murtuja khokhar
Date: April 04, 2008 07:44AM

Hi,

You have just 2GB RAM and you have alloacated most of the RAM to mysql.You need to allocate maximum 70% of RAM only.Windows server also need RAM for it's execution.

You have to adjust (decrease) your bellow listed parameters

myisam_sort_buffer_size=369M
tmp_table_size=185M
query_cache_size=1024M
key_buffer_size=285M
innodb_buffer_pool_size=553M

Options: ReplyQuote


Subject
Written By
Posted
April 04, 2008 01:39AM
Re: High CPU usage
April 04, 2008 07:44AM
April 05, 2008 05:48PM


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.