insert delayed v mysql

[Ondrej Koala Vacha]

Dobre poledne,

v souvislosti s jednim problem si ctu popis INSERT DELAYED pro myisam
tabulky mysql. Hned v prvnim odstavci se pravi, ze tento prikaz muze byt
uzitecny, pokud se dela insert a zaroven se casto pousti SELECT a UPDATE. Proc
ceka INSERT na UPDATE je jasne, ale proc by mel cekat na SELECT?
Uvazuji (stejne jako v mem problemu) se se nedela lock tables.


Pro jistotu jsem na velke tabulce dal casove dlouhy select a nez se data
vratila, mohl jsem davat kolik insertu jsem chtel. Takze zda se, ze neni
ani teoreticky, ani prakticky duvod zminovat SELECT.


citace:
---------------------------------------------------------------------
INSERT DELAYED .


The DELAYED option for the INSERT statement is a MySQL-specific option
that is very useful if you have clients that can't wait for the INSERT to
complete. This is a common problem when you use MySQL for logging and you
also periodically run SELECT and UPDATE statements that take a long time
to complete.



s diky
--
Ondrej Koala Vacha