Performance Tuning

Facebook Twitter
MySQL Optimization
« MySQL Pop Quiz #17 | Main | MySQL Pop Quiz #18 » FIND_IN_SET() :: MySQL Function of the Day By Carsten | March 25, 2008 Function name: FIND_IN_SETAliases: -Function type: String function Purpose: Return position of value in string of comma-separated values FIND_IN_SET() :: MySQL Function of the Day | Carsten’s Random Ramblings 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 Database War Stories #3: Flickr - O'Reilly Radar

Choosing innodb_buffer_pool_size | MySQL Performance Blog

November 3, 2007 by Peter Zaitsev39 Comments My last post about Innodb Performance Optimization got a lot of comments choosing proper innodb_buffer_pool_size and indeed I oversimplified things a bit too much, so let me write a bit better description. Innodb Buffer Pool is by far the most important option for Innodb Performance and it must be set correctly. I’ve seen a lot of clients which came through extreme sufferings leaving it at default value (8M). Choosing innodb_buffer_pool_size | MySQL Performance Blog
Pagination

Memcached

Data

Archiving

Configuration