Interesting question. This really depends on multiple things (operating
system, table locking, etc.)
LinuxThreads are implemented more like multiple processes sharing memory, so
you will see a benefit from having multiple processors as these threads
(processes) are scheduled across both processors. However, you will not see
much benefit when accessing the same table for inserts, updates and
deletions. I believe locking prevents access by multiple processes when
performing these operations. I am not sure of the granularity of the locks.
The question is really, does MySQL do record locking or page locking or
complete table locking during these operations? If MySQL does record
locking, then the performance gains will be much higher.
D
----- Original Message -----
From: "Bryan Coon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 03, 2001 2:12 PM
Subject: Dual Processors and Threads?
> Would someone briefly explain to me how MySQL uses threading in a
> multi-processor environment?
>
> Currently I have a Dual 1gHz processor box running RedHat 7.1 with the smp
> kernel. Does this automatically take care of things? Is mysql
parallelized
> at all, or is this inherent in the threading? Insofar as optimization,
are
> there any manual things I have to do to optimize mysql for a dual
processor
> box?
>
> This is kind of a new topic for me so my apologies if I have missed the
> obvious somehow.
>
> Thanks!
> Bryan
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
