A Lightweight SQL Database for Cloud Infrastructure and Web Applications

How does Drizzle handle parallel "things"?

Asked by Lee Bieber on 2010-11-26

Found this buried on our wiki, posting here:

I have heard that Drizzle handles parallel "things" - does that mean queries and index rebuilds? If so, how so and what optimization techniques are there? How does Hyper-Threading fit in if at all

Question information

Language:
English Edit question
Status:
Answered
For:
Drizzle Edit question
Assignee:
No assignee Edit question
Last query:
2010-12-13
Last reply:
2010-12-11
Launchpad Janitor (janitor) said : #1

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Stewart Smith (stewart) said : #2

Drizzle does not execute a single query over multiple threads.

It instead aims to remove global mutexes that would stop two queries on two connections executing at the same time.

Brian Aker (brianaker) said : #3

Not true, when you call for instance SELECT EXECUTE() CONCURRENT.... Drizzle will use multiple thread to resolve the statements being executed in CONCURRENT.

In the future filesort() will also be making use of multiple threads as well.

Lee Bieber (kalebral) said : #4

...

Can you help with this problem?

Provide an answer of your own, or ask Lee Bieber for more information if necessary.

To post a message you must log in.