dbench results

Author: sean

A quick rundown of dbench results and hardware used. Results seem really bad for RAID systems, and it’s funny how a 5+ year old IDE RAID 5 card with 16/32MB RAM (I forget) can get ~double the performance of an $800 enterprise-level SAS / SATA controller with 512MB DDR2 RAM.

And so these should be taken with a large grain of salt.

T1.) Throughput 93.9068 MB/sec 200 procs
mercury (2x Xeon 5120 @ 1.86Ghz (4 cores total, 4096k L2 cache / 2 cores), 3GB RAM DDR2, CentOS 5.3)
/home# single 80GB Hitachi SATA drive

2.a) Throughput 19.9959 MB/sec 200 procs
atlas (Pentium D @ 3.0Ghz (2 cores total, 2048k L2 cache), 4GB RAM DDR2, Debian Lenny)
/home/likwid# LSI Logic 8480E RAID 5 w/ 3x 1TB WD Green series SATA drives

2.b)Throughput 15.4584 MB/sec 200 procs
atlas (Pentium D @ 3.0Ghz (2 cores total, 2048k L2 cache), 4GB RAM DDR2, Debian Lenny)
/# Linux Software RAID 2x 80GB SATA drives

3.a) Throughput 11.9199 MB/sec 200 procs
nep (Pentium 4 1.8 (256k L2 cache), 1024mb PC133 SDRAM)
/home/spetrow# 3ware Escalade 6200 RAID 1 w/ 2x WD 40GB IDE drives

3.b) Throughput 14.7577 MB/sec 200 procs
nep (Pentium 4 1.8 (256k L2 cache), 1024mb PC133 SDRAM)
/backup# single WD 320GB IDE drive

4.a) Throughput 40.4807 MB/sec 200 procs
z (Pentium 4 2.0 (512k L2 cache), 1280mb PC133 SDRAM)
/home/likwid# 3ware Escalade 7506-4LP RAID 5 w/ 3x WD 500GB IDE drives

4.b) Throughput 49.3065 MB/sec 200 procs
z (Pentium 4 2.0 (512k L2 cache), 1280mb PC133 SDRAM)
/# 3ware Escalade 6200 RAID 1 w/ 2x WD 40GB IDE drives

The intro is a bit weak and there are parts that I would change, but I digress.

This is the hook.

http://www.boxshots.org/style/5137

Midnight Madness

Author: sean

So I had a goal in mind — See what music I could make in ~15 minutes. Here is a clip of what I came up with:

midnight_madness_clip

Auto-detects databases, has the temp file and backup file locations separated, purple colored real-time output, only logs important output, md5sums into a text file for databases, every filename uniquely hashed with month, day, year, hour, minute, and second, timestamps everything, uses bzip2 compression for smallest file sizes.

#!/bin/bash

# vars – no trailing slash please
THEDATE=$(date +%m%d%y%H%M%S)
BACKUPDIR=’/backups/mysql’
TEMPDIR=’/backups/mysql/temp’
LOGFILE=”$TEMPDIR/info-$THEDATE.txt”
USER=root
PASSWORD=password
date > $LOGFILE

date

echo -e “\e[1;35m[ " $(date +%H:%M:%S) "-- Starting MySQL Backup Script v0.3 by Seanp2k ]\e[00m"

# magic
DATABASES=$(mysql --user=$USER --password=$PASSWORD -e "SHOW DATABASES;" | tr -d "| " | grep -v Database)

echo -e "\e[1;35m[ " $(date +%H:%M:%S) "-- Found" $(echo $DATABASES | wc -w) "databases:" $DATABASES "]\e[00m"

# loop -- dump and hash
for DB in $DATABASES; do

echo -en "\e[1;35m[ " $(date +%H:%M:%S)
echo -n " -- Processing " $DB ".."
mysqldump --user=$USER --password=$PASSWORD --databases $DB > $TEMPDIR/$DB-$THEDATE.sql
echo -n "..md5sum..."
md5sum $TEMPDIR/$DB-$THEDATE.sql >> $LOGFILE
echo -e "Done ]\e[00m"
done

# compress and clean
echo -e "\e[1;35m[ " $(date +%H:%M:%S) "-- Creating Archive " $BACKUPDIR/mysql-THEDATE.tar.bz2 "]\e[00m"
time tar -cvvjf $BACKUPDIR/mysql-$THEDATE.tar.bz2 $TEMPDIR/*.sql $TEMPDIR/info-$THEDATE.txt
rm -rf $TEMPDIR/*.sql $TEMPDIR/info-$THEDATE.txt
date
echo -e "\e[1;35m[ " $(date +%H:%M:%S) "-- Finished ]\e[00m”

Dreamhost rocks bro!

Author: sean

This webpage is not available.

The webpage at http://www.dreamhost.com/ might be temporarily down or it may have moved permanently to a new web address.

More information on this error
Below is the original error message

Error 320 (net::ERR_INVALID_RESPONSE): Unknown error.