How does Drizzle handle parallel "things"?

Asked by Lee Bieber

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:
Last reply:
Revision history for this message
Launchpad Janitor (janitor) said :
#1

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

Revision history for this message
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.

Revision history for this message
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.

Revision history for this message
Lee Bieber (kalebral-deactivatedaccount) 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.