How to improve Wordpress performance

I’ve been looking for ways to improve the performance of my web site. Now that the biggest hurdle (MySQL) has seen dramatic improvements on FreeBSD (see article here), the only other hurdle really is PHP.

With a few quick Google searches, I found this article. The author details several of the tools needed to improve Wordpress performance, but the one in general that helps seems to be eaccelerator, a PHP cacheing extension. I’ve noticed a dramatic improvement in performance so far. So what do you think? Is my site any faster?

A few updates…

No, I didn’t fall off a cliff. Been busy with lots of stuff:

  • Passed the CCDP ARCH test and became a CCDP on April 25th!
  • Lots of house remodeling projects
  • Working on my final Cisco test (for now : ), the MPLS exam
  • Various other sundries

On the FreeBSD front, I found an old 250GB SATA drive and installed it in my current rig as the only drive (just to be sure I don’t screw something up). Not surprisingly, rebuilding the kernel and world with the latest 7.2 Release is quite snappy as compared to the Thinkpad T40. I was pleased that the Nvidia driver in ports worked without a hitch though it has no 3D acceleration whatsoever. For that you need Nouveau. I went my usual install route: install the minimal FreeBSD distribution, build world and build kernel, build Xorg from ports (including mouse, keyboard, Nvidia driver, and vesa driver for backup) with HAL support, build some sort of window manager (Fluxbox is my current favorite), install a shell (I’m torn between bash and zsh), and install Firefox 3. The entire process took about an hour and a half.

All of my hardware either worked out of the box or worked after a few tweaks but I used the i386 version of FreeBSD, not the AMD64 version. Before I built HAL, I had to use a PS/2 keyboard in order to actually install. Either I missed something or USB hotplug support isn’t there out of the box and needs to be added to rc.conf. I was pleasantly surprised to see that my Blackberry was recognized when I plugged it in. It didn’t automount or anything but it was neat to see it get recognized. I’ve yet to get it to work, but there is a ports version of barry available. Barry is a little rough around the edges but I was able to back up my Blackberry Curve 8320 to my Linux box with it.

It seems like FreeBSD is maturing and quite rapidly. Now that VirtualBox is coming for FreeBSD, the only barrier left is either getting a native 64-bit Flash plugin/player or for Gnash to mature rapidly. I tried Gnash on i386 FreeBSD and it works, but only part of the time.

I still watch with a bit of wonder and amazement at the effort that goes into an Open Source operating system and applications. That the developers can get their projects working with little or no support from hardware vendors is nothing short of amazing.

FreeBSD 7 on a Thinkpad T40 update

Not too long ago I wrote a how-to article on how to get FreeBSD 7.0 working on my IBM Thinkpad T40. Among other things, I omitted a section on getting proper video drivers working. The graphics chip is an ATI RV250 (Mobility 9000). This means the driver you should use is the ‘radeon’ driver. Use ‘pciconf -lv |grep ATI‘ to see which chip you’ve got. After toiling a bit with it, I figured out how to get the Open Source ATI drivers working.

Because I want to generally keep my systems pretty current, I recently installed FreeBSD 7.1 on my T40. It’s important to know that the FreeBSD project generally breaks up development into three separate releases, namely CURRENT, STABLE, and RELEASE, in order of most bleeding edge to most stable. After building Xorg 1.6.0, I tried to start an X session just to see if I would get the ugly TWM desktop. To my surprise I got just a black screen but that was it. Even more surprising was that the usual “three finger salute” (ctrl + alt + backspace) didn’t kill my X session. I then hit ‘alt + F2′ to log into another vty and manually kill off X. Here’s where the fun began. It killed more than X; it locked my entire machine up. I continued futzing with my xorg.conf, kernel modules, and locking my system up for a good hour. I then threw in the towel and wound up asking a friend who’s a FreeBSD developer WTF was going on. I learned a few interesting facts:

  • The DRM code in 7.1 was more than 2 years old
  • It is not necessary to manually load or pre-load any kernel modules for video
  • X.org should work well with ATI graphics cards (but the amd64 release may not work) since the ATI driver model has had substantial structural changes to it.

On the first point, there’s two ways around the old code: Either download/burn/install the FreeBSD 7.2 release candidate or rebuild world. Since I’m a glutton for punishment, I decided to rebuild world. It’s not actually that hard, just time consuming. Use the ‘csup’ utility to grab the entire CVS source tree from your nearest csup server and follow the directions listed here to rebuild your system using the RELENG_7 tree.

