The use by heart of the processes mysqld it is increased considerably of to
four kbytes every 5 seconds approximately. In the team in question are
running 4 programs that consent to MySQL by means of the interface of MySQL
for C, all the functions that you/they obtain data of the charts MySQL they
liberate the used memory.
For sure the problem is since the programs in C when not being executed the
demons mysqld they stop to consume memory; the topic is that in all the
calls that I make I liberate the used memory.
The logic that you/they use the routines in C is the same one that the
function that I happen next.
----------------------------------------------------------------------------
-------------------------------------------------------
int DB_Existe_Id_Cliente (element *agente)
{
MYSQL_RES *result;
int return;
MYSQL_ROW row;
sprintf(query, SELECT names FROM clients WHERE id=%d", agent->info.header.id_cliente);
if ((retorno=mysql_query(connection,query)) != 0)
return -1;
result=mysql_store_result(connection);
if (mysql_num_rows(result) == 0)
{
mysql_free_result(result);
RETURN FALSE;
}
IF ((row=MYSQL_FETCH_ROW(RESULT)) == NULL)
return -3;
strcpy(agente->info.header.nombre_cliente,row[0]);
mysql_free_result(result);
return TRUE;
}
-----------------------------------------------------------------------------------------------------------------------------------
Are there some error or incorrect use of the functions of the interface for C in the
routine DB_Existe_Id_Cliente?
Does somebody have some idea of that that this happening?
Thank you,
Diego. -
Top output:
Nov 17 12:01:26:
PID USER PRI NI SIZE RSS SHARE STAT LIB %CPU %MEM TIME COMMAND
860 root 0 0 5476 5192 1820 S 0 0.0 11.0 0:01 mysqld
864 root 0 0 5476 5192 1820 S 0 0.0 11.0 0:00 mysqld
865 root 0 0 5476 5192 1820 S 0 0.0 11.0 0:00 mysqld
3614 root 0 0 5476 5192 1820 S 0 0.0 11.0 0:00 mysqld
3619 root 0 0 5476 5192 1820 S 0 0.8 11.0 0:09 mysqld
3621 root 0 0 5476 5192 1820 S 0 22.0 11.0 13:41 mysqld
3623 root 0 0 5476 5192 1820 S 0 0.0 11.0 0:00 mysqld
Nov 17 12:02:21
860 root 0 0 5504 5220 1820 S 0 0.0 11.1 0:01 mysqld
864 root 0 0 5504 5220 1820 S 0 0.0 11.1 0:00 mysqld
865 root 0 0 5504 5220 1820 S 0 0.0 11.1 0:00 mysqld
3614 root 0 0 5504 5220 1820 S 0 0.0 11.1 0:00 mysqld
3619 root 0 0 5504 5220 1820 S 0 0.1 11.1 0:09 mysqld
3621 root 12 0 5504 5220 1820 S 0 52.5 11.1 14:02 mysqld
3623 root 0 0 5504 5220 1820 S 0 0.0 11.1 0:00 mysqld
