All geek questions in one place

Are MySQL INSERT statements slower in huge tables?

I can see how manual SELECTand UPDATEslow down as they grow and the growth of the table, but what about INSERT?

+3
source share
6 answers

INSERT also slows down especially if you have a lot of indexes which also need to be updated.

However, there is a difference between different storage systems: MyISAMfaster for a large number SELECT, InnoDB is faster for a large number INSERT/ UPDATE, because it uses row locking instead of table locking and the way indexes are handled.

+5
source

INSERT , .

+3

:

+3

, - O (1) .

, , ?

  • , (, )
  • (, , / ).
  • , , INSERT DELAYED
+3

INSERT .

+1

, . , , , , .

InnoDB MyISAM, , , ( ). - 18 , .

, / , , , INSERT DELAYED UPDATE [LOW_PRIORITY]

, , , te, . *, , ( InnoDB MyISAM), .

, 5 , 20 100K 300K .

.

-1

Source: https://habr.com/ru/post/1753273/

More articles:


All Articles