mysql使用roll up后出现Using temporary，Using filesort

mysql使用roll up后sql出现Using temporary; Using filesort，怎么优化啊

http://blog.csdn.net/imzoer/article/details/8485680