MySQL Forums :: Performance :: LOAD_FILE + LONGBLOB performance

Advanced Search

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

Subject Views Written By Posted
LOAD_FILE + LONGBLOB performance 3062 staszek findeisen 12/11/2009 03:04PM
Re: LOAD_FILE + LONGBLOB performance 1449 Rick James 12/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.