Category Archives: FreeBSD

Production MySQL performance tuning

For the past 9 years I’ve been working almost exclusively with MySQL (with a little PostgreSQL thrown in) and while I don’t do nearly as much DBA work these days, I still find myself troubleshooting a query or tuning my.cnf. … Continue reading

Posted in Database, FreeBSD, Linux, MySQL, Systems Administration | Comments Off on Production MySQL performance tuning

Comparing Amazon EC2 with VPS and dedicated hosting

I’ve been reading all the great things about Amazon EC2 (or Elastic Compute Cloud) and lots of pricing comparisons with VPS and dedicated hosting. I finally got an EC2 account and tinkered a bit and there’s a big difference between … Continue reading

Posted in Database, FreeBSD, Linux, MySQL, Systems Administration | 9 Comments

Trafeoffs of aggressive filesystem partitioning

Most systems administrators will tell you it’s important to partition your install into anywhere from 4-7 discrete patitions (or slices if you’re in the BSD camp). While I think it’s good advice in certain cases, the headaches of mis-guessing disk … Continue reading

Posted in FreeBSD, Linux, Systems Administration | 2 Comments