…created which temporary tables (both in memory and not): mysql> select * from information_schema.global_temporary_tables \G *************************** 1. row *************************** SESSION_ID: 7234 TABLE_SCHEMA: test TABLE…

…tables with ASCII identifiers and we’re doing JOINs against tables in this database and seeing that indexes aren’t being used in…temporary table rather than the temporary table name that was displayed in the error message.  Once you do that, you can run something like this: CREATE TABLE…MySQL…

… recommend creating an index in every table you create? Example: CREATE TABLE user_competition_entry user_id (INT), competition_id(INT); The table is…Index on the column MySQL can avoid temporary table or filesort for group by by this column. This works because by scanning data in index order MySQL…