Binary Log files rotation problem

[Brian Robinson]

Hi 

 

A long shot - but I wonder if any have experiences similar to us.

 

Every 2nd day or so our MySQL server hangs - and we have narrowed this
down to the moment when the binary log files rotate.

 

Other than that our experiences having migrated from SQL Server to MySQL
are VERY positive.

 

Environment

MySQL 5.0.19  

SuSE 10.0

We use the InnoDB database engine

We have about 6o tables some of which are "medium" sized tables (about
65 million rows)

 

We have many transactions per second on some of the tables (including
the medium size tables)

 

I have added an entry to the forums for this (and also raised a bug)
unfortunately we have had no answer yet -

 

We cannot reproduce the problem at will but we are sure that each time
it occurs the log file is about to switch over.

 

I realize this is a long shot but we are getting a bit desperate to
solve this problem now - so any help/pointers would be appreciated.

 

I can't imagine this is a general problem otherwise I assume there would
be more entries on the forums and bugs - but I am wondering if it is
related to the size of our binary log files/memory and the InnoDB
buffers we have.

 

Cheers

Brian

 

 

 

 

 

 

Brian Robinson 
Senior Engineer

SoonR username: brian

Skype name: brobinsondk

+45.6177.4990 (mobile)

____________________________

PC Power delivered to your phone

 

SoonR 

www.soonr.com <http://www.soonr.com/> 

 

This email and any attachments thereto may contain private,
confidential, and privileged material for the sole use of the intended
recipient. Any review, copying, or distribution of this email (or any
attachments thereto) by others is strictly prohibited. If you are not
the intended recipient, please contact the sender immediately and
permanently delete the original and any copies of this email and any
attachments thereto.