Ronan,
The command you are looking for is 'SHOW PROCESSLIST' or 'SHOW
FULL PROCESSLIST'. Additionally, take a look at 'mytop', which you can
find at http://jeremy.zawodny.com/mysql/mytop/
<quote>
mytop - a top clone for MySQL
mytop is a console-based (non-gui) tool for monitoring the threads and
overall performance of MySQL 3.22.x, 3.23.x, and 4.x servers. It runs on
most Unix systems (including Mac OS X) which have Perl, DBI, and
Term::ReadKey installed. And with Term::ANSIColor installed you even get
color. If you install Time::HiRes, you'll get good real-time
queries/second stats. As of version 0.7, it even runs on Windows
(somewhat).
</quote>
Thanks,
Ryan Yagatich
,_____________________________________________________,
\ Ryan Yagatich [EMAIL PROTECTED] \
/ Pantek Incorporated (877) LINUX-FIX /
\ http://www.pantek.com/security (440) 519-1802 \
/ Are your networks secure? Are you certain? /
\___F49F3365CFC4F2613AD204C58E50C1AD73F23DC722666BD4___\
On Mon, 9 Feb 2004, Ronan Lucio wrote:
>Hello,
>
>We have an MySQL-4.0.14 Server installed and sometimes the
>it takes 90% from CPU.
>
>So, my question is:
>Is there a way to know what is taking so many CPU process?
>What query is causing such problem?
>
>Thanks
>Ronan
>
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
