Brad Fitzpatrick (bradfitz) wrote in lj_dev,
Brad Fitzpatrick
bradfitz
lj_dev

Max keyfile length

Anybody know what's up with MySQL and its "Max keyfile length"? We were having table handler 136 errors from the log table earlier because there wasn't enough space free in the index file. Not on the filesystem.

Look at this and go search for "./log.MYI". See how full it is? Hell, I'll paste the relevant table:

./log.MYI MyISAM file: ./log.MYI Record format: Fixed length Character set: latin1 (8) File-version: 1 Creation time: 2000-11-09 16:49:15 Recover time: 2001-03-25 22:27:09 Status: open,changed Auto increment key: 1 Last value: 2529102 Data records: 2377474 Deleted blocks: 0 Datafile parts: 2377474 Deleted data: 0 Datafile pointer (bytes): 4 Keyfile pointer (bytes): 2 Datafile length: 97476434 Keyfile length: 57940992 Max datafile length: 176093659134 Max keyfile length: 67107839 Recordlength: 41 table description: Key Start Len Index Type Rec/key Root Blocksize 1 26 4 unique unsigned long 1 19351552 1024 2 38 2 multip. short prefix 44834 24294400 1024 40 1 int8 8367 41 1 int8 950 3 2 4 multip. unsigned long prefix 39 35307520 1024 38 2 short 31 40 1 int8 16 41 1 int8 2 4 10 8 multip. ulonglong prefix NULL 5 43405312 1024 5 18 8 multip. ulonglong prefix NULL 1 57480192 1024

I think when I did a repair table on it (even though it reported no errors), it changed something (because it works now), and updated the "Recover time"

Subscribe
  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded 

  • 8 comments