The second point is easy enough. There’s no need to add anything to your /boot/loader.conf file in order to get X working. X.org will load any necessary kernel modules when you type ‘startx‘. As an interesting aside, I actually locked my system up when attempting the unload the radeon.ko kernel module when I had learned that preloading isn’t necessary. Doh!

Once you’ve rebuilt your system and are running 7.2-STABLE, it probably wouldn’t be a bad idea to rebuild your installed ports. This isn’t necessary per se since X.org should work without even building a config file, but it is a good step, just to make sure everything is up to date. I use the portupgrade utility located in /usr/ports/ports-mgmt/ with the following: portupgrade -aRr. That should upgrade all outdated ports recursively as well as recursively rebuilding dependencies.

I’ll expand on the last point a bit. ATI has been much more generous with contributing documentation to the Open Source community than Nvidia. In fact, Nvidia hasn’t contributed anything other than a proprietary driver for Linux and FreeBSD, though there’s a project called Nouveau which aims to build an Open Source Nvidia driver. Because of this, FreeBSD has an Open Source ATI driver (/usr/ports/x11-drivers/xf86-video-radeonhd and usr/ports/x11-drivers/xf86-video-ati) and using the old proprietary fglrx driver is no longer necessary. There’s one hiccup to this though. The driver has to be re-worked every time a new ATI chip comes out. To solve this, ATI is moving towards the same unified driver model Nvidia has used for years and taking it a step further. They now have an Open Source BIOS abstraction layer called ATOMBios. The idea is to make it easier to more rapidly deploy drivers for new graphics cards. Read all about that in this article. Bravo ATI!

By the time you finish reading this, your ports should be up to date and you should be able to use hardware accelerated ATI drivers on your Thinkpad. I’m running XFCE4 on my Thinkpad and it’s causing me to reevaluate the old “FreeBSD vs. Linux” question. Maybe I’ll spend a little more time working on the other parts that I overlooked in my article.

Enjoy!

Fun with Sun Solaris 9

I know, I know… why am I using a proprietary Unix after singing the praises of Debian GNU/Linux and dumping Mac OS X? Why the heck not? I love tinkering and experimenting with stuff. Besides, it wasn’t terribly difficult to get Linux working on my Sun Ultra 1 Creator.

So why bother with proprietary Sun hardware at all? Because it’s CHEAP and loads of fun to tinker with. Since the dot com crash of 2000, there’s a plethora of Sun hardware to be found at very reasonable prices. My Ultra 1 Creator listed for $27,000 when it first came out in 1996 but I got it for FREE on Craigslist.

Since I got this machine free off Craigslist, and it did come with all the Solaris media (and then some), I have tinkered with it in several ways. When I first brought it home and booted it up, it had the 64-bit version of Solaris 9 on it. I’ve never really cared for Solaris (some call it Slowaris) so the first inclination was to install FreeBSD. I got that installed without any problems, including X.org, etc…  Yawn. Now on to Linux. My first inclination was to try Gentoo but I gave up on it since I couldn’t get the kernel to compile no matter what I tried.

Next I looked around to see which other Linux distros support UltraSPARC hardware. Since I’m particularly fond of Debian, I naturally jumped in that direction. Getting the current stable (Etch at that time) Debian CD to boot turned out to be a major drag since it would continually freeze when trying to load the SCSI driver, a known bug in the installer. For kicks, I decided to see if a network boot would get me where I wanted to be. Sure enough, after setting up a RARP and TFTP server, the installer went flawlessly when using the Debian “Testing” image.

But even that got boring. So now I decided to get Solaris installed again. Not only that, I want to get the 64-bit kernel booting. It turns out this is more of a challenge than I thought.

To begin, I put the Solaris 9 installation CD in the drive and boot up. If you’re wondering why I don’t use Solaris 10, that’s because it isn’t supported on such old hardware. The first hiccup I run into is the screen warning me that a 64-bit OS is installed but that the installer will boot into the 32-bit SunOS kernel. Not a big problem. When I see the “Initializing Memory” screen, I hit Stop + A to drop to an Open Boot PROM screen. At the “ok>” screen, I type “boot cdrom kernel/sparcv9/unix” and hit enter. Sure enough, it boots the 64-bit kernel.

Now for the next hiccup. When the installer starts, you eventually wind up in a small xterm-ish console and it asks you if it can repartition the hard drive so it can place some temporary installer files on the hard disk. Most users of modern operating systems have come to expect that the OS will just ask you if it can erase what’s already there and move on. Not so with Solaris. It will warn you that it can’t partition enough space from the available free space on the drive. So now what?

