» Quick Links
You can make money on these forums
We Share profits with you
Google
Google Adsense
Google Adwords
YPN
Yahoo
MSN Search
Web Directories
Web Hosting
Web Hosting Offers
Hosting News
Suggestions
Link Building
Domain Names
PHP Forums
MySQL Forums
» More Links
OSP News
Reseller Hosting
Shared Hosting
Dedicated Servers
Google Adsense
Search Engine Marketing
Link Development
Affiliate Marketing


» Advertising
Multiple DC PR Check

Free SEO Tools


Go Back   Webmaster Forums > Website Developement / Programming > MySQL Forums

MySQL Forums Share Your Ideas and Tips about MYSQL. Ask questions about MYSQL. Table Design and Much More...

Reply
 
Thread Tools Display Modes
  #1  
Old 08-12-2006, 10:44 AM
Maddox Maddox is offline
Junior Member
 
Join Date: Aug 2006
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Maddox is on a distinguished road
Default files-token table?

Hi,
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.

When I do an ls-lat of this directory, there are no such files listed.

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.

Are these files somehow related to my 'token' table? Is it a good idea to get rid of them?
Thanks, -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
Revenue Sharing Ads ( ?):
  #2  
Old 08-12-2006, 10:46 AM
Freed Freed is offline
OSP Starters
 
Join Date: Jul 2006
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Rep Power: 0
Freed is on a distinguished road
Default

These files are for temporary tables MySQL has to create to execute your queries after you dropped your indexes. -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Free File Storage Hosts vishnuthegreat Domains For Sale - Fixed Price/Offer 1 03-06-2007 09:31 AM
unable to add posts to a phpbb table after moving servers. tanny MySQL Forums 3 02-13-2007 03:44 PM
Math Op Addition of Values in repeated table gower PHP Programming and Tips 1 08-22-2006 01:39 PM
designing table relations? Jett MySQL Forums 1 08-17-2006 10:23 AM
error= #1036 - Table 'table' is read only futuristic PHP Programming and Tips 1 08-12-2006 10:21 AM


All times are GMT. The time now is 12:32 PM.