INSERT DELAYED
INSERT DELAYED:
When we uses INSERT DELAYED, it gets an okay from the server at once, and the row is queued to be inserted when the table is not in use by any other thread.
Syntax:
INSERT DELAYED INTO table (col1,col2,…) VALUES (val1,val2,…);
Major benefit of using INSERT DELAYED is that inserts from many clients are bundled together and written in one block. This is much faster than performing many separate inserts.
