MySQL Forums
Forum List  »  Newbie

Re: Moving Average Query Not Completing
Posted by: Peter Brawley
Date: October 03, 2017 12:47PM

Quote

1. WHERE x.year_c-y.year_c BETWEEN 0 AND 4
AND x.year_c = [value]

2. WHERE x.year_c-y.year_c BETWEEN 0 AND 4
AND x.year_c >= [value]

3. WHERE x.year_c-y.year_c BETWEEN 0 AND 4
AND x.year_c BETWEEN [value AND [value]

But none are correct.

Incorrect how?


> innodb_buffer_pool_size | 268435456

Absurdly low, you have a poor man's shared hosting setup, good only for toy databases, wildly inadequate for what you're trying to do. Let's see the result of ...

select  
  concat(round(sum(table_rows)/1000000,2),'m') rows, 
  concat(round(sum(data_length)/(1024*1024*1024),2),'g') data, 
  concat(round(sum(index_length)/(1024*1024*1024),2),'g') idx, 
  concat(round(sum(data_length+index_length)/(1024*1024*1024),2),'g') total_size, 
  round(sum(index_length)/sum(data_length),2) idxfrac 
from information_schema.tables 
where table_schema='YOUR DB NAME HERE';



Edited 2 time(s). Last edit at 10/03/2017 02:59PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
September 26, 2017 04:16PM
Re: Moving Average Query Not Completing
October 03, 2017 12:47PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.