Hi everybody,
I've got a little problem with a web and mysql based
bulleting-board-application.
The board is quite well visited and users are writing aprox. 1 new post
per second. In total the db gets aprox. 250 queries/sec.
The webserver and mysql-server are running on different hosts, the db
Assuming that the locking issues occur mainly when an insert is being
performed (i.e. replying to a post) then what about using read local
locks for selects so that you can perform con-current inserts?
If you have a lot of old threads that are no longer updated but viewed
regularly then you
Marco, it would be more helpful if you could post the table structures
involved (SHOW CREATE TABLE tablename) as well as the SQL query
that is giving you this problem.
Off the top of my head:
- InnoDB is designed to solve this exact problem; maybe re-visit why
you cannot use it, given that it