Performance Tuning

Facebook Twitter

MySQL Optimization. Carsten’s Random Ramblings. « 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.

Carsten’s Random Ramblings

Database War Stories #3: Flickr - O'Reilly Radar. 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.

Database War Stories #3: Flickr - O'Reilly Radar

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.” Choosing innodb_buffer_pool_size. 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.

Choosing innodb_buffer_pool_size

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).

Pagination

Memcached. Data. Archiving. Configuration.