Re: Very slow SELECT on 13.000 Rows

[Rick James]

InnoDB 'clusters' the PRIMARY KEY with the data. You have no secondary keys. So, I would expect Index_length to be essentially 0. Please do SHOW TABLE STATUS.

To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]
Please do those on both setups -- something may be different between them.
How much RAM?

Your PRIMARY KEY is BINARY(16). Does this mean it is a GUID or UUID or MD5? Such keys are _very_ random. Once the data becomes bigger than cache, the processing becomes I/O-bound.

I see no indexes to support the JOINs.

(This board is fine for the question. Please provide the above info, and we can dig deeper.)