Tell me more ×  How to get details of a process that is taking
RAM. From top command i have found that Mysql is taking too much
ram how can i know why Mysql is taking too much ram far from
usual behavior?  Is there any commands to get more details of
the process other than "ps"  share|improve this question add
comment  3 Answers  You may want to run SHOW PROCESSLIST within
MySQL to get information about which queries are currently
running.  MySQL Documentation for SHOW PROCESSLIST
share|improve this answer add comment  mytop - A command line
utility for monitoring real time MySQL Server performance. In
order for mytop to function properly, you must have the
following:    • Perl 5.005 or newer   • Getopt::Long   • DBI and
DBD::mysql   • Term::ReadKey from CPAN  And the above, I have
specified for linux distributions.  share|improve this answer
add comment  It sounds to like MySQL is having to create large
in-memory temporary tables while processing an unoptimized
query.  If it isn't enabled, enable the slow q