CA BD NY
  • Categories

  • Recent Posts

  • User Services

  • RSS Apache Hacker

  • RSS CentOS Hacker

  • RSS miniCTO

  • Spam Blocked

  •  Subscribe in a reader

    Add to Google Reader or Homepage

    Enter your email address:

  • Our Tweets

  • Archive for the Performance Category


    A Practical SPEED-UP Story for Large MySQL Installation

    Published June 10th, 2010

    Background
    One of our customer runs a large (in our camp at least) MySQL system with tables exceeding 30-50M records storing online transaction data. They use daily cron job to create data summary from these transaction tables which runs nightly and produces summary data on MEMORY tables for quick access by thousands of other companies to [...]

    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.