We are thinking of moving to MySQL. We have a table of several tens
of millions of rows, with two indices, which will be accessed by
roughly 100 different processes. At any one time, 5 or so of the
processes will be doing selects on the table, while 40 or so will be
doing updates. However, no
On Fri, Jan 19, 2001 at 06:58:34AM -0500, Bob Hall wrote:
MySQL has only table level locking, which means that each update
will lock the entire table, which means that updates must be done
one at a time. There are a couple of open source extensions of MySQL
that are supposed to offer row
On Fri, Jan 19, 2001 at 06:58:34AM -0500, Bob Hall wrote:
MySQL has only table level locking, which means that each update
will lock the entire table, which means that updates must be done
one at a time. There are a couple of open source extensions of MySQL
that are supposed to
As far as hardware goes, you should be able to increase performance with
more RAM and faster disks such as UW-160 SCSI.
Also, I don't think they make dual processor motherboards for Athalons.
- Scott
(The total throughput we need is on the order of 100 indexed updates
per second; currently