I'm using mysql 4.1.14 rpm's on Fedora Core 4.
I've setup max_heap_table_size to allow for 500M heap tables. Currently I
use roughly 435M in heap by about 16 different tables. Some use btree,
other's use default hash.
The problem is, over time mysql looks like this in top:
PID USER PR NI VIRT RES
I need some help with a query to sum data for each id and write it into a
new table.
I have a source data table for each calendar month containing i.d.'s (not
unique) and a value and I need to sum all the values for each i.d. for all
months into a new table (where each i.d. will now be unique).