Re: #sql files
Mike Connell wrote:
> Using some i/o tools, I'm seeing heavy traffic to
> /db/mysqldata/rpt/#sql-13ab_ee.MYD and
> /db/mysqldata/rpt/#sql-13ab_ee.MYI files.
>
> A couple of days ago, I dropped two indexes on my 'token' table. After that, I started noticing
> these files being read/written to by MySQL.
I can imagine these files are for temporary tables MySQL has to create to execute your queries after you dropped your indexes.
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Views
Written By
Posted
8372
July 29, 2005 02:50PM
Re: #sql files
4440
July 29, 2005 03:29PM
4427
July 29, 2005 04:32PM
3835
August 02, 2005 03:23AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.