<p>how can one know that each process or a thread is consuming how much memory in MYSQL?</p>

Assuming you just want just the memory usage of the mysql server program.
On windows you can use
Process Explorer
On linux you can use the top command.
Use "ps -e" to find the pid of the mysql process
Then use "top -p {pid}" where {pid} is the pid of the mysql process.