Top misreports

bostonthunder777 · 09-26-2007, 07:40 AM

Guys, I have been troubleshooting an issue where top output shows incorrect data.

I reinstalled the procps package with the current version and with the latest one as well. But no luck.

I copied a working binary from other host but no fruit though..

Any ideas??

Thanks, MK

bostonthunder777 · 09-26-2007, 07:46 AM

Compiled from source but luck though.

matthewg42 · 09-26-2007, 07:57 AM

What do you mean, "incorrect data"?

bostonthunder777 · 09-26-2007, 08:02 AM

The CPU stat for first two process exceeds 100%

PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
1618 mysql 51 16 0 447M 280M sleep 117.8H 112% mysqld-max
19426 root 31 16 0 3035M 436M run 116.1H 94.77% ndbd

bostonthunder777 · 09-26-2007, 10:04 AM

Experts.. Anyone??

marozsas · 09-26-2007, 11:08 AM

Following the path you took, I suggest to try htop (http://htop.sourceforge.net/), just to see if it shows consistent results with top or there is something really bad in your system/kernel.

bostonthunder777 · 09-26-2007, 02:37 PM

I tried with the hop, but even that gives incorrect stats. What I believe is weather top or htop looks for files under /proc dir gathers the information. Somehome those files are misformatted.

I know a reboot may fix it, but this is DB host. There is lot things involved starting from buy-off from business and so on just to fix this top.

kromberg · 09-26-2007, 02:42 PM

If the application is multithread like mysql, then the total of each thread's cpu time, memory, etc is reported under one entry with top. That is how a 'single' process can exceed 100%.

Keith

bostonthunder777 · 09-27-2007, 08:54 AM

makes sense. I will look for another mysql server just to see if it has the same pattern.

bostonthunder777 · 09-27-2007, 10:33 AM

cant find anything else with mysql server. Found this http://forums.mysql.com/read.php?24,...0088#msg-80088 while researching..

Thanks to everyone..