CA BD NY
  • Categories

  • Recent Posts

  • User Services

  • RSS Apache Hacker

    • An error has occurred; the feed is probably down. Try again later.
  • RSS CentOS Hacker

  • RSS Editor's Lists

    • An error has occurred; the feed is probably down. Try again later.
  • Spam Blocked

  •  Subscribe in a reader

    Add to Google Reader or Homepage

    Enter your email address:

  • Our Tweets

  • Archive for the Performance Category


    Increasing the Memory Size for Memory Tables

    Published January 5th, 2009

    How to increase maximum memory allocation used for MEMORY tables on MySQL servers

    Understanding MySQL Query Cache for PHP Developers (Part I)

    Published December 13th, 2008

    Understanding MySQL Query Cache for PHP Developers

    Using SQL Directives to Control Query Performance

    Published November 9th, 2008

    How to use MySQL directives to enhance your query performance

    Calculating Maximum Connections for MySQL Server

    Published November 1st, 2008

    How to calculate maximum connections for your MySQL server

    Beware of MySQL View Filtering in Your PHP Code

    Published October 31st, 2008

    Why MySQL VIEW filtering (i.e. applying WHERE clause) might be a bad for performance.

    Keeping Your Database “Fresh” Using MERGE Engine

    Published October 30th, 2008

    How to keep MySQL database appear “FRESH AS NEW” every day using MERGE tables

    Automatically Loading MySQL Memory Tables on MySQL Startup or Reboot

    Published October 28th, 2008

    How to load MySQL memory tables at MySQL server startup or reboot cycle

    Speeding Up ZenCart with MySQL Memory Tables

    Published October 28th, 2008

    How to speed up zencart using MySQL memory tables.