MySQL Forums
Forum List  »  Performance

Re: MySQl crashes several times per day with a table > 300 Mb
Posted by: Peter Zaitsev
Date: December 31, 2004 07:02PM

As James Day mentioned MySQL server crash is likely due to running out of memory with a lot of threads you may decrease buffers to get away from this effect or set max_connections to the value server can happen.

The real problem however is why do you have this problem. What is "refresh" you're speaking about ?

Beware MyISAM uses table level locks so update statement will lock all concurrent selects, Also long running select followed by concurrent update will
lock all table accesses by default.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQl crashes several times per day with a table > 300 Mb
1957
December 31, 2004 07:02PM


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.