List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:November 29 1999 11:19pm
Subject:Re[2]: Some Questions
View as plain text  
>>>>> "Peter" == Peter Zaitsev <pz@stripped> writes:

Peter> Hello Paul,
Peter> Monday, November 29, 1999, 3:46:20 PM, you wrote:


PD> But it won't behave like that for him, because TEMPORARY isn't available
PD> until 3.23.

PD> Because of that, he'll need to delete any tables that he considers
PD> temporary.  MySQL won't do it automatically, because it doesn't know
PD> which ones are temporary.

Peter> May be you did not understand me properly.
Peter> I have mysql 3.22.27 and I desided to use it with --big_tables option
Peter> to avoid table full error.  MYSQL stores some temporery files
Peter> (SQLXXXXX_X.ISX)in apropriate path: "/tmp/"  I thought mysql will
Peter> delete it after some time passes but it does not. I started to delete
Peter> it every half an hour then I discovered about 20000 files taking about
Peter> 500MB of disk space.  I think this is really strange behavior.

Peter> +--------------------------+----------+
Peter> | Variable_name            | Value    |
Peter> +--------------------------+----------+
Peter> | Aborted_clients          | 0        |
Peter> | Aborted_connects         | 10       |
Peter> | Created_tmp_tables       | 57353    |
Peter> | Delayed_insert_threads   | 0        |
Peter> | Delayed_writes           | 0        |
Peter> | Delayed_errors           | 0        |
Peter> | Flush_commands           | 2        |
Peter> | Handler_delete           | 22219    |
Peter> | Handler_read_first       | 98       |
Peter> | Handler_read_key         | 16563944 |
Peter> | Handler_read_next        | 38271719 |
Peter> | Handler_read_rnd         | 37314980 |
Peter> | Handler_update           | 41986    |
Peter> | Handler_write            | 3674249  |
Peter> | Key_blocks_used          | 11026    |
Peter> | Key_read_requests        | 1073564  |
Peter> | Key_reads                | 10324    |
Peter> | Key_write_requests       | 73783    |
Peter> | Key_writes               | 30719    |
Peter> | Max_used_connections     | 74       |
Peter> | Not_flushed_key_blocks   | 0        |
Peter> | Not_flushed_delayed_rows | 0        |
Peter> | Open_tables              | 650      |
Peter> | Open_files               | 103      |
Peter> | Open_streams             | 1        |
Peter> | Opened_tables            | 2605     |
Peter> | Questions                | 980179   |
Peter> | Running_threads          | 34       |
Peter> | Slow_queries             | 95       |
Peter> | Uptime                   | 67912    |
Peter> +--------------------------+----------+

Hi!

MySQL should delete the temporary files as soon as the query is ready

You are not using the not documented '-T' option, are you ?

Regards,
Monty
Thread
Some QuestionsPeter Zaitsev28 Nov
  • Re: Some Questionssinisa28 Nov
    • Re: Some QuestionsPaul DuBois29 Nov
      • Re[2]: Some QuestionsPeter Zaitsev29 Nov
        • Re[2]: Some QuestionsMichael Widenius30 Nov