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

2004-02-17 Thread Stefan Hinz
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 ser

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

2004-02-17 Thread Sasha Pachev
The problem is, that i can't prevent queries like SELECT * FROM WHERE 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 untrusted queries f