We have a new table in our system:
id int(11) NOT NULL AUTO_INCREMENT,
log_id int(11) NOT NULL,
w_id int(11) NOT NULL,
s varchar(40) DEFAULT NULL,
PRIMARY KEY (
) ENGINE=MyISAM AUTO_INCREMENT=860 DEFAULT CHARSET=latin1
This is a details table which maps to a log entry (log_id). For each log entry, on average, there will 15 detail records. I expect to have 2,000 to 5,000 log entries per day which means anywhere from 30,000 to 75,000 log detail entries per day. We selected MyISAM as we need it to be super fast for insertions with “concurrent_insert=2”. Selects will be done much less frequently.
I was wondering if the table structure and engine selection look good? or maybe we could do something better?