What type of table do you recommend for historical data? I was using InnoDB, which i thought should be faster with row level locking, but i dont know if this really applies because i am not updating the data, just inserting new rows. I am just trying to increase the speed of my select queries as i am trending data every second.
Generally myisam is faster. InnoDB is usually more robust, as it supports transactions and is less likely to get corrupted… but there are some parameters that you can use to make corruption less of a problem with isam.
I’ll let someone who knows a bit more follow up with more details, but yeah, for normal tasks myisam is usually way fast.