Performance Tuning
Get flash to fully experience Pearltrees
« MySQL Pop Quiz #17 | Main | MySQL Pop Quiz #18 »
FIND_IN_SET() :: MySQL Function of the Day | Carsten’s Random Ramblings
Continuing my series of queries about how “Web 2.0″ companies used databases, I asked Cal Henderson of Flickr to tell me “how the folksonomy model intersects with the traditional database. How do you manage a tag cloud?” He replied: “lots of the ‘web 2.0′ feature set doesn’t fit well with traditional normalised db schema design. denormalization (or heavy caching) is the only way to generate a tag cloud in milliseconds for hundereds of millions of tags. you can cache stuff that’s slow to generate, but if it’s so expensive to generate that you can’t ever regenerate that view without pegging a whole database server then it’s not going to work.”
Database War Stories #3: Flickr - O'Reilly Radar
Choosing innodb_buffer_pool_size | MySQL Performance Blog
November 3, 2007 By Peter Zaitsev 39 Comments
Pagination
Memcached
Data
Archiving
Configuration