1 reputation
1
bio website
location
age
visits member for 1 year, 6 months
seen Nov 3 '12 at 9:21

Oct
9
comment Inserting query result to another table hangs on “Copying to temp table on disk” on MySQL
imageshack.us/photo/my-images/255/capturefwm.png @jcolebrand Is that dezso want? Or, I did not understand well.
Oct
9
comment Inserting query result to another table hangs on “Copying to temp table on disk” on MySQL
@dezso, yes, it's compatible. tokensID is a char string.
Oct
9
comment Inserting query result to another table hangs on “Copying to temp table on disk” on MySQL
Explain output for SELECT: imageshack.us/photo/my-images/26/capturefje.png
Oct
9
comment Inserting query result to another table hangs on “Copying to temp table on disk” on MySQL
So, how can I change these two variables? As I understood, I have to decrease them. My tmp_table_size=14M and the other is greater than this.
Oct
9
awarded  Editor
Oct
9
revised Inserting query result to another table hangs on “Copying to temp table on disk” on MySQL
added 645 characters in body
Oct
9
asked Inserting query result to another table hangs on “Copying to temp table on disk” on MySQL