How to know about memory consumption in mysql?

Question

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

Answer 1

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.

1. Use "ps -e" to find the pid of the mysql process
2. Then use "top -p {pid}" where {pid} is the pid of the mysql process.

Answer 2

on linux you can also use top|grep mysql to get a running report of the stats of the mysql process, 1 row per top refresh period.