Pending results blocking mysql-server

of queries, it even happens, that a connection to the mysql-server is blocked. i think it would be the best to get rid of hte pending results on the server, that are not fetched after let's say 20 seconds. Which variable do i need to set to achieve this (if possible). The program uses the C-API

Re: Pending results blocking mysql-server

of queries, it even happens, that a connection to the mysql-server is blocked. i think it would be the best to get rid of hte pending results on the server, that are not fetched after let's say 20 seconds. Which variable do i need to set to achieve this (if possible). The program uses the C

AW: Pending results blocking mysql-server

to set a timer in your app, calling that function after, for example, 20 seconds. -Ursprüngliche Nachricht- Von: Stefan Hinz [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Februar 2004 12:15 An: Franz, Fa. PostDirekt MA Cc: [EMAIL PROTECTED] Betreff: Re: Pending results blocking mysql-server

Re: AW: Pending results blocking mysql-server

Franz, Fa. PostDirekt MA wrote: Hi Stefan, thanks for your fast reply ! Would it be possible to call mysql_free_result() from your application? You might be able to set a timer in your app, calling that function after, for example, 20 seconds. I am not the of developer this programm ... But

AW: AW: Pending results blocking mysql-server

Pachev [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 17. Februar 2004 14:19 An: Franz, Fa. PostDirekt MA Cc: Stefan Hinz; [EMAIL PROTECTED] Betreff: Re: AW: Pending results blocking mysql-server Franz, Fa. PostDirekt MA wrote: Hi Stefan, thanks for your fast reply ! Would it be possible

Re: Pending results blocking mysql-server

, it even happens, that a connection to the mysql-server is blocked. i think it would be the best to get rid of hte pending results on the server, that are not fetched after let's say 20 seconds. Which variable do i need to set to achieve this (if possible). The program uses the C-API. The serve

Re: AW: AW: Pending results blocking mysql-server

The problem is, that i can't prevent queries like SELECT * FROM TABLE WHERE COLUMN LIKE 'a%' where an index will not help on a Table 100.000.000 records. It's not that we have to answer hese queries (therefore the timeout), but it's impossible to prevent dumm users. Run EXPLAIN on the

Re: AW: AW: Pending results blocking mysql-server

Klaus, in this case, I suspect, is that the disconnect happens in the pre-data-sending stage, which is possibly quite lengthy. Exactly ! It takes hours till these results are erased and i even don't know where the period when they are erased come from. I still hope this is set in a

Pending results...

Im having trouble with 'to many pending results' in MySQL. Any ideas? - amund