MySQL Forums
Forum List  »  MyISAM

Re: Problem: INSERT DELAYED works like normal INSERT
Posted by: Rick James
Date: March 31, 2012 12:59PM

What value do you have for key_buffer_size? If it is the default, that is much too small for efficient use. Change it to be about 20% of _available_ RAM.

How many rows are you batching in each INSERT? If you are inserting rows one at a time, something else is going on to cause "users are blocked few seconds". Let's see SHOW PROCESSLIST during one of these incidents.

Can you change to InnoDB, which uses "row level locking" instead of "table level locking"?

Options: ReplyQuote

Written By
Re: Problem: INSERT DELAYED works like normal INSERT
March 31, 2012 12:59PM

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.