Tag Archives: efficiency

Blowing up in memory

Posted on 2011/09/25 by

MySQL isn’t too concerned about table handler memory usage – it will allocate row size buffer thrice per each table invocation. There’s a few year old bug discussing UNION memory usage – for each mention in an union one can allocate … Continue reading →

Posted in mysql | Tagged , , , | 7 Comments

Memcached for small objects

Posted on 2008/12/25 by

Memcached quite often ends up as a store for very small objects (small key and some integer value), though it isn’t really designed to do this kind of work by default. Current memory management is based on slabs (200 of … Continue reading →

Posted in mysql | Tagged , , , | 6 Comments

Wasting InnoDB memory

Posted on 2008/05/29 by

I usually get strange looks when I complain about memory handling inside InnoDB. It seems as if terabytes of RAM are so common and cheap, that nobody should really care about memory efficiency. Unfortunately for me, I do. Examples: The … Continue reading →

Posted in mysql | Tagged , , | 10 Comments

LAMPS on steroids

Posted on 2006/12/06 by

I’m not sure if I’m the first coining in ‘LAMPS’ – scaled out LAMP environment with Squid in front, but it sounds cool. Squid is major component in content distribution systems, reducing the load from all the backend systems dramatically … Continue reading →

Posted in mysql, wikitech | Tagged , , , , | 10 Comments