>>>>> "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
