Category Archives: MySQL

Blowout Preventer :: non-technical white paper

Background Consider a car, generally speaking the efficiency (i.e. miles per gallon) increases with speed, up to a point, after which the efficiency drops off. The same is true for web applications, or indeed any applications supporting concurrent processing. Generally, … Continue reading

Posted in High Scalability, MySQL | Tagged , , , , , , , | Leave a comment

Scalable MySQL: Avoid offset for large tables

It’s fairly common to need to iterate through all the rows in a given table and perform an action on each. The usual way to do this is fetch rows from the database in batches using LIMIT, specifying an offset … Continue reading

Posted in High Scalability, MySQL | Tagged , , , , , , , , | 8 Comments

Lost connection to MySQL server during query

A member of the team came to me the other day with a MySQL error that I’d not seen before: Lost connection to MySQL server during query The MySQL manual (http://dev.mysql.com/doc/refman/5.0/en/gone-away.html) says that it can be caused by: applications that … Continue reading

Posted in MySQL | Tagged , , , , | Leave a comment