MySQL Forums
Forum List  »  Partitioning

Re: Does MySQL support query parallelisation?
Posted by: Mikael Ronström
Date: March 28, 2006 03:41AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Does MySQL support query parallelisation?
9062
March 28, 2006 03:41AM
3179
July 06, 2007 06:17PM
3247
September 12, 2007 11:51AM
3182
September 12, 2007 11:54AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.