At 23:23 19/01/99 -0800, you wrote:
>Hi all,
>
>A couple questions...I have a database running on MySQL that has
>a lot of updates being done to it, as well as a lot of selects.
>Because I've got to lock the table for the updates, it puts a good
>number of my connections to the server into "Sleep" state waiting
>for their turn to access the database.
>
>The bulk of the selects from the database don't need to have
>totally up-to-date information, but they still have to wait for
>access because of the locks needed for the writes.
>
>I was thinking that if I ran two MySQL daemons on the same box,
>using different ports, I could link the files and use one
>of the daemons for read-only access.
<snip>
Woudn't it be simpler just to use a different table on the same database,
or a table with the same name on a differnet database rather than running
two daemons?
Colin
-----------------------------------------------------------
Send a mail to [EMAIL PROTECTED] with
unsubscribe mysql [EMAIL PROTECTED]
in the body of the message to unsubscribe from this list.
