Barry Frost

This is Barry Frost’s personal website.

Tagged #index

How FriendFeed uses MySQL to store schema-less data

Compressed python pickles are stored in an entities table with other tables storing indexes of this data. Uses normal MySQL replication and transactions via InnoDB but without time-consuming index rebuilds whenever they add features.

log_queries_not_using_indexes

Hugely useful MySQL parameter. The post’s author says he’ll often design an application without indexes and then use this parameter (in development) to add indexes where needed

Dissecting MySQL Fulltext Indexing