If “load” command actually write its data into the table only when it receives a EOF from the FIFO(if we use it loading from FIFO) or something else happened? My situation is that the write may be waiting for its feed a long time, during this period, no data wrote to the FIFO, does the Load wait on FIFO all the time other than commit its avialable data? then the query will be blocked all the time in current IB’s release.

Thanks.

Hi,

It works as you have described. Currently “load” will obtain an exclusive lock on a table and will wait for EOF.
I think that as a workaround you may load the data from FIFO to MyISAM table and then periodically, export the data from it and load to BH table.

Cheers