Hi there!
I have a strange problem with php/mySQL:
I'm trying to write a chat engine, which works.. let's say quite okay for the first minutes (about 10 or 20, depends).
But after some time, I get an error message "mySQL client ran out of memory", and for several minutes, nearly nothing is working.
The Output of the Chat is created through a script which runs in a nearly-endless loop (while(!connection_aborted){ ... }), and gets the new messages out of a table with a simple select.
I have inserted a 1-second-timeout in the loop, this did help a bit (got me 5 - 10 more minutes)...
Does anyone have an idea?
RIP
Moriemus
I have a strange problem with php/mySQL:
I'm trying to write a chat engine, which works.. let's say quite okay for the first minutes (about 10 or 20, depends).
But after some time, I get an error message "mySQL client ran out of memory", and for several minutes, nearly nothing is working.
The Output of the Chat is created through a script which runs in a nearly-endless loop (while(!connection_aborted){ ... }), and gets the new messages out of a table with a simple select.
I have inserted a 1-second-timeout in the loop, this did help a bit (got me 5 - 10 more minutes)...
Does anyone have an idea?
RIP
Moriemus