1. MySQL: Disable DNS Lookups

    Posted on in Software

    Powered By MySQLIn a small environment, there's very little reason to rely on DNS resolution inside MySQL. You can disable it by adding skip-name-resolve to your my.cnf or by using the --skip-name-resolve command line argument.

    Remember that if you disable DNS lookups, you will need to set permissions using IP addresses …

  2. Cisco: Time-based, Inbound Rate Limiting

    Posted on in Networking

    Slaptijack reader Raj is looking for a way to limit inbound traffic on his switch ports based on the time of day. Specifically, he wants to restrict speed to 256 Kbps between 9 AM and 9 PM, and allow up to 1 Mbps the rest of the day. I've done …

  3. Installing Unison 2.27.57 via MacPorts

    Posted on in System Administration

    MacPorts LogoI've mentioned before that I use Unison to keep a few important directories synchronized between my various workstations and file server. I made the switch to Ubuntu 10.04 LTS recently, and started using its unison 2.27.57 package. This breaks all of my Macs that use unison 2 …

  4. ab Results Before and After Server Move

    Posted on in System Administration

    Electronic Eye

    Behold, the benefits of virtualization!

    I spent most of the evening preparing to move a few websites. I decided to do some benchmarking just to see what sort of improvement I was getting from the new server setup. Although the old server didn't feel slow when browsing sites, the results …

  5. Ubuntu: Installing VMware Tools in 10.04 LTS

    Posted on in System Administration

    Ubuntu Circle of Friends Logo (Orange on White)Although this process is well documented on the Ubuntu community site, I decided to take notes of the exact steps that I took so that I wouldn't have to fumble through that long document next time. I'm installing the tools in a clean install of Ubuntu 10.04.2 LTS …

  6. WordPress: Tired of Dashes and Quotes Being Rewritten?

    Posted on in Software

    Using WordPress to write a technical blog can be occasionally frustrating. WordPress uses the wptexturize() function to rewrite certain ASCII character combinations into HTML entities. Although this may generally be a "good thing," it's really annoying on technical blogs where two dashes is not an em dash.

    To disable this …

  7. MySQL Multiple-Column Indexes: Order Matters

    Posted on in Programming

    Powered By MySQLThis will just be a short reminder. If you're planning to create multiple-column indexes in MySQL, remember that the order of the columns matters. As the MySQL documentation points out, any "leftmost prefix of the index can be used." This means that the index can be used for any number …

Slaptijack's Koding Kraken