Tag Archives: memory

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

Stonebraker trapped in Stonebraker 'fate worse than death'

Posted on 2011/07/08 by

Oh well, I know I shouldn’t poke directly at people, but they deserve that sometimes (at least in my very personal opinion). Heck, I even gave 12h window for this not to be hot-headed opinion. Those who followed MySQL at … Continue reading →

Posted in facebook, mysql | Tagged , , , , | 30 Comments

Logs memory pressure

Posted on 2010/11/18 by

Warning, this may be kernel version specific, albeit this kernel is used by many database systems Lately I’ve been working on getting more memory used by InnoDB buffer pool – besides obvious things like InnoDB memory tax there were seemingly … Continue reading →

Posted in facebook, mysql | Tagged , , , | 4 Comments

uncache!

Posted on 2009/06/26 by

this is source code for a tiny program I just wrote that traverses specified directories and removes them from file system cache. There are few use cases for it. One is for all these people who benchmark stuff and want … Continue reading →

Posted in mysql | Tagged , | 6 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

mmap()

Posted on 2008/08/17 by

I’ve seen quite some work done on implementing mmap() in various places, including MySQL. mmap() is also used for malloc()’ing huge blocks of memory. mmap() data cache is part of VM cache, not file cache (though those are inside kernels … Continue reading →

Posted in mysql | Tagged , , , | 4 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