Mysql will sometimes create internal temporary tables while processing statements.
Users have no direct control over when this occurs

https://dev.mysql.com/doc/refman/5.7/en/internal-temporary-tables.html
http://stackoverflow.com/questions/7532307/skip-copying-to-tmp-table-on-disk-mysql