How to find out about memory consumption in mysql?

Question

How to find out that each process or thread consumes so much memory in MYSQL?

Answer 1

Assuming you just want to use only mysql server memory.

In 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.

Answer 2

on linux you can also use top | grep mysql to get the current mysql process statistics report, 1 row for the upper update period.