You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
This repository has been archived by the owner on Aug 14, 2019. It is now read-only.
Currently we download, decompress and use LOAD DATA INFILE on https://github.com/elliotchance/mbzdb/blob/master/backend/mysql.pl, but I think decompressing to disk isn't really needed: we could decompress to a pipe and LOAD DATA from it, avoiding slow seek times and extra disk space needed for decompression :
mkfifo /tmp/fifo
tar -xjf mbdump.tgz artist -O > /tmp/fifo &
LOAD DATA LOCAL INFILE '/tmp/fifo' INTO TABLE ....
BTW, this should be configurable by user (fifo path, etc).
The text was updated successfully, but these errors were encountered:
Currently we download, decompress and use LOAD DATA INFILE on https://github.com/elliotchance/mbzdb/blob/master/backend/mysql.pl, but I think decompressing to disk isn't really needed: we could decompress to a pipe and LOAD DATA from it, avoiding slow seek times and extra disk space needed for decompression :
mkfifo /tmp/fifo
tar -xjf mbdump.tgz artist -O > /tmp/fifo &
LOAD DATA LOCAL INFILE '/tmp/fifo' INTO TABLE ....
BTW, this should be configurable by user (fifo path, etc).
The text was updated successfully, but these errors were encountered: