atson/[EMAIL PROTECTED]
cc
Subject
RE: SQL query crashes MySQL
Does that crash the server in command-line mode (via mysql) or just in
MySQLcc?
I've seen similar crashes (actual full server crashes) in similar queries
but only under mysqlcc. It seems that the results come back but the
se
Hi!
On Sep 12, Irwin Boutboul wrote:
> Here it is:
>
> select floor(avg(selection.bandwidth))*8000 as avgbandwidth from (select
> avg(bandwidth) as bandwidth from FEEDBACK_DOWNLOADS where servername= ?
> and ( bytesdownloaded > 50 or timeduration > 3000 ) group by id order
> by startti
Here it is:
select floor(avg(selection.bandwidth))*8000 as avgbandwidth from (select
avg(bandwidth) as bandwidth from FEEDBACK_DOWNLOADS where servername= ?
and ( bytesdownloaded > 50 or timeduration > 3000 ) group by id order
by starttime desc limit 20) as selection;
This complex (?)
