MySQL Forums
Forum List  »  MyISAM

Unable to analyse thread level information in MySQL server
Posted by: Afaque Ahmad Siddiqui
Date: October 17, 2014 04:14AM

Hello,

I need to analyse thread level MySQL performance on Linux(Centos), like how many thread get created after running MySQL server and how much CPU utilisation for each individual thread
in millisecond or microsecond level.Basically i need to analyse worker thread but when list threads corresponding to MySQL server.It shows many threads(around 25 thread) to the MySQL process.

like if i check- $ps -eLF | grep mysql

mysql 4969 4608 4969 0 25 356799 195528 0 Oct16 pts/0 00:00:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/mysql.err --pid-file=/var/lib/mysql/cassiopeia.pid --socket=/var/lib/mysql/mysql.sock --port=3306
mysql 4969 4608 4971 0 25 356799 195528 0 Oct16 pts/0 00:00:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/mysql.err --pid-file=/var/lib/mysql/cassiopeia.pid --socket=/var/lib/mysql/mysql.sock --port=3306
mysql 4969 4608 4972 0 25 356799 195528 0 Oct16 pts/0 00:00:03 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/mysql.err --pid-file=/var/lib/mysql/cassiopeia.pid --socket=/var/lib/mysql/mysql.sock --port=3306
mysql 4969 4608 4973 0 25 356799 195528 0 Oct16 pts/0 00:00:01 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/mysql.err --pid-file=/var/lib/mysql/cassiopeia.pid --socket=/var/lib/mysql/mysql.sock --port=3306
mysql 4969 4608 4974 0 25 356799 195528 0 Oct16 pts/0 00:00:02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/mysql.err --pid-file=/var/lib/mysql/cassiopeia.pid --socket=/var/lib/mysql/mysql.sock --port=3306
mysql 4969 4608 4975 0 25 356799 195528 0 Oct16 pts/0 00:00:02 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --plugin-dir=/usr/lib64/mysql/plugin --user=mysql --log-error=/var/lib/mysql/mysql.err --pid-file=/var/lib/mysql/cassiopeia.pid --socket=/var/lib/mysql/mysql.sock --port=3306
.
.
.

It shows so many running threads.Is there any tool which can identify the worker thread and capture the CPU usage in microsecond level.

How to identify all threads by the name so that it would possible to recognise which thread is running for for what purpose.

Thanks
Regards
Afaque

Options: ReplyQuote


Subject
Views
Written By
Posted
Unable to analyse thread level information in MySQL server
5348
October 17, 2014 04:14AM


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.