Results 1 to 6 of 6
  1. #1

    PHP/MySQL -> memcached?

    What is the best way to improve PHP/MySQL sites? I'm building from nothing and I want to speed it up with some sort of caching system to reduce load on the server and page load time in general. Ideas?

  2. #2
    Join Date
    Aug 2005
    Location
    Durham, NC USA
    Posts
    195
    I'd look first at APC (Alternative PHP Cache). It's a bit easier to set up than memcached -- it's just a php extension. It really can help php performance though.
    Netmar Web Services - Reliable Web Hosting for 15 years
    Shared hosting, business hosting, domain name registration, and VMware virtual servers
    Specializing in Drupal hosting
    Call 866-363-8627 (toll-free) and ask about our Drupal accounts

  3. #3
    isnt memcahe faster since its memory based? i thought apc was just an opcode cacher?

  4. #4
    I'm running nginx + MySQL + php-cgi with Wordpress (Super Cache enabled) I took some heavy traffic over 3 days and the server didn't even lag and didn't even notice resources spiking uncontrollably.

  5. #5
    Join Date
    Aug 2005
    Location
    Durham, NC USA
    Posts
    195
    @Sammy89

    Actually, I think apc is actually the faster of the two(in most common use cases), but you're right in that it's an opcode cache. Memcache, OTOH, caches the results of queries and is a distributed cache, so a single cache can be used for multiple servers.

    Like I said, I'd start with apc just because it's simpler to set up, and this looks like a single server setup.

    Akin
    Netmar Web Services - Reliable Web Hosting for 15 years
    Shared hosting, business hosting, domain name registration, and VMware virtual servers
    Specializing in Drupal hosting
    Call 866-363-8627 (toll-free) and ask about our Drupal accounts

  6. #6
    Join Date
    Aug 2004
    Location
    Dallas, TX
    Posts
    3,507
    Memcached and APC are great. For the absolute easiest way to reduce load:
    yum install php-eaccelerator. Compiled versions of your PHP scripts are stored on disk. Load on busy PHP sites can drop 50% instantly.

    Evaluate your needs/what is slowing things down, the above is not a magical solution for all.
    Dallas Colocation by Incero, 8 years and counting!
    e: sales(at)incero(dot)com 855.217.COLO (2656)
    Colocation & Enterprise Servers, SATA/SAS/SSD, secure IPMI/KVM remote control, 100% U.S.A. Based Staff
    SSAE 16, SAS70, Redundant Power & Network, Fully Diverse Fiber

Similar Threads

  1. Replies: 2
    Last Post: 05-25-2010, 09:08 AM
  2. Dedicated mysql server with memcached
    By jcodemasters in forum Hosting Security and Technology
    Replies: 4
    Last Post: 09-20-2008, 03:48 PM
  3. Installer for php/mysql open source CMS and php/mysql coder needed
    By 0utlier in forum Employment / Job Offers
    Replies: 4
    Last Post: 03-11-2008, 03:24 PM
  4. Diff b/w Alternative PHP Cache and Memcached
    By grabmail in forum Programming Discussion
    Replies: 4
    Last Post: 07-13-2006, 05:06 AM
  5. PHP - Can't connect to Memcached server
    By grabmail in forum Programming Discussion
    Replies: 0
    Last Post: 06-12-2006, 02:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •