Re: Too many tables; MySQL can only use 61 tables in a join

[Rick James]

> A regular maintenance job can move records from one table to the other

Depending on what triggers the move, PARTITIONing may be a solution which need little or no action on your part.

> tables all with the same structure.

Hmmm... Don't you want UNION?

Sometimes (not always), this pattern can get rid of a JOIN:

SELECT ...,
( SELECT foo FROM tbl1 ... ) AS foo,
( SELECT bar FROM tbl2 ... ) AS bar,
...
FROM ...

The subqueries are likely to be 'correlated' subqueries, which (I think) would not count toward the 61. They would replace the need for JOINing to tbl1 and tbl2. (Yeah, that gets messy and inefficient if you need more than one field from tbl1.)

Phillip and I are guessing at what would help. If you want more specific advice, let's see your query and the SHOW CREATE TABLE for the table(s).