I’ve never used Innodb so I’m unsure if switching to it will give me a benefit. So if you can shed any insight that would be great.
I don’t use foreign keys, I don’t care about ACID, I don’t do full text searches. I say this, because every site mentions if you use any of those 3 then you will use Innodb or MyISAM. Not much help after that.
My thought is that the row level locking will speed up things for me as the DB is heavily read/write to. The table is less than 1MB in size and uses indexes.
I have a two dual core processors and will soon have 4GB ram (2GB now). The slow query log pretty much only shows queries in two tables, both which match the above descriptions. One is 6,000 rows the other is 2,000.
Advice would be great.