Jonathan Chong wrote:
I have a table on my forum that's frequently accessing with reads and
writes. On a busy day, the table is locked when people are posting
messages and the page hangs when you try to read a topic.
Is it worth me converting the table to InnoDB, as I've heard that
InnoDB doesn't lock tables during I/O access.
InnoDB has row-level locking (i.e. it basically only locks the rows that
might be changed by the query). InnoDB is generally speaking a good
choice in 'high concurrency' situations (many reads and writes at the
same time); for small read-only or write-only tables InnoDB is usually
slower than MyISAM.
In your situation it might solve the locking problem. Do read the online
manual carefully since there are a lot of differences between MyISAM and
InnoDB (the way data is stored, the way indexes are stored, some
differences in handling statements and functions,etc.)
Regards, Jigal.
smime.p7s
Description: S/MIME Cryptographic Signature