mysql资源消耗高,查询为线程4030,该线程具体在做什么?

Thread 28 (Thread 0x7f1d29a10700 (LWP 4030)):

0 0x00007f1e809cc995 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0

1 0x00000000009757f9 in os_cond_wait (fast_mutex=0x838d3f0, cond=0x838d430) at /export/home/pb2/build/sb_0-29159266-1529069114.89/rpm/BUILD/mysql-5.6.41/mysql-5.6.41/storage/innobase/os/os0sync.cc:214

2 os_event_wait_low (event=event@entry=0x838d3f0, reset_sig_count=<optimized out>) at /export/home/pb2/build/sb_0-29159266-1529069114.89/rpm/BUILD/mysql-5.6.41/mysql-5.6.41/storage/innobase/os/os0sync.cc:592

3 0x00000000009e2fde in sync_array_wait_event (arr=0x169eb70, index=0) at /export/home/pb2/build/sb_0-29159266-1529069114.89/rpm/BUILD/mysql-5.6.41/mysql-5.6.41/storage/innobase/sync/sync0arr.cc:424

4 0x00000000009e4353 in rw_lock_x_lock_wait (line=658, file_name=0xc8dbb0 "/export/home/pb2/build/sb_0-29159266-1529069114.89/rpm/BUILD/mysql-5.6.41/mysql-5.6.41/storage/innobase/btr/btr0sea.cc", lock=0x838d2d8) at /export/home/pb2/build/sb_0-29159266-1529069114.89/rpm/BUILD/mysql-5.6.41/mysql-5.6.41/storage/innobase/sync/sync0rw.cc:519

5 rw_lock_x_lock_low (line=658, file_name=0xc8dbb0 "/export/home/pb2/build/sb_0-29159266-1529069114.89/rpm/BUILD/mysql-5.6.41/mysql-5.6.41/storage/innobase/btr/btr0sea.cc", pass=0, lock=0x838d2d8) at /export/home/pb2/build/sb_0-29159266-1529069114.89/rpm/BUILD/mysql-5.6.41/mysql-5.6.41/storage/innobase/sync/sync0rw.cc:562

6 rw_lock_x_lock_func (lock=lock@entry=0x838d2d8, pass=pass@entry=0, file_name=file_name@entry=0xc8dbb0 "/export/home/pb2/build/sb_0-29159266-1529069114.89/rpm/BUILD/mysql-5.6.41/mysql-5.6.41/storage/innobase/btr/btr0sea.cc", line=line@entry=658) at /export/home/pb2/build/sb_0-29159266-1529069114.89/rpm/BUILD/mysql-5.6.41/mysql-5.6.41/storage/innobase/sync/sync0rw.cc:634

7 0x0000000000a34f50 in pfs_rw_lock_x_lock_func (pass=0, file_name=0xc8dbb0 "/export/home/pb2/build/sb_0-29159266-1529069114.89/rpm/BUILD/mysql-5.6.41/mysql-5.6.41/storage/innobase/btr/btr0sea.cc", line=658, lock=0x838d2d8) at /export/home/pb2/build/sb_0-

2回答

刘诚杰刘诚杰  数据库管理员 , 平安城科
yinxinzhanglj岳彩波等赞同了此回答
资源消耗高,不是看这个。而是看processlist里面有没有慢语句,然后配合sys中的视图和性能视图 显示全部

资源消耗高,不是看这个。而是看processlist里面有没有慢语句,然后配合sys中的视图和性能视图

收起
 6天前
浏览136
chenruiziyao 邀答
潘延晟潘延晟  系统工程师 , 通化市恒泰热力
aixchina赞同了此回答
可以开启MYSQL慢查询。看看到底哪些语句查询缓慢。 显示全部

可以开启MYSQL慢查询。看看到底哪些语句查询缓慢。

收起
 3天前

提问者

chenruiziyao系统测试工程师, 打杂

问题状态

  • 发布时间:6天前
  • 关注会员:3 人
  • 问题浏览:164
  • 最近回答:3天前
  • 关于TWT  使用指南  社区专家合作  厂商入驻社区  企业招聘  投诉建议  版权与免责声明  联系我们
    © 2018  talkwithtrend — talk with trend,talk with technologist 京ICP备09031017号-30