How mysql works with processes?
===

    mysql  Ver 14.16 Distrib 5.2.12-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2, tables MyISAM

Situation: two select queries from two different clients to one database and tables (query with join).  
Processor on server has 8 cores.  
I want to know, isn't start two processes, one for each client, and one from 8 core execute every process?  
It's possible? Is any MySQL/MariaDBoption for max_process or something else?  
As i understand, one mysql process can work with 1 core of processor. I make google search for it, and find information about some plugin for InnoDB tables, which works with multicore processors, but i want understand how mysql works. 
What i need to reed about this?  
 

