MySQL Forums
Forum List  »  InnoDB

Re: Sever crash due a long semaphore wait
Posted by: Nanda kishore Toomula
Date: July 28, 2008 06:36AM

Hi sujitha,

increasing innodb_buffer_pool_size can be up to 80-90% of your physical RAM
but this highly depends on number of simultaneous connections your mysql server engage at an average,
this influences other engines performance too
regarding semaphore based on your observation
you can tweak with

innodb_lock_wait_timeout
innodb_flush_log_at_trx_commit
innodb_rollback_on_timeout
interactive_timeout
and
wait_timeout


Regards

Nanda kishore Toomula
Sr DBA,Nokia india
Certified MySQL Database Administrator

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Sever crash due a long semaphore wait
1702
July 28, 2008 06:36AM


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.