急union all 施用出错？

急，union all 使用出错？？？

SELECT min(fromm5time(starttime)),max(fromm5time(endtime)), inet_btoa(tunsrc),GTPTEID,

tunsrcport,tundstport, 

sum(octets/1000000)as ULthroughput,

max(octets/((endtime-starttime)/1000000000)/1000000) as “max_rate(MByte/s)”,

inet_btoa(src),inet_btoa(dst) 

from(

select starttime,endtime,tunsrc,GTPTEID,tunsrcport,tundstport,octets,src,dst,packets from flow_agent8_job23

union all

select starttime,endtime,tunsrc,GTPTEID,tunsrcport,tundstport,octets,src,dst,packets from flow_agent8_job24

union all

select starttime,endtime,tunsrc,GTPTEID,tunsrcport,tundstport,octets,src,dst,packets from flow_agent8_job25

union all

select starttime,endtime,tunsrc,GTPTEID,tunsrcport,tundstport,octets,src,dst,packets from flow_agent8_job26

) as c

where 

starttime > tom5time(‘2012-07-09 00:00:01’ )

and endtime < tom5time(‘2012-07-09 23:59:59’ ) 

and inet_btoa(dst) like ‘10.247%’ 

and ((endtime-starttime)/1000000>100)

and (packets>100)

group by GTPTEID,dst

在几个表中按时间取数据，但是运行时遇到了错误 SQL Error (126): Incorrect key file for table ‘/tmp/#sql_db6_0.MYI’; try to repair it */

能帮我解决么？？？？？，不用union all 却可以取数据

还有多少磁盘空间？




临时表存放空间不足 

 

show variables like ‘%tmp%’;

看看此目录是否已经没有足够空间用于临时表的排序




没有足够的表空间造成的，检查。