472,122 Members | 1,509 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,122 software developers and data experts.

Parallel query processing in MySQL


I would like to know whether MySQL supports parallel query processing on server with two CPUs? If so, where can I find information on how to write such queries.
Jul 20 '07 #1
2 7205
802 Expert 512MB
I don't think this is available in MySQL. I found this thread on mysql.net. [url=http://www.mysql.com/news-and-events/news/article_901.html]MaxDB[url] has this support.
Jul 20 '07 #2
5,821 Expert 4TB
Heya, vkvkvk.

I suppose you could run two instances of mysqld on the same server, open two connections in your application, and attempt to run two queries concurrently.

The problems with this, though, are:
  • mysqld checks for other running instances of mysqld, so you'd have to do something... unsupported... to get it to work.
  • With two instances of mysqld running, you'll probably experience data corruption at some point, since mysqld was never designed to run more than one instance at a time.
  • Many programming languages do not support threading, so your script would wait for the first query to finish before starting the second one anyway.

Now you could in theory set up a MySQL Cluster, but pretty much for the reasons above, you'd need at least 3 separate computers, and at that point, the overhead would just about outweigh any benefits. At least, when it came to trying to make MySQL use some kind of threading.
Jul 22 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

13 posts views Thread by aaron | last post: by
reply views Thread by Matt Weakly | last post: by
2 posts views Thread by opt_inf_env | last post: by
4 posts views Thread by Mark D Powell | last post: by
25 posts views Thread by frizzle | last post: by
5 posts views Thread by George Sakkis | last post: by
3 posts views Thread by John | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.