Problem with many connections

[phil none]

Hi,

I have the following problem:

I do something like:


while(1)
{
conn = mysql_init(NULL);
if (mysql_real_connect(...)

if(mysql_query (conn, "SELECT * FROM xyz") != 0)
fprintf(stderr, "mysql_query() failed\n");
else
{
res_set = mysql_store_result (conn);
//print the results...
}
mysql_close (conn);
// do sth else which takes about 1 sek,
// then begin and init new connection
}

After a few minutes the sqlserver crashes and I can no longer connect until I restarted it. Can you help me please?

Thanks in advance