MySQL and partitioning tables with millions of rows
The Problem I've been running a mobile GPS tracking service, MoosTrax (formerly BlackBerry Tracker), for a few years and have encountered a large amount of data in the process. A user's phone sends its location to the server and it is stored in a MySQL database. Each "location" entry is stored as a single row in a table. Right now there are approximately 12 million rows in the location table, and things are getting slow now, as a full table scan can take ~3-4 minutes on my limited hardware....