Re: Sever crash due a long semaphore wait
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
Subject
Views
Written By
Posted
2747
July 22, 2008 02:13AM
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.