Announcement

Collapse
No announcement yet.

Incorrect key file

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Incorrect key file

    Working on a module that generates this error on our live store but not our dev store: mysql_execute: Incorrect key file for table '/tmp/#sql_41e7_0.MYI'; try to repair it.

    It is loading over 200,000 values in a batch list. Just curious if anyone has any ideas on how to fix this.
    Chris Dye
    http://www.kseriesparts.com

    #2
    It is probably using a SQL query that is generating a massive temporary table (bad for performance) whose size exceeds the normal temporary partition on your server. Our support can undo that restriction.
    David Hubbard
    CIO
    Miva
    [email protected]
    http://www.miva.com

    Comment


      #3
      I will spend some time trying to track down what query is the exact cause and see if I can fix the issue. I don't think there is a need to increase the partition size.
      Chris Dye
      http://www.kseriesparts.com

      Comment


        #4
        I tweaked how it was indexed and that seemed to help pick up the performance and now I am not getting the error.
        Chris Dye
        http://www.kseriesparts.com

        Comment

        Working...
        X