I have a MyISAM table partitioned by range with 90 partitions representing the last 90 days. I expect this table to receive somewhere between 500 million to 1 billion records before i start rotating partitions (dropping old ones and creating new ones).
What server configuration options would you put in your
.my.conf file to ensure that the fastest possible insertion into this table was possible at all times?
Any other tips would also be appreciated.
EDIT: By 'fastest possible' i mean best possible insert speed and being sustained once it contains 100's of millions of rows.