怎么使用MySQL中的character_set_server影响参数
发表于:2025-01-24 作者:千家信息网编辑
千家信息网最后更新 2025年01月24日,这篇文章主要讲解了"怎么使用MySQL中的character_set_server影响参数",文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习"怎么使用MyS
千家信息网最后更新 2025年01月24日怎么使用MySQL中的character_set_server影响参数
这篇文章主要讲解了"怎么使用MySQL中的character_set_server影响参数",文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习"怎么使用MySQL中的character_set_server影响参数"吧!
Waiting for global read lock:由于flush table with read lock调用函数lock_global_read_lock导致DML操作堵塞。
Waiting for commit lock :由于flush table with read lock 调用函数make_global_read_lock_block_commit导致事务不能提交
现象
堵塞COMMIT和DML
mysql> show processlist;+----+-----------------+-----------+---------+---------+------+------------------------------+----------------------------+-----------+---------------+| Id | User | Host | db | Command | Time | State | Info | Rows_sent | Rows_examined |+----+-----------------+-----------+---------+---------+------+------------------------------+----------------------------+-----------+---------------+| 1 | event_scheduler | localhost | NULL | Daemon | 268 | Waiting on empty queue | NULL | 0 | 0 || 5 | root | localhost | NULL | Query | 0 | starting | show processlist | 0 | 0 || 6 | root | localhost | testmts | Query | 61 | Waiting for commit lock | commit | 0 | 0 || 7 | root | localhost | testmts | Query | 6 | Waiting for global read lock | delete from testcp limit 1 | 0 | 0 |+----+-----------------+-----------+---------+---------+------+------------------------------+----------------------------+-----------+---------------+
相关栈帧
Waiting for commit lock
#0 0x00007ffff7bd3a5e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0#1 0x000000000192027b in native_cond_timedwait (cond=0x7ffee0000d08, mutex=0x7ffee0000cc0, abstime=0x7fffec5ec950) at /mysqldata/percona-server-locks-detail-5.7.22/include/thr_cond.h:129#2 0x00000000019205ea in safe_cond_timedwait (cond=0x7ffee0000d08, mp=0x7ffee0000c98, abstime=0x7fffec5ec950, file=0x204cdd0 "/mysqldata/percona-server-locks-detail-5.7.22/sql/mdl.cc", line=1899) at /mysqldata/percona-server-locks-detail-5.7.22/mysys/thr_cond.c:88#3 0x00000000014b9f21 in my_cond_timedwait (cond=0x7ffee0000d08, mp=0x7ffee0000c98, abstime=0x7fffec5ec950, file=0x204cdd0 "/mysqldata/percona-server-locks-detail-5.7.22/sql/mdl.cc", line=1899) at /mysqldata/percona-server-locks-detail-5.7.22/include/thr_cond.h:180#4 0x00000000014ba484 in inline_mysql_cond_timedwait (that=0x7ffee0000d08, mutex=0x7ffee0000c98, abstime=0x7fffec5ec950, src_file=0x204cdd0 "/mysqldata/percona-server-locks-detail-5.7.22/sql/mdl.cc", src_line=1899) at /mysqldata/percona-server-locks-detail-5.7.22/include/mysql/psi/mysql_thread.h:1229#5 0x00000000014bb702 in MDL_wait::timed_wait (this=0x7ffee0000c98, owner=0x7ffee0000c00, abs_timeout=0x7fffec5ec950, set_status_on_timeout=true, wait_state_name=0x2d93240) at /mysqldata/percona-server-locks-detail-5.7.22/sql/mdl.cc:1899#6 0x00000000014bd7ac in MDL_context::acquire_lock (this=0x7ffee0000c98, mdl_request=0x7fffec5ec9c0, lock_wait_timeout=31536000) at /mysqldata/percona-server-locks-detail-5.7.22/sql/mdl.cc:3746#7 0x0000000000f7ffe4 in ha_commit_trans (thd=0x7ffee0000c00, all=true, ignore_global_read_lock=false) at /mysqldata/percona-server-locks-detail-5.7.22/sql/handler.cc:1795#8 0x00000000016dcd2f in trans_commit (thd=0x7ffee0000c00) at /mysqldata/percona-server-locks-detail-5.7.22/sql/transaction.cc:239#9 0x00000000015cf466 in mysql_execute_command (thd=0x7ffee0000c00, first_level=true) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_parse.cc:4526#10 0x00000000015d2fde in mysql_parse (thd=0x7ffee0000c00, parser_state=0x7fffec5ee600) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_parse.cc:5901#11 0x00000000015c6b72 in dispatch_command (thd=0x7ffee0000c00, com_data=0x7fffec5eed70, command=COM_QUERY) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_parse.cc:1490#12 0x00000000015c58ff in do_command (thd=0x7ffee0000c00) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_parse.cc:1021#13 0x000000000170e578 in handle_connection (arg=0x67bf490) at /mysqldata/percona-server-locks-detail-5.7.22/sql/conn_handler/connection_handler_per_thread.cc:312#14 0x0000000001945538 in pfs_spawn_thread (arg=0x66ff4f0) at /mysqldata/percona-server-locks-detail-5.7.22/storage/perfschema/pfs.cc:2190#15 0x00007ffff7bcfaa1 in start_thread () from /lib64/libpthread.so.0#16 0x00007ffff6b37c4d in clone () from /lib64/libc.so.6
Waiting for global read lock
#0 0x00007ffff7bd3a5e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0#1 0x000000000192027b in native_cond_timedwait (cond=0x7ffee4000c98, mutex=0x7ffee4000c50, abstime=0x7fffec58a0e0) at /mysqldata/percona-server-locks-detail-5.7.22/include/thr_cond.h:129#2 0x00000000019205ea in safe_cond_timedwait (cond=0x7ffee4000c98, mp=0x7ffee4000c28, abstime=0x7fffec58a0e0, file=0x204cdd0 "/mysqldata/percona-server-locks-detail-5.7.22/sql/mdl.cc", line=1899) at /mysqldata/percona-server-locks-detail-5.7.22/mysys/thr_cond.c:88#3 0x00000000014b9f21 in my_cond_timedwait (cond=0x7ffee4000c98, mp=0x7ffee4000c28, abstime=0x7fffec58a0e0, file=0x204cdd0 "/mysqldata/percona-server-locks-detail-5.7.22/sql/mdl.cc", line=1899) at /mysqldata/percona-server-locks-detail-5.7.22/include/thr_cond.h:180#4 0x00000000014ba484 in inline_mysql_cond_timedwait (that=0x7ffee4000c98, mutex=0x7ffee4000c28, abstime=0x7fffec58a0e0, src_file=0x204cdd0 "/mysqldata/percona-server-locks-detail-5.7.22/sql/mdl.cc", src_line=1899) at /mysqldata/percona-server-locks-detail-5.7.22/include/mysql/psi/mysql_thread.h:1229#5 0x00000000014bb702 in MDL_wait::timed_wait (this=0x7ffee4000c28, owner=0x7ffee4000b90, abs_timeout=0x7fffec58a0e0, set_status_on_timeout=true, wait_state_name=0x2d93180) at /mysqldata/percona-server-locks-detail-5.7.22/sql/mdl.cc:1899#6 0x00000000014bd7ac in MDL_context::acquire_lock (this=0x7ffee4000c28, mdl_request=0x7fffec58a160, lock_wait_timeout=31536000) at /mysqldata/percona-server-locks-detail-5.7.22/sql/mdl.cc:3746#7 0x000000000153bed8 in open_table (thd=0x7ffee4000b90, table_list=0x7ffee40066e0, ot_ctx=0x7fffec58a5a0) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_base.cc:3233#8 0x000000000153f904 in open_and_process_table (thd=0x7ffee4000b90, lex=0x7ffee40031c0, tables=0x7ffee40066e0, counter=0x7ffee4003280, flags=0, prelocking_strategy=0x7fffec58a6d0, has_prelocking_list=false, ot_ctx=0x7fffec58a5a0) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_base.cc:5213#9 0x0000000001540a58 in open_tables (thd=0x7ffee4000b90, start=0x7fffec58a690, counter=0x7ffee4003280, flags=0, prelocking_strategy=0x7fffec58a6d0) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_base.cc:5831#10 0x0000000001541e93 in open_tables_for_query (thd=0x7ffee4000b90, tables=0x7ffee40066e0, flags=0) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_base.cc:6606#11 0x00000000017f2b53 in Sql_cmd_delete::mysql_delete (this=0x7ffee4006c80, thd=0x7ffee4000b90, limit=1) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_delete.cc:76#12 0x00000000017f7098 in Sql_cmd_delete::execute (this=0x7ffee4006c80, thd=0x7ffee4000b90) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_delete.cc:1386#13 0x00000000015cc801 in mysql_execute_command (thd=0x7ffee4000b90, first_level=true) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_parse.cc:3756#14 0x00000000015d2fde in mysql_parse (thd=0x7ffee4000b90, parser_state=0x7fffec58c600) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_parse.cc:5901#15 0x00000000015c6b72 in dispatch_command (thd=0x7ffee4000b90, com_data=0x7fffec58cd70, command=COM_QUERY) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_parse.cc:1490#16 0x00000000015c58ff in do_command (thd=0x7ffee4000b90) at /mysqldata/percona-server-locks-detail-5.7.22/sql/sql_parse.cc:1021#17 0x000000000170e578 in handle_connection (arg=0x67182c0) at /mysqldata/percona-server-locks-detail-5.7.22/sql/conn_handler/connection_handler_per_thread.cc:312#18 0x0000000001945538 in pfs_spawn_thread (arg=0x671aca0) at /mysqldata/percona-server-locks-detail-5.7.22/storage/perfschema/pfs.cc:2190#19 0x00007ffff7bcfaa1 in start_thread () from /lib64/libpthread.so.0#20 0x00007ffff6b37c4d in clone () from /lib64/libc.so.6
感谢各位的阅读,以上就是"怎么使用MySQL中的character_set_server影响参数"的内容了,经过本文的学习后,相信大家对怎么使用MySQL中的character_set_server影响参数这一问题有了更深刻的体会,具体使用情况还需要大家实践验证。这里是,小编将为大家推送更多相关知识点的文章,欢迎关注!
参数
影响
学习
内容
函数
事务
就是
思路
情况
文章
更多
现象
知识
知识点
篇文章
跟着
问题
实践
推送
研究
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
申请自定义服务器
一般数据库怎么查的
打多久王者荣耀服务器会崩
贵州正规网络技术服务资费
王牌战争怎么开社区服务器
下载app的软件开发票
武汉理工大学数据库复习题
天津移动网络技术类工资
安全模式下数据库备份
苹果服务器连接不上影响用手机么
计算机三级网络技术考试规则
摩尔庄园不同服务器能结婚吗
浙江艾泽网络技术有限公司
数据库1267错误
深圳盛辰网络技术有限公司
mc服务器血量条mod
网络安全法危害
安康网络技术产品介绍
珠海菁航网络技术有限公司
南非是玩什么服务器游戏
一般数据库怎么查的
常州科研项目管控软件开发平台
数据库网络适配器无法连接
鹰潭企业服务器价格
中国林业数据库2.0
电力网络安全检查工作总结
c ftp服务器
宝山区品牌网络技术代理价格
传奇游戏要多大服务器
长沙多迪网络技术