As Sasha said, intra-query parallelization is a VERY HARD TASK.
However, even an SMP could take a throughput approach and run
several copies of the MySQL server (would get some parallelism
in the query optimization, etc, stages) before hitting the file system.
Each processor would execute one query completely. Inter-processor
locks are needed to protect the next query from trying to hit
the table before the previous query is finished in another processor
I'm not on an SMP, however the processors share access to the disks.
The throughput approach is still feasible.
Any suggestions at which files should I look into as reasonable place to put
inter-processor locks ?
(I'm currently delving in the sql/*.cc files and looking at things
like open_and_lock_tables ),
Get your FREE download of MSN Explorer at http://explorer.msn.com