Hi Daniel,
So what would be a good solution within MySQL to store large amounts of data if they
have to go into a single table?
InnoDB seems to be the right table type to use (especially as they support
transactions as well) but you do not have controll over the used tablespace. They are
just
Hi,
You could do the partitioning logic on the application side.
For example you can create a new table every month with a
different suffix corresponding to the year/month number.
Then you add the info about this new table into a master
description table, which holds one row per created table,