Posts in category General
Speeding up webapps
Some quick notes on useful apps for speeding up webapps. I’ve been working on one application that was suffering some performance issues and needed immediate help. So, with a combination of the following three apps and some hours of configuration tuning, I have the page loads down from 10 seconds to 2 seconds. Not too bad. Still more [...]
JFS and RHEL5
Quick one here; If you’re thinking to yourself “why can’t I make the MySQL data partition JFS on my RHEL5 server…” here’s a good how to: http://phaq.phunsites.net/2008/02/04/enabling-reiserfs-xfs-jfs-on-redhat-enterprise-linux/
Is this RPM 32bit or 64bit?
Simple question with a simple answer. Let’s say you’re on Redhat 4 or 5 and you need to know if an installed RPM is 32bit or 64bit…
shell> rpm -q --qf '%{NAME}-%{VERSION}(%{ARCH})\n' libaio
libaio-0.3.107(x86_64)
When to tune query cache settings
I saw some bad utilization of the query cache on one of my clusters the other day. I haven’t tuned the cache since installing the standard cnf file so let’s take the following usage graph that is output by Monolith.
Queries not cached: 40,000
Queries in cache: 250
Queries not cached: 7500
Queries in cache: 200
In the first ima [...]
Basic requirements of production data...
I just need to get some basics off of my chest here, it’s by no means a full list but it’s the most basic list I can think of to start with, and it’s basic because I am surprised by some of the slop I’ve seen in production environments.
1. Highly available server clusters – this is different than load balancing [...]
For the love of god please use the fo...
Let’s begin by assuming you have a server that runs MySQL and lots and lots of traffic flows through it everyday, let’s say… something like 50% of the size of the partition that the mysql binary logs are written to is on, then we will assume the binary log is turned on. Then we assume that expire_logs_days is not set.
What [...]
Certified
I passed the MySQL 5.0 DBA I and II certification tests today with very nice results. Just figured I’d post that so it’s verifiable that I’m not entirely spewing nonsense and general rabble. Today is a good day, and I will celebrate with the finest wines, and choicest of meats.
Exam Date: Monday, January 28, 2008 at 9 [...]
MySQL Competency
Here’s something I wrote up a while back for basic MySQL knowledge. MySQL Competency
This is also a useful list of interview questions for potential hires. DBA Interview Questions
Got an error reading communication pa...
If you look at your error log file for MySQL you’ll inevitably see the warning: “got an error reading communication packets”. The common solution is to increase the max_allowed_packet size.
I’ve seen this set as high as 1GB but typically the problem is alleviated by running it as max_allowed_packet=64M. If you set th [...]
