Quote:
Originally Posted by Electronic Punk
Having a problem that when I pull the threads in from the newsgroup it slows down my entire site because it locks the post table, does anyone else experience this?
the forum mysql logon does not have permission to lock tables, but seems to do it anyway.
|
That is disadvantage of MYISAM table. Everytime you write to it. The entire table needs to be locked. INNODB on the other hand, does row level locking. The problem with INNODB is it does not offer Fulltext index (at least with the current version and near future versions). Also unlike MyISAM, InnoDB needs to do a full table scan for COUNT().
There is really nothing you can do about this. This is a on going performance problem faces anyone who owns a board which has many posts.
Perhaps you can put one second delay between post imports. Find this in the NNTP settings under AdminCP.