making bbPress (and WordPress) work better!

Another Performance Regression in WordPress 3 Future

MySQL 5 is proven to be slower than MySQL 4, and WordPress doesn’t require any MySQL 5 specific features to operate.

But they announced today that WordPress 3.2 will require MySQL 5.0.15

MySQL 5 has performance improvments mostly for InnoDB which WordPress does not use. MySQL 4 is faster at MyISAM which the is the more common db format (and used by WP).

Also, they are insisting that servers run PHP 5.2 minimum for WP 3.2

While PHP 5.2 is faster than PHP 4.4 (and PHP 5.3 is measurably faster than 5.2) it’s not very hard at all to support PHP 4.4 In fact I’m sure they are going to have to go out of their way to force PHP 5 to be required by actually REMOVING simple code that helps PHP 4.4 already in WP.

So why not keep software flexible when it’s easy? The reality is this is probably to help keep reports of security problems with WordPress down by forcing people to keep their servers up to date.

Personally I don’t think that is WordPress’s business or responsibility but I guess people have a choice which software they want to use, especially when it’s free.

ps. You know what else just dawned on me – Matt has data on a million servers that run WordPress when they “phone home”. This doesn’t bother anyone?

8 responses

  1. You make it sound like WordPress is requiring users to only use those specific versions. Nothing is stopping people from using PHP 5.3 (I’d recommend it) or MySQL 5.1 (also recommended).

    WordPress also does not force you to only use MyISAM tables. The CREATE TABLE statements in WordPress don’t specify an ENGINE type, so it will use your server default. In most cases that is MyISAM. You can either switch the default type, or alter the ENGINE type on the tables after they are created.

    July 23, 2010 at 6:46 pm

    • Sorry I definitely didn’t mean only those versions, but those versions as minimums.

      Also, InnoDB is slower than MyISAM. Though I think it finally caught up in MySQL 5.5 – but that isn’t even available on most mainstream server control panels yet (ie. Cpanel) so you won’t find it too common, even next year.

      I guess I have much more of a problem with cutting out support for previous versions when it’s easy to support them vs. progress for progress’s sake.

      July 24, 2010 at 2:21 am

      • “InnoDB is slower than MyISAM” is a broad brush to paint with. There are several differences between the two and which one to use should take into account more details. In general I recommend InnoDB to people as a default because it is more likely to survive a crash (recovery abilities) and provides more features people coming from other DBs are used to (ACID, MVCC, foreign keys, etc.).

        Ease of support is subjective as well. Testing WordPress under the many different server combinations it supports is non-trivial, being able to dial that back while still supporting what more than 85% of the user base is already using helps make that a bit more reasonable.

        So many people are already running with these minimum requirements that for the vast majority of WP users (emphasis on users in this case, not developers) won’t need to change a thing.

        July 24, 2010 at 11:48 am

  2. Pingback: WordPress 3.2 requerirá MySQL 5 (¿se nos ha ido la olla?) | Ayuda WordPress

  3. Pingback: WordPress 3.2 requerirá MySQL 5 (¿se nos ha ido la olla?) | Todo bit

  4. Three years ago I wrote a pretty strong case for maintaining PHP4 support even though it was being abandoned by the PHP developers:

    What’s still true to this day is that I don’t feel like we’ve ever been held back on making things better for users by supporting PHP4.

    What’s changed is that the world has moved on and what was once a large percentage of users is now just a handful. Supporting older versions of PHP is not just a matter of syntax, it’s one of testing, and the cost of testing on multiple version of 4 and the highly-buggy early version of 5 just isn’t worth the overhead anymore, much like we don’t target IE6 or Netscape anymore.

    (Also technically I have data on 10 million servers. ;))

    July 25, 2010 at 11:49 am

  5. I feel very sturdy approximately it and would like to read more. If it’s OK, as you achieve extra extensive wisdom, would you thoughts adding more articles similar to this one with additional info? It will be extremely useful and useful for me and my friends.
    thanks for info

    February 12, 2011 at 10:49 pm

  6. Please do not take offense to my posting, but I really need your help!

    October 3, 2011 at 5:02 am

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s