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
8303
July 29, 2005 02:50PM
Re: #sql files
4414
July 29, 2005 03:29PM
4403
July 29, 2005 04:32PM
3805
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.