平均存储流量值,单位MB/h
set @d1=(select min(updateTime) fromdaas_access_storage_files where status=6);
set @d2=sysdate();
selectsum(fileSize/(1024*1024))/hour(timediff(@d2,@d1)) fromdaas_access_storage_files where status=6;
平均存储流量值,单位MB/h
set @d1=(select min(updateTime) fromdaas_access_storage_files where status=6);
set @d2=sysdate();
selectsum(fileSize/(1024*1024))/hour(timediff(@d2,@d1)) fromdaas_access_storage_files where status=6;