Archive for the Performance Category
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 [...]
Published January 5th, 2009
How to increase maximum memory allocation used for MEMORY tables on MySQL servers
Published December 13th, 2008
Understanding MySQL Query Cache for PHP Developers
Published November 9th, 2008
How to use MySQL directives to enhance your query performance
Published November 1st, 2008
How to calculate maximum connections for your MySQL server
Published October 31st, 2008
Why MySQL VIEW filtering (i.e. applying WHERE clause) might be a bad for performance.
Published October 30th, 2008
How to keep MySQL database appear “FRESH AS NEW” every day using MERGE tables
Published October 28th, 2008
How to load MySQL memory tables at MySQL server startup or reboot cycle
Published October 28th, 2008
How to speed up zencart using MySQL memory tables.