Quote:
Originally Posted by Rubber Duck
The biggest impediment to IDN now appears to be the the half hour or more that it now seems to take to post anything on this dysfunctional site. It would be nice for the community as a whole to be given some clues as to whether this forum is going to be reconstructed or just allowed to degenerate.
|
If I've said it once, I've said it a thousand times. The database needs to be tuned.
MySQL is not a real database, but it certainly has been proven to handle forums much busier than this one. Postgres would be the optimum choice, if only Vbulletin would support it.
The problems with MySQL are that it doesn't handle concurrent SELECT and UPDATE/INSERT very well and you run into the long-running operation timeouts (you get a deadlock - a read waiting on a write, round-robin). The MySQL table driver MyISAM, which I'm guessing is what is being used here, only supports table-level locking, which means in practice that for any UPDATE or INSERT, there is no concurrency - the entire table needs to be locked for the single operation. If multiple users are trying to post or edit, then the operations go into a queue and can hang the database as we see. The solution would be to use the third-party table driver InnoDB, as it supports row-level locking. However, this also contains transaction support so it will be slower than MyISAM unless carefully tuned.
If Olney or someone else is willing to pay me, with cash or a decent revenue earning japanese domain :- ) , then I will offer my services to tune the DB.
.