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"?
Subject
Views
Written By
Posted
3234
March 27, 2012 06:15AM
1457
March 29, 2012 09:49PM
1523
March 30, 2012 10:08AM
Re: Problem: INSERT DELAYED works like normal INSERT
1898
March 31, 2012 12:59PM
1825
April 01, 2012 07:31AM
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.