I am running MySQL 5.0.51a-24+lenny2 (Debian) on Debian GNU/Linux on AMD Athlon XP 1830.980 MHz 512 KB cache and 1GB DDR RAM. I am trying to insert 513 MB file into a LONGBLOB column using LOAD_FILE. Unfortunately queries like those take about 30 seconds of CPU time (about 6-15 minutes real time), and I can see that MySQL daemon grows to 1.63 GB.

When I try with 2 times smaller file, the server grows to just 1.12 GB and it only takes 14 seconds of CPU time.

The table is really very simple, it has only 4 rows, and I am talking about a single literal INSERT statement here (from mysql console). The storage engine is InnoDB.

I have no other activity on the server (this is a test machine).

Why is this so expensive??! Does LOAD_FILE try to allocate the given file in memory twice??

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.