Can MySQL use multiple threads for single query?

06-08-2008, 08:38 AM

Hi everybody!

I'm using MySQL for storing fairly large amounts of data and would like to know if MySQL is capable of using multiple threads for a single complex query and thereby spread the load across several CPU's?

For example: A single query on a large table takes let's say 5 minutes to complete. Does MySQL take advantage of several CPU's or would this query only use a single CPU?