469,167 Members | 1,976 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,167 developers. It's quick & easy.

Parallel query processing in MySQL

1
Hello,

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.
Thanks
Jul 20 '07 #1
2 7120
mwasif
801 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
pbmods
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
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.