Monthly Archives: July 2011

MySQL Maintenance Tasks for InnoDB with MySQL 5.1

by Laurence Posted on July 22, 2011

From time to time, MySQL 5.1 databases need a little house keeping. We found our production DB had a hard time running a simple join query between two tables with about 400k rows. It was taking between 30 and 100 … Continue reading →

Posted in Data, Sys Admin | Tagged linux, scripting | Comments Off

Memory Based Simultaneous User Limit

by Laurence Posted on July 14, 2011

As a follow on to my last post about PHP memory consumption, I wanted to get some ideas out there about memory utilization. This post explores: An equation for the maximum number of users an application can support on a … Continue reading →

Posted in Application Development, Sys Admin | Tagged architecture, software, startup | Comments Off

Monthly Archives: July 2011

MySQL Maintenance Tasks for InnoDB with MySQL 5.1

Memory Based Simultaneous User Limit

Categories

Recent Posts

Monthly Archives: July 2011

Categories

Tags

Recent Posts