Hi,
Lawrie Cornell wrote:
> Hi,
>
> Can anyone tell me whether MySQL supports
> parallelisation of queries (i.e., can it spread
> the processing of a single individual query across
> multiple CPUs)?
>
No, not for the moment. This is part of our roadmap
for future versions and partitioning development was
an important step preparing for this. However it is
possible to parallelise queries by hand through the
MySQL Client API. We had a master thesis student do
such tests and found very general algorithms of
splitting queries into parallel parts that are fairly
straightforward to do from the Client API and the
scalability was really good, sometimes even superlinear.
In later versions we will most likely take those ideas
into the MySQL Server.
Rgrds Mikael
> I'm really struggling to find an answer to this
> question and it is the determining factor as to
> whether or not I can use MySQL in a new project,
> so any information regarding this would be greatly
> appreciated.
>
> Thanks in advance,
> Lawrie.
>
>
>
> Edited 1 times. Last edit at 03/26/06 06:32AM by
> Lawrie Cornell.
Mikael Ronstrom
Senior Software Architect, MySQL AB
My blog:
http://mikaelronstrom.blogspot.com