Re: auto_increment id

2004-03-12 Thread Rocar Peças
Mrs Reznichenko, About the ID problem, I´d create a single table just for ID´s (and ´d keep it as thin as possible). This would avoid the repeating id numbers. Sincerely Leandro da Rocar. <[EMAIL PROTECTED]> - Original Message - From: "Victoria Reznichenko" <[EMAIL PROTECTED]> To: <[

Re: Serveral mysqld instances

2004-03-11 Thread Rocar Peças
Mr. Pendleton, Exactly. "ps -aux | grep mysqld" show several instances of the mysql_server running at the same time. By now, I have 69!. Thanks in advance. Leandro M Neves - Original Message - From: "Victor Pendleton" <[EMAIL PROTECTED]> To: "&#

Re: @@identity

2004-03-10 Thread Rocar Peças
My Aaron, I don´t know any means to get the last inserted record into a MySQL table, as built-in command. What I would do to get this record is to have a timestamp field in the record (mmddmilisecsinday) to solve the problem. That´s it. Leandro Neves. - Original Message - From: "

Serveral mysqld instances

2004-03-10 Thread Rocar Peças
mysqld quickly gets 80MB large in RAM, and the number of mysqld usually reaches 80, so my 1GB RAM server gets out of memory early in the morning. What is happening? Isn´t mysqld supposed to have only one instance running on kernel? Thanks. Leandro M Neves, ROCAR PEÇAS LTD Sete Lagoas/MG

Re: Newbie question on Comparing fields in 2 tables?

2004-03-10 Thread Rocar Peças
searchname, "%") == Best wishes, Leandro M Neves, ROCAR PEÇAS LTD. Sete Lagoas/MG - Brazil - Original Message - From: "Ian Izzard" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 10, 2004 2:05 PM Subject

C Programing: mysql_free_result

2003-12-31 Thread Rocar Peças
Dear Friends, I´m programming in C, Linux envirnment. The SELECT´s results are being brought to the client by using mysql_store_result. And the result sets are being released by mysql_free_result. The problem is: as mysql_free_result is called, the system memory is NOT actually released. For