List:Internals« Previous MessageNext Message »
From:Michael Widenius Date:April 23 2001 4:42pm
Subject:PATCH: tmp table on disk or in memory?
View as plain text  
Hi!

>>>>> "Jon" == Jon Valvatne <jonva@stripped> writes:

Jon> Hello,
Jon> Just a quick suggestion here, based on my recent experiences dealing with
Jon> a web server struggling under heavy load:

Jon> It seems to me that it is be very useful to know whether temporary
Jon> tables are being created on disk or in memory. Would it be possible to
Jon> change the current "Copying to tmp table" State message to read either
Jon> "Copying to tmp table on disk" or "Copying to tmp table in memory"?

Jon> If I have overlooked some other easy way to spot this info on a per-query
Jon> basis, I'm sorry. I know there are extended-status variables for this, but
Jon> being able to see it right on the processlist would be nice.

Jon> Jon Valvatne

(/my/mysql/sql) bk diffs -c sql_select.cc
===== sql_select.cc 1.96 vs edited =====
*** /tmp/sql_select.cc-1.96-31233       Sun Apr 22 12:11:01 2001
--- edited/sql_select.cc        Mon Apr 23 19:41:20 2001
***************
*** 3915,3922 ****
    table->file=0;
    *table =new_table;
    table->file->change_table_ptr(table);
!
!   thd->proc_info=save_proc_info;
    DBUG_RETURN(0);
 
   err:
--- 3915,3922 ----
    table->file=0;
    *table =new_table;
    table->file->change_table_ptr(table);
!   thd->proc_info= (!strcmp(save_proc_info,"Copying to tmp table") ?
!                  "Copying to tmp table on disk" : save_proc_info);
    DBUG_RETURN(0);
 
   err:

Regards,
Monty
Thread
tmp table on disk or in memory?Jon Valvatne23 Apr
  • PATCH: tmp table on disk or in memory?Michael Widenius23 Apr
  • Re: PATCH: tmp table on disk or in memory?Jon Valvatne23 Apr
  • Re: PATCH: tmp table on disk or in memory?Jon Valvatne23 Apr
    • Re: PATCH: tmp table on disk or in memory?Michael Widenius23 Apr
      • Re: PATCH: tmp table on disk or in memory?Jon Valvatne24 Apr