Random Behaviour of Load_File and Extract Function of MSQL 5.1

Question

Hi Guys. I am Using Mysql 5.1 as a datastore. Here, I am having a lot of Data, So I have created a big XML File(max upto 1-GB Size), and I have Created a Procedure for Doing this, I m using few functios i.e.,

Declare XML BIGTEXT ;

SET xml = LOAD_FILE(file_name);

SET nrows = ExtractValue(xml, 'count(/.../row)') and same way ncols for each rows.

The Problem is when it comes to workng with small files i.e., 1MB or 2Mb Files, It works fine, but when it comes to bit more i.e.,7 or 8MB, it fails to load and even some times it shows random bh/r , load data some time, som times not. I have set the size of Max_Allowed_Packed_size to 1GB in my procedure.

Anybody have an Idea how it happens.

Thanks a lot for help.