Unable to analyse thread level information in MySQL server
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
Subject
Views
Written By
Posted
Unable to analyse thread level information in MySQL server
5637
October 17, 2014 04:14AM
2033
October 20, 2014 11:23AM
1923
November 03, 2014 09:50PM
1741
November 06, 2014 08:25PM
1851
November 06, 2014 08:35PM
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.