Re: Server just hanging (Copying to tmp table)

[Vladimir Suvarina]

Hello all,

I confirm the same problem on Linux box, running 4.1.21-log on Gentoo. I had read through this forum, tweaked my.cnf (manytimes), tweaked sysctl.conf, pam security module to change ulimit for "open files" even for "max user process". Still no luck, my server hanged frequently with "Copying to tmp table" on INNER JOIN queries. All stats mentioned in this thread are in normal.

What did help, was rewriting the query from INNER JOIN (using where a.indexed_id = b.indexed_id) to LEFT JOIN (b on b.indexed_id = a.indexed_id). This is really, REALLY strange, because the data are in 1:1 realtion, so LEFT JOIN is completly inappropriate.

I can post all the info needed, as I can also give somebody from MySQL AB a nearly root account on that box. Is this thread still alive?