Cox Communications Powers Massive Data Warehouse With MySQL

This is a white paper from IT Papers. Not alot of technical details in the 4 page PDF, but the numbers are fairly impressive.

The warehouse is a collection of historical diagnostic data from all the individual cable modems in the Cox network (1.2 million of them). The warehouse currently has around 2 billion rows, with 4 million new inserts every 4 hours. "Network usage mining" takes place overnight and lasts about 3 hours.

Looks like this division of Cox is firmly in the open-source camp, as the polling is done with Perl scripts, and the web-based front end and reporting interface is all LAMP (Linux, Apache, MySQL and PHP).

More and more of these case studies are popping up.