> Hi:
>
> I'm having a memory leakage executing the next statement that
> iterates about 100000 times within a loop in mysql 3.22.27:
>
> for (Count = 0 ; Count < 100000 ; Count++)
> {
> mysql_query(mysql
> ,"LOAD DATA LOCAL
> INFILE '/tmp/FicN1N6.tmp'
> INTO TABLE Tab_n1n6
> FIELDS TERMINATED BY ';'
> LINES TERMINATED BY '\n' (n1,n2,n3,n4,n5,n6)");
> }
>
> I've tested it just with:
> File /tmp/FicN1N6.tmp':
> 1;2;3;4;5;6
>
> Table Tab_n1n6(no indexes):
> Field Type
> N1 tinyint(3) unsigned
> N2 tinyint(3) unsigned
> N3 tinyint(3) unsigned
> N4 tinyint(3) unsigned
> N5 tinyint(3) unsigned
> N6 tinyint(3) unsigned
>
> When running this benchmark the memory used by the program increases
> about 4K every 20 iterations(I check it through "top")
>
> I've realized that this statement returns some information with
> mysql_info(Number of files, Number of warnings,..)
>
> When executing the same loop with "INSERT INTO Tab_n1n6
> (n1,n2,n3,n4,n5,n6) VALUES (1,2,3,4,5,6)" it does not occur(the memory
> leakage) and no information is retrieved through mysql_info.
>
> I've been trying with "INSERT INTO .. SELECT ..." and "CREATE TABLE
> ..." and "DROP TABLE ...". No leakage; and no information is retrieved
> through mysql_info.
>
> I think that, possibly, the problem is that that information is
> allocated and not freed.
>
> If that is the question: How can I free that memory?
> If it isn't, what am I doing wrong? where's my mistake?
> Does someone face this problem before?
>
> Regards.
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
