mysql锁争用_MYSQL connector/.NET 默认的 show variables 引起的线程mutex锁争用

+————–+——+——————-+———–+———+——+————–+—————-+

| THREAD_OS_ID | user | host | db | command | time | state   | info |

+————–+——+——————-+———–+———+——+————–+—————-+

|

26089 | root | ACS-SCN-DB1:48088 | employees | Query | 0 |

Sending data | SHOW VARIABLES   |

《《《《《《《

======

处于

Sending   data

状态

Thread 187 (Thread 0x7fa8149c6700 (

LWP

26089)):

#0 0x00007fa8dadb354d in

__lll_lock_wait () from /lib64/libpthread.so.0

《《《《《《《

======

锁等待

#1 0x00007fa8dadaeed1 in

_L_lock_1093 ()from /lib64/libpthread.so.0

《《《《《《《

======

L_lock_1093 ()

#2 0x00007fa8dadaee72 in

pthread_mutex_lock   ()from /lib64/libpthread.so.0

《《《《《《《

======

线程互斥锁

#3 0x00000000011df234

in   native_mutex_lock(mutex=) at   /export/home/pb2/build/sb_0-37309218-1576676677.02/mysql-5.7.29/include/thr_mutex.h:91

#4 my_mutex_lock (mp=) at   /export/home/pb2/build/sb_0-37309218-1576676677.02/mysql-5.7.29/include/thr_mutex.h:189

#5 inline_mysql_mutex_lock (src_line=80, src_file=0x17f10f0   “/export/home/pb2/build/sb_0-37309218-1576676677.02/mysql-5.7.29/storage/perfschema/table_session_variables.cc”,   that=) at /export/home/pb2/build/sb_0-37309218-1576676677.02/mysql-5.7.29/include/mysql/psi/mysql_thread.h:722

#6 table_session_variables::get_row_count () at   /export/home/pb2/build/sb_0-37309218-1576676677.02/mysql-5.7.29/storage/perfschema/table_session_variables.cc:80

#7 0x0000000001185fdf in ha_perfschema::info   (this=0x7fa6c806a000, flag=) at   /export/home/pb2/build/sb_0-37309218-1576676677.02/mysql-5.7.29/storage/perfschema/ha_perfschema.cc:400

#8 0x0000000000d8f125 in make_join_readinfo   (join=0x7fa7ec0707d0, no_jbuf_after=) at   /export/home/pb2/build/sb_0-37309218-1576676677.02/mysql-5.7.29/sql/sql_select.cc:2222

。。。。。。

(thd=0x7fa7ec037630, com_data=0x7fa8149c5da0,   command=COM_QUERY) at   /export/home/pb2/build/sb_0-37309218-1576676677.02/mysql-5.7.29/sql/sql_parse.cc:1491

#20 0x0000000000d529e4 in do_command (thd=0x7fa7ec037630)   at   /export/home/pb2/build/sb_0-37309218-1576676677.02/mysql-5.7.29/sql/sql_parse.cc:1032

#21 0x0000000000e24dcc in handle_connection   (arg=) at /export/home/pb2/build/sb_0-37309218-1576676677.02/mysql-5.7.29/sql/conn_handler/connection_handler_per_thread.cc:313

#22 0x0000000001188c74 in pfs_spawn_thread (arg=0x7d25480)   at   /export/home/pb2/build/sb_0-37309218-1576676677.02/mysql-5.7.29/storage/perfschema/pfs.cc:2197

#23 0x00007fa8dadacea5 in start_thread () from   /lib64/libpthread.so.0

#24 0x00007fa8d98658cd in clone () from /lib64/libc.so.6