{"id":1735,"date":"2010-02-12T04:41:59","date_gmt":"2010-02-12T11:41:59","guid":{"rendered":"http:\/\/arcanius.silverfir.net\/blog\/?p=1735"},"modified":"2010-02-12T04:50:43","modified_gmt":"2010-02-12T11:50:43","slug":"blog-optimization","status":"publish","type":"post","link":"https:\/\/arcanius.silverfir.net\/blog\/blog-optimization\/","title":{"rendered":"Blog Optimization"},"content":{"rendered":"

In the last two days, I<\/p>\n

    \n
  1. Changed my blog’s MySQL tables storage engines from the MyISAM to InnoDB<\/li>\n
  2. Installed the WordPress Memcache Plugin<\/a> to mimimize database queries (16-25 queries reduced to 2-7)<\/li>\n
  3. Installed APC<\/a> (Alternative PHP Cache) to reduce PHP bytecode compilation overhead. As a result, all PHP sites on mimimus should be faster.<\/li>\n<\/ol>\n

    In addition, I did some general cleaning up and upgrading of software on minimus and nexus.<\/p>\n

    Altogether, these changes reduce the typical Checksum Arcanius page load from 2.5-3.5 seconds to 0.5-1.5 seconds, a 2-7x improvement.<\/p>\n

    These are very easy steps to take — I would suggest them to anyone running WordPress. Step-by-step directions follow (assuming Ubuntu Linux):<\/p>\n

      \n
    1. For each table in your blog’s database, execute the following SQL via a mysql client instance, phpMyAdmin, etc:
      \nALTER TABLE <tablename> ENGINE = InnoDB;<\/li>\n
    2. Install memcache:
      \nsudo apt-get install memcache<\/li>\n
    3. Download the WordPress Memcache Plugin<\/a> and place it in your wp-content directory. That is all you have to do to get memcache support in WordPress!<\/li>\n
    4. Install APC:
      \nsudo apt-get install php-apc<\/li>\n
    5. Restart Apache:
      \nsudo \/etc\/init.d\/apache2 restart<\/li>\n<\/ol>\n

      Very simple steps with a very high payoff.<\/p>\n","protected":false},"excerpt":{"rendered":"

      In the last two days, I Changed my blog’s MySQL tables storage engines from the MyISAM to InnoDB Installed the WordPress Memcache Plugin to mimimize database queries (16-25 queries reduced to 2-7) Installed APC (Alternative PHP Cache) to reduce PHP bytecode compilation overhead. As a result, all PHP sites on mimimus should be faster. In […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[12,8],"class_list":["post-1735","post","type-post","status-publish","format-standard","hentry","category-everything","tag-silverfir","tag-technology"],"_links":{"self":[{"href":"https:\/\/arcanius.silverfir.net\/blog\/wp-json\/wp\/v2\/posts\/1735","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arcanius.silverfir.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arcanius.silverfir.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arcanius.silverfir.net\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/arcanius.silverfir.net\/blog\/wp-json\/wp\/v2\/comments?post=1735"}],"version-history":[{"count":4,"href":"https:\/\/arcanius.silverfir.net\/blog\/wp-json\/wp\/v2\/posts\/1735\/revisions"}],"predecessor-version":[{"id":1738,"href":"https:\/\/arcanius.silverfir.net\/blog\/wp-json\/wp\/v2\/posts\/1735\/revisions\/1738"}],"wp:attachment":[{"href":"https:\/\/arcanius.silverfir.net\/blog\/wp-json\/wp\/v2\/media?parent=1735"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arcanius.silverfir.net\/blog\/wp-json\/wp\/v2\/categories?post=1735"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arcanius.silverfir.net\/blog\/wp-json\/wp\/v2\/tags?post=1735"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}