I wound up bailing out of the installer with a Control + C and got dropped to a root prompt. Remembering another time I had to use a new disk in Solaris, I entered the format command to start that utility. I formatted the drive, gave it a label and rebooted. This time it worked. However, when I got to the section of the installer where you actually install the Solaris software, my CD drive starting acting up so I couldn’t complete the install. I’ll come back to it later I suppose. I guess free hardware comes with a price?

“Change” we can believe in??

Not bad for his first month in office. Hugo Chavez would be proud:

  • The Dow at a 10-year low.
  • A tax cheat running the IRS
  • Another tax cheat as the Chief of Staff
  • A trillion-dollar plus federal deficit
  • Over one-half of voters relieved of any federal tax liability
  • Government mandated limits on executive compensation
  • Three failed attempts and still no Commerce Secretary
  • Tom Daschle rides his free limo into the sunset - after paying taxes he evaded.
  • The White House performance czar turns out to be a tax cheat also
  • Lobbyists hired to work for the Obama Administration
  • The census gets politicized
  • Double government spending in one year
  • The word “freedom” fades into obscurity
  • Increasing home loan mortgage rates across the board
  • Millions of Americans made dependent on government
  • Moving unionization-by-intimidation forward
  • Welfare checks become “tax cuts.”
  • Illegal aliens free to work on taxpayer-funded “stimulus” projects
  • Welfare reform reversed, states ordered to increase welfare roles
  • Move to silence critical talk radio shows
  • Selling Senate seats
  • Obama books in religious sections of book stores
  • More government workers, not private sector jobs
  • A government bureaucracy to intrude on doctor/patient relationships
  • Stage set for medical services rationing
  • Annual welfare checks for middle income families

Hey, you voted for him and the media made him out to be a God even though the only thing he’s accomplished as an adult is writing two racist books. You get what you pay for. Thanks to Neal’s Nuze for the list.

Now that I have your attention, let’s compare the U.S. to Argentina

Installing Handbrake on Debian GNU/Linux

I don’t actually watch that many movies but occasionally I want to back them up or convert them to a more convenient format. To date, I’ve been using the excellent Handbrake utility on my PowerMac G5 for my video conversion needs. Since I waved goodbye, I now needed at least the same functionality on my Linux machine. Fortunately, Handbrake is open source and under GPL license so it also has a GTK-based Linux equivalent. To get it installed, you’ll need to edit your apt sources and add the following:

#Handbrake
deb http://www.debian-multimedia.org sid main

You’ll notice I specifically used the “sid” release. There is no “stable” prepackaged binary for Handbrake yet unless you’re on Ubuntu, so you have to specify sid. It works regardless so not to worry. With that line added, save the file and install:

$sudo apt-get update
$sudo apt-get install handbrake-gtk

It should install the requisite binaries without a hitch and add Handbrake to your menu under “Multimedia” if you’re using Gnome or XFCE (I don’t use KDE so I couldn’t tell ya). Here’s a screenshot from my machine for the ever-curious (click on the image to enlarge it):

Enjoy!

Installing the official Nvidia drivers on a Debian system

Since I’m doing the Linux thing, I’m going to start writing more informational articles describing handy tips that I feel are useful. If you read my last post, you’d know I’m now using a Debian GNU/Linux system that has an Nvidia video card.

Video has always been a bit of a sore spot in the Linux and Unix world. It wasn’t until the late 1980’s that Unix systems even had a graphical subsystem (XWindows, as it is still known). Even today, the hardest part of bringing up a useable Unix-based system is getting the video adapter to work with XWindows. Today, most systems use a fork called Xorg.

While it would seem that the only video card you can buy will either contain an Nvidia or ATI chip, that’s not entirely true. It is interesting (at least to someone like me) that Nvidia graphics cards are more often seen on Linux-based systems and ATI-based cards are more often seen in the BSD world (Free/Net/Open). Probably just a coincidence, but when I read forum posts, that’s what I tend to see. Since we’re talking about Linux in this article, let’s get down to the business of installing some accelerated drivers for our Nvidia-based card.

One of the first places to look is the Nvidia Driver Debian wiki. Per the wiki, there are two ways to install the driver. The first method is the Debian method, which, while it may be easier, it also may be lagging behind driver versions. I chose the second method, which involves downloading the driver binary from Nvidia’s website and manually installing it. There are a few caveats, namely that it’s possible to screw up the install, not work, or require a reinstall if you upgrade your kernel since the driver compiles a kernel module. I didn’t run into any installation problems but I would imagine that I’d have some difficulties if I upgraded my kernel. Nothing terrible to worry about though.

One thing to note is that driver availability for older Nvidia cards (made before 2005) is probably non-existant. So while you can probably get by using the generic VESA driver, you probably will no longer be able to use the latest Nvidia driver and therefore the 3D acceleration. See this section on the Debian Nvidia wiki for more info.

