MySQL Forums
Forum List  »  Performance

LOAD_FILE + LONGBLOB performance
Posted by: staszek findeisen
Date: December 11, 2009 03:04PM


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??


Options: ReplyQuote

Written By
LOAD_FILE + LONGBLOB performance
December 11, 2009 03:04PM
December 12, 2009 10:49PM

Sorry, you can't reply to this topic. It has been closed.

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.