SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Hybrid View

  1. #1
    SitePoint Guru
    Join Date
    Sep 2008
    Posts
    977
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    temp tables not being deleted

    Hi.

    A query of mine seems to be creating temp files in the tmp dir of my server. I thought that when the query had finished with them, that MySQL would delete them but it seems not to be so.

    Is there a setup configuration that I need to change so that they will be deleted or is this something I need to do in my scripting or with a cron job?

    bazz

  2. #2
    SitePoint Guru
    Join Date
    Sep 2008
    Posts
    977
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Also, if a query creates a temporary table, what is the method by which I can access its name? (for the purpose of adding drop temporary table to a new statement).


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •