Re: Why is MySQL using /tmp?

If I understand the manual correctly, it uses /tmp for creating temporary tables if their size exceed the smaller of tmp_table_size or max_heap_table_size, otherwise, it will create the temporary table in memory. So if tmp_table_size is set to say 10Mb, and MySQL needs to create a temporary table

Re: Why is MySQL using /tmp?

Yes it is used for temporary tables. You can also set the directory for temporary tables to some bigger partition. Cheers Claudio 2009/6/11 Amr Mostafa amr.most...@gmail.com If I understand the manual correctly, it uses /tmp for creating temporary tables if their size exceed the smaller of

Re: Why is MySQL using /tmp?

This might help: http://dev.mysql.com/doc/refman/5.1/en/temporary-files.html On Jun 11, 2009, at 12:51 AM, Mike Spreitzer wrote: I find my MySQL Community Edition 5.1.34 server running out of space on /tmp (which is indeed small). Why is it using /tmp? How much free space do I need on

Why is MySQL using /tmp?

I find my MySQL Community Edition 5.1.34 server running out of space on /tmp (which is indeed small). Why is it using /tmp? How much free space do I need on /tmp? Can/should I make the server use a different location instead of /tmp? Thanks, Mike Spreitzer