From: franco riggi
Date: October 18 2012 8:43am
Subject: Re: Temporary files
List-Archive: http://lists.mysql.com/innodb/68
Message-Id: <CANnYp6hA9PgiG0F-V3kf0_9Q0r7F0jy--cPEkHXTZxUgDY0O2w@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=047d7b33d4cc88c5c804cc5162ab

--047d7b33d4cc88c5c804cc5162ab
Content-Type: text/plain; charset=ISO-8859-1

Hello,

ok..I found some answer here
http://dev.mysql.com/doc/refman/5.0/en/internal-temporary-tables.html
like tmp are using the MyISAM format when stored into the HD.


Thanks,
Francesco


2012/10/18 franco riggi <franco.riggi@stripped>

> Hello,
>
> I had several time an error like
> Incorrect key file for table '/tmp/#sql_4aa7_1.MYI'; try to repair it
> and I didn't found any really deep info about how MySQL uses and create
> the temporary files.
> In particular I don't  have clear
> 1) why the format is MYI whlle we do not use any MyISAM table (I have only
> Innodb);
> 2) how can I monitor how their size ( that is not easy because are hidden
> files) . I have a tmp  folder which is around 5G but probably it is not
> enough.
> 3) best suggestion for tmp tuning
>
> All the best,
> Francesco
>

--047d7b33d4cc88c5c804cc5162ab--