Scott Francis Baker (muerte) wrote in lj_dev,
Scott Francis Baker
muerte
lj_dev

MyIsamPack

Does LiveJournal use any sort of compression on the database tables? I can't recall if Brad was using ISAM or MYISAM tables for the large text only tables... I was reading through the MySQL site and I found MyIsamPack which lets you compress your database tables. It's supposed to speed things up as well if you just do small selects. I'm looking for some "professional" (Read: Brad, Dormando, etc) suggestions regarding this. I may do it with some tables we have here at work as well.

It creates read-only tables which would be a problem for the bigger tables that are used everyday. But what about "LiveJournal Archives" stuff that's like a year or older. Something like that it would probably work pretty well.
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 

  • 1 comment