wesley tanaka


Drupal 5 system table performance


Every page view in drupal runs this query:

SELECT name, filename, throttle FROM {system} WHERE type = 'module' AND status = 1 ORDER BY weight ASC, filename ASC

Adding a key

ALTER TABLE {system} add key wtanaka_modulelist(type(6),status,weight,filename);

seems like it should help in theory. The explain changes from this full table scan with filesort:

Speeding up performance of Drupal 6 themes that call l()


CVS Drupal 6's l() function calls check_url every time it gets called, which is sort of slow. I'm not totally sure why -- that kind of cleaning should be handled inside url() (and it looks like it already is). But I'm not confident enough to get rid of it in my l() backport module.

Database index for Drupal's Who's New Block


Trying to speed up user_block's block #2 (Who's New) which currently uses a query that needs a filesort. Although the "status" column can only be 0 or 1, the query is expressed as status != 0 -- I think someone expects the status column to have more possible values in the future.

poEdit and Drupal's Locale Export


Just downloaded poEdit onto the computer of someone who is going to help me with some translations. However, when I tried to export a .po language file from Drupal (5.1) and open it in poEdit, I got an error message that said:

Couldn't load file xxx.po, it is probably corrupted.

The details added:

Broken catalog file: singular form msgstr used together with msgid_plural

Looking through the file, I found that it contained blocks of lines like:

ubuntu live cd unionfs and tmpfs


Been reading about tmpfs and unionfs to try to get an Ubuntu live CD to take advantage of hard disk space that might be available when an Ubuntu live CD boots up.

It's possible to increase the size of the /tmp filesystem by remounting it with something like

Ubuntu Edgy Eft (6.10) flash plugin


In the grand tradition of eating your own dog food, I've started using the live CD that my uncle is preparing for my grandparents. The first thing I noticed was that the flash plugin was missing. First I tried enabling "multiverse" and installing it into my live CD image using apt-get. It wanted to grab an old version 7 flash player, so I aborted and tried enabling "edgy-backports" and installing again. That time, it failed with some kind of md5sum mismatch error.

Gnome Clock Applet Display Bug


image of gnome clock applet formatting bug.  clock reads 00:4

what is this, amateur night?  =)

Wikipedia Unblocked?


Wikipedia (both en.wikipedia.org and zh.wikipedia.org) is unblocked for me at the moment.  Just a fluke, or will it last?

/usr/share/zoneinfo/right and /usr/share/zoneinfo/posix


The timezone files in /usr/share/zoneinfo/posix seem to be identical to the ones in /usr/share/zoneinfo on my computer. The ones in the "right" directory are different.  They're supposed to be the same thing, but containing information about the (so far 23) leap seconds that have been applied.

fvwm fedora package


There seems to be an FVWM package for fedora now, yay!

Syndicate content
by Wesley Tanaka