May 13th, 2003


A question or a suggestion

An introduction seems to be in order. Well, I'm a coder, a developer, a hacker, a what-have-you, and have been for pretty much as long as I remember. While I've yet to do anything touching LJ code, I have lurked around here and some other communities for a while, making comments and suggestions when appropriate (and sometimes not, I'm sure).

As to the reason for this post, I noticed some HTML being stripped from the subject of a recent post on my journal. Would it be a problem (this has possibly been discussed and decided before; I wouldn't know) to modify so that the line reading my $subject_allow = [qw[a b i u em strong cite]]; includes s and strike as well?

If it's not a problem, this could be the humble beginning of my sporadic LJ code-touching.
binary and a cookie to whoever notices
  • xb95

Switching to InnoDB in Daughter Sites.

Alright. I was doing a code update today for when I ran into some problems about being unable to allocate an itemid, which I tracked down to funky new code that uses a counter table, which tracked me back to the CVS log that mentions moving to InnoDB. Alright. So I dug out more CVS log entries and diffs about the changes to the tables themselves. Then I tracked over to MySQL's online documentation and got some info on converting tables from MYISAM to InnoDB and figured out that you theoretically just need to do:


But that's just theoretical. Also, some auto_increment columns need to be changed, et cetera. How did LJ do this? Is there a script somewhere that automatically does this change? bin/upgrading/ doesn't notice the changes and doesn't suggest that I do anything, and I don't want to end up losing lots of data in this process.


Also, I propose that large changes like this go into this community to keep people aware of things like this. It would have saved me a lot of time and effort. Thanks.