Hi!
>>>>> "Jeremy" == Jeremy Rusnak <[EMAIL PROTECTED]> writes:
Jeremy> Hi all,
Jeremy> A couple questions...I have a database running on MySQL that has
Jeremy> a lot of updates being done to it, as well as a lot of selects.
Jeremy> Because I've got to lock the table for the updates, it puts a good
Jeremy> number of my connections to the server into "Sleep" state waiting
Jeremy> for their turn to access the database.
Can't you use incremental updates and not lock the tables.
If a connection is on 'sleep' mode, it's not waiting for a lock; It's
waiting for the client to send it a command.
Jeremy> The bulk of the selects from the database don't need to have
Jeremy> totally up-to-date information, but they still have to wait for
Jeremy> access because of the locks needed for the writes.
Sorry, MySQL doesn't support dirty reads.
Jeremy> I was thinking that if I ran two MySQL daemons on the same box,
Jeremy> using different ports, I could link the files and use one
Jeremy> of the daemons for read-only access.
This will not help ; The locks will still hold even for the second server.
Regards,
Monty
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
