>>>>> "Jon" == Jon Valvatne <jonva@stripped> writes:
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 ****
--- 3915,3922 ----
! thd->proc_info= (!strcmp(save_proc_info,"Copying to tmp table") ?
! "Copying to tmp table on disk" : save_proc_info);