Hi, everybody:
I have received no answer to my question and I suppose it is because
no one has faced this problem before.
Could anyone of you check this benchmark and tell me wether it also
occurs in your environment or not?
That could help me when looking for the possible causes.
Thank you all for the bother.
> ----------
> De: Manuel Barrientos
> Enviado el: jueves 17 de mayo de 2001 11:00
> Para: '[EMAIL PROTECTED]'
> Asunto: C-API and LOAD DATA
>
>
>
> 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
