MySQL Forums
Forum List  »  Newbie

MTop and sleeping threads
Posted by: sergio cardone
Date: February 02, 2010 11:53AM

hello,

I would like to optimize my server and I'm monitoring the mysql server with mTop utility.

At this momenti I have this

========
load average: 0.18, 0.19, 0.22 mysqld 5.0.32- up 1 day(s), 0:13 hrs
25 threads: 1 running, 1 cached. Queries/slow: 1.2M/0 Cache Hit: 99.98%
Opened tables: 0 RRN: 72.3K TLW: 536 SFJ: 0 SMP: 0 QPS: 19
========

the top threads have about 200 TIME

If I read the slow query log I don't see new entryes.

How can I have more info about the sleeping threads ? Are this bad for my server ?

Sorry foor noob questions but I'm real noob...

Thanks for your comments!

Options: ReplyQuote


Subject
Written By
Posted
MTop and sleeping threads
February 02, 2010 11:53AM
February 07, 2010 01:11PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.