MySQL Memory Table Size

If you're doing some Real Time processing with MySQL, you probably better use a Memory table and only eventually commit the results to a disk table.

But if you do that with the default setting, you'll soon run out of memory on a 16MB table!!

Don't worry, it is configurable!
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_max_heap_table_size
(Note: this refers to MySQL 5.1 version, you may have another version. Also see page for other system configuration options)

And to make a long story short, open MySQL Administrator --> Health --> System Variables --> Memory --> max_heap_table_size
and set it to 268435456 (=256MB)