Torbonium.com Blogs

Very concrete and easy-to-follow examples

http://hackmysql.com/documents

and also this one

http://20bits.com/articles/10-tips-for-optimizing-mysql-queries-that-dont-suck/

and

http://www.mysqlperformanceblog.com/

to check a mounted drive

telinit 1 # single user mode, closes all programs + network
mount -o remount,ro / # remount read only
fsck -f /dev/hd.. # run the checker
or: e2fsck -f /dev/hd..
mount -o remount,rw / # read-write again.
runlevel # see the current/previous runlevel
telinit 3 # use the previous runlevel in this command

badblocks -s -v -w /dev/hdd1

BETTER:

e2fsck -c -c -k -f -v -p /dev/hdd1

The halo of stars that envelops the Milky Way galaxy is like a river delta criss-crossed by stellar streams large and small, according to new data from the Sloan Digital Sky Survey (SDSS-II). While the largest rivers of this delta have been mapped out over the last decade, analysis of the new SDSS-II map shows that smaller streams can be found throughout the stellar halo, said Kevin Schlaufman, a graduate student at the University of California at Santa Cruz.

http://www.sdss.org/news/releases/20080816.segue_final.html

Astronomers have discovered nearly a dozen new stellar rivers—strings of moving stars—over the disk of the Milky Way.

http://www.sciam.com/gallery_directory.cfm?photo_id=E151952B-E214-2082-C35253ACF156A155

QuickList: Kernel Upgrade for Gentoo

# uname -a
Linux mythtv 2.6.23-gentoo #2 PREEMPT Tue Oct 23 12:57:42 PDT 2007 i686 Intel(R) Celeron(TM) CPU 1300MHz GenuineIntel GNU/Linux

# eselect kernel list

# eselect kernel set 4

# cd /usr/src/linux

[copy over your previous .config file from the previous kernel compile ]

# cp /usr/src/linux-2.6.23-gentoo-r2/.config

# make oldconfig && make prepare

[ answer all questions using default ]

# lspci

# cat /proc/cpuinfo

# make menuconfig

[ answer all questions using known hardware values from lspci and cpuinfo ]

# make

# make modules_install

# mount /boot

# cp arch/i386/boot/bzimage /boot/kernel-2.6.25-r8-2008-09-19

(these next two are optional - .config stores the options used to create the kernel, and System.map stores the hardware info (?) )

# cp .config /boot/config-2008-09-19

# cp System.map /boot/system-2008-09-19

# nano /boot/grub/grub.conf

[add in an entry near the top pointing to the new kernel file, using a previous entry]

# reboot