First, download the driver from here: driver download. Do remember that this driver is a propriatary, closed source driver. If that offends you, you should probably stop here. My understanding is that there is an open source Nvidia driver on the way so if you don’t need 3D acceleration (obviously you haven’t tried Compiz Fusion), this article isn’t for you. I’m willing to bit the bullet and install a non-free driver for the sake of fully utilizing my hardware and will certainly move to the open source version when it shows up.

Next, you’ll want to download your kernel source. Actually, I got by just getting the header files. Open your favorite terminal and type ‘sudo apt-get install linux-headers-2.6-686‘. If you don’t have the sudo program installed (and you SHOULD), just su to root and issue the apt-get command again without the sudo part. I’m assuming you’re running a 2.6 kernel on 686 hardware. Most people should no longer be running an i386 kernel.

Now for the fun part. You might want to write this down or open this article on another machine. To install the driver, you need to fully exit your X session. No, you can’t open a terminal session from GDM. I’m particularly lazy, so I just rebooted into single user mode. Either way, you need to completely get out of X and be at a root prompt. Change to the directory where you downloaded the driver and chmod it to 755 if needed. Now run it, ignoring the runlevel error. Accept the license. You may get an error about the version of GCC installed on your system not matching what was used to compile the kernel. Do NOT just ignore this. Exit the installer. In my case, GCC 4.1 was used to compile my kernel so I just did a ‘#apt-get install gcc-4.1‘. Next, you’ll want to export the location, so first do a ‘which gcc-4.1‘. In my case, I did a ‘export CC=/usr/bin/gcc-4.1‘. Now rerun the installer. You should be good to go from here. The installer will build a custom kernel module, back up and modify your X config, and tell you if things have completed successfully. If that’s the case, exit the installer and reboot!

Once I was back up I did a test by running Doom3 and was happily surprised to see it come right up. I have to admit, it’s nice to run a system with no proprietary drivers, but I can’t complain that Nvidia is gracious enough to provide a driver. After all, they don’t have to since the majority of their customers are on a Windows system and developing and testing a Linux driver takes resources from that. So I say kudos to Nvidia for making a solid driver that installs easily and just works!

The long goodbye…

As anyone who has known me knows, I’m definitely a Mac user. I’ve used Apple hardware on and off since the Apple II days. The first Mac I actually bought, however, was a G4 tower. Most of the time before that was spent hating Apple and suffering in a Windows world.

This went on until a good friend took the time to show me what his G3 could actually do. Of course, back then, Mac OS 8 was the de facto OS and Mac OS X was still a research project. I initially resisted but started liking what I saw enough to say “I want one!”. It was then that I bought my first Macintosh, a 400 Mhz PowerPC G4 PowerMac. It came with 64 MB of RAM, an 2x AGP ATI video card with 16 MB of RAM and a whopping 20 GB hard drive. It also came with the venerable 400 MHz PowerPC 7400 (G4) processor with the AltiVec “Velocity Engine” vector processing unit and 1 MB of backside cache. This CPU smoked any Intel Pentium 3 at the time and was classified by the U.S. Government as a supercomputer since it was capable of at least a Gigaflop of performance. Another nifty component this machine has is a gigabit Ethernet interface. No other PC I can remember at that time (we’re talking late 1999, early 2000) had that and most didn’t have an Ethernet interface (56k was still the bomb-diggity). Needless to say, for $1599, this was a very nice Macintosh.

I endured many months of ridicule but really enjoyed my G4. One very interesting point was that the Playstation emulator, Connectix Virtual Game Station, actually ran Playstation games on my G4 faster than a Playstation! I continued to love my G4 until I decided it was time to go back to school.

At that point, I got my first Apple notebook, the Powerbook G4 Titanium 867. It basically had double the specs of the PowerMac. I wound up selling my PowerMac to a friend that needed a new machine which I thoroughly regret to this day. I had been running Mac OS X 10.0, then 10.1 on the PowerMac with Mac OS 9 “Classic” alongside it. The PowerBook came with Mac OS X 10.2 “Jaguar” and it was a rather large bump in speed from earlier releases as well as actually having software to use.

Shortly before graduation in 2004 I bought a shiny new PowerMac G5 (Dual 2.0) as well as a 23″ Apple flat panel (graduation present to myself of course!). It had easily six to ten times the speed of my notebook and is what I currently still have. Not planning on selling it and making the same mistake twice!

