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

Thread 28 (Thread 0x7f1d29a10700 (LWP 4030)):0 0x00007f1e809cc995 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.01 0x00000000009757f9 in os_cond_wait (fast_mutex=0x838d3f0, cond=0x838d430) at /export/home/pb2/build/sb_0-29159266-15...显示全部

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-

收起
参与19

查看其它 1 个回答pysx0503的回答

pysx0503pysx0503  系统工程师 , 第十区。散人

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

系统集成 · 2018-11-12
浏览2486
陈锐 邀答

回答者

pysx0503
pysx0503153369
系统工程师第十区。散人
擅长领域: 存储备份服务器

pysx0503 最近回答过的问题

回答状态

  • 发布时间:2018-11-12
  • 关注会员:3 人
  • 回答浏览:2486
  • X社区推广