Brad Fitzpatrick (bradfitz) wrote in lj_dev,
Brad Fitzpatrick

database worries

we really need to get the new memory for stan soon (they shipped it today I think, finally). once stan's up and can handle web requests, i want to get kenny being a read-only slave db server. it has nice scsi disks, and is the fastest of all the machines. it'll still do and also, and be the primary place where i login, tweak code and administer things.

cartman's the main bottleneck lately... database is locked way too often. the load's about 8.... CPU pegged. too many reads and writes.

also, I need info from you guys about the large file support.... that's going to be an issue pretty soon here:

[root@lj-cartman livejournal]# ls -l | sort -k 5 -n | tail -10
-rw-r--r-- 1 root root 49452684 Feb 26 17:54 logprop.MYD
-rw-r--r-- 1 root root 66414592 Feb 26 17:54 log.MYI
-rw-rw---- 1 root root 67756032 Feb 26 17:54 syncupdates.MYI
-rw-r--r-- 1 root root 67767457 Feb 26 17:54 talk.MYD
-rw-r--r-- 1 root root 76336137 Feb 26 17:54 log.MYD
-rw-r--r-- 1 root root 112238592 Feb 26 17:54 talk.MYI
-rw-r--r-- 1 root root 134941996 Oct 17 01:03 talkpost.MYD
-rw-r--r-- 1 root root 275162808 Feb 26 17:53 userpicblob.MYD
-rw-r--r-- 1 root root 434013316 Feb 26 17:54 talktext.MYD
-rw-r--r-- 1 root root 1,509,416,996 Feb 26 17:54 logtext.MYD

Cartman is linux 2.2.18, glibc-2.1.3, ext2fs. Can that do LFS?
Kenny is freebsd 4.2-stable.... Can that do LFS? I think it can.

  • Post a new comment


    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

    Your IP address will be recorded