Reputation
Top tag
Next privilege 125 Rep.
Vote down
Badges
2
Newest
 Student
Impact
~766 people reached

  • 0 posts edited
  • 0 helpful flags
  • 0 votes cast
Jun
18
awarded  Student
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