Since that time, a subtle but continuous shift has been going on with the direction Apple has taken its business. Back when Mac OS X debuted, Apple was very gung-ho about it’s core business: selling Macs. It also had a miniscule share of the overall PC market, so it was still playing catch up after the success of the iMac line. Development of new hardware and Mac OS X happened at a frenzied pace, as evidenced by all the announcements of cool new technology. This continued to happen until around 2006, when the iPod really started becoming a large part of Apple’s revenue. Then the iPhone debuted in 2007. And there was the Apple TV. Suddenly, Apple is no longer a PC maker and is instead a consumer electronics maker. They even dropped “Computer” from their name.

I started noticing many changes to what were Apple’s core business: Macs and Mac OS X. Now there’s nothing but tie-ins to the iTunes store or some other non-PC product or service. New notebooks now have HDCP built in to appease Hollywood in its neverending quest to make water not wet. Everything Apple does surrounds the iPod line or the iPhone now. People say it’s supposed to be a halo effect to get you to buy a Mac but I call bullshit on this one. If Apple can sell an iPhone to someone who just wants to make phone calls, they will. There’s no indication at the AT&T store that you should also own a Macintosh to get the best experience. Apple is now the new Sony: a consumer electronics behemoth that does much, but nothing very well in particular. Their OS is now comparable to Windows: a tiny portion of it is engineered to get stuff done and the rest is engineered to get in your way and wrest control of your computer from you. And resist as I could, I just couldn’t stay away. Until now.

For the past several months, I’ve been evaluating more than one Free/Open source operating system for use as a replacement. After lots of time spent on all three, I wound up settling on Debian GNU/Linux. Why? Because Debian is a very mature and actively developed distribution of Linux. I tried Ubuntu for a month and a half and it just feels like it’s got more “stuff” than I need. I presume this is for handholding new Linux users. It would appear that I’m not the only one getting a little more than sick of the way Apple treats its power users. Two “A-list” bloggers (gawd I hate that word), Mark Pilgrim and Cory Doctorow, are also former Mac users and for very much the same reasons I am (only they did it 3 years ago).

I’ve used Linux plenty in the past, first installing Red Hat 5.1 on an old 486 back in the day and even managing to get X windows to bend to my will. Today’s Linux distros are nothing like that. Everything just kind of works and the stuff that doesn’t isn’t so hard to fix. I would place the hardware support in Linux about where Windows 98 was: if it works, it works, but if not, prepare to get dirty. To that end, I built a pretty nice box:

* Intel Quad Core Q6600 CPU

* 2 GB PC-8500 DDR 2 RAM

* 1 TB Seagate SATA hard disk

* Nvidia GeForce 9500 GT video card with 1GB RAM

* Gigabyte EP45-DS3l motherboard

* Logitech wireless mouse, wired keyboard

* Repurposed LaCie Big Disk Extreme 500GB Firewire 800 drive

* PCI express Firewire 800 card

* Dual layer DVD burner

By today’s standards, these specs are probably a mid-range Windows Vista machine. Yet, by running Debian, I get spectacular performance, no annoying product tie-ins, and best of all, my operating system does what I want and nothing more (yes, that’s you, DRM). In layman’s terms, this means I control my computer at all times instead of being forced to prop up an entire industry dedicated to preventing me from doing what I want with the stuff I’ve got. For those of you with entirely too much time (hey, you’ve made it this far), read here about what goes into ensuring you can’t “pirate” content on Windows Vista.

As a parting note, it was nice to build a PC again after a 4 year hiatus. I got all that hardware for less than the cost of a Mac mini and it’s certainly more capable. I was rather shocked at just how cheap and powerful PC hardware has become as of late. Since I didn’t have to buy a PC and pay the Windows tax, I also saved more cash. And in these times, that’s certaintly a good thing. Next time I’ll post a list of what apps I’m using so any Linux enthusiasts out there can compare and contrast.

So long Apple, it was fun while you were a PC company.

Getting FreeBSD 7.0 running on an IBM Thinkpad T40

I’ve been experimenting with various operating systems on my Thinkpad and have been trying to get a Unix-like system on there. I’ve played with Ubuntu but the battery life is abysmal. I can get around 3 hours with Windows XP installed and barely half that with Ubuntu 8.10 installed.

Just for grins, I decided to see how difficult it would be to get FreeBSD 7.0 working on this machine. After I was done, I decided I’d share the knowledge:

Here’s how I did it

Mastering IPTables

Two cool articles up on Linuxjournal.com regarding IPTables, the built-in firewall for Linux. I’ve struggled to learn how IPTables works (especially after using the excellent OpenBSD pf firewall) but these videos really explain IPTables well:

Part 1

Part 2

I would encourage you to watch both videos if you use Linux, especially if your system is exposed to the Internet (not behind a home router).