We run a large forum with lots of reads and writes, particularly to the posts and topics tables which are both innodb. Last week I started doing 12 hourly backups with innobackupex because mysqldump ...
Would deleting old data from my tables improve MySQL query performance? When my queries use indexes? When my queries don't use indexes? When I use InnoDB? When I use MyISAM?