AI 助理
备案控制台
开发者社区 数据库 文章 正文

MySQL:FLTWL的堵塞和被堵塞总结

2018-08-07 2262
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
本文涉及的产品
RDS MySQL Serverless 基础系列，0.5-2RCU 50GB
推荐场景：
学生管理系统数据库设计 搭建个人博客
云数据库 RDS MySQL，集群系列 2核4GB
推荐场景：
搭建个人博客
云数据库 RDS MySQL，高可用系列 2核4GB
简介： 水平有限有误请指出，简单记录一下建议阅读：http://blog.itpub.net/7728585/viewspace-2143093/这是我以前写的一篇MDL LOCK的文章，比较详细。 FTWRL = flush tables with read lock MDL = META DATA LOCK 一、FTWRL的作用 总的说来flush tables with read lock多用于备份的时候对全局表进行锁定来获取binlog信息。

水平有限有误请指出，简单记录一下
建议阅读：
http://blog.itpub.net/7728585/viewspace-2143093/
这是我以前写的一篇MDL LOCK的文章，比较详细。

  • FTWRL = flush tables with read lock
  • MDL = META DATA LOCK

一、FTWRL的作用

总的说来flush tables with read lock多用于备份的时候对全局表进行锁定来获取binlog信息。虽然持有时间很短，单容易被堵塞造成备份不能完成。那么flush tables with read lock到底做了什么事情呢如下：

  • 获取MDL GLOBAL的S锁，直到unlock tables释放。
  • 获取MDL COMMIT的S锁，直到unlock tables释放。
  • 关闭所有的表重新打开，先释放table cache(包含TABLE_SHARED)，然后重新加载生成table cache。

（下面的信息是在源码函数 acquire_lock和release_lock增加输出达到的）
下面的信息可以看到flush tables with read lock获取MDL LOCK的信息：

2018-08-07T08:03:59.272547Z 7 [Note] [Call Acquire_lock] THIS MDL LOCK acquire [OK]:
2018-08-07T08:03:59.272583Z 7 [Note](>MDL PRINT) |Thread id is 7|Current_state: starting| 
2018-08-07T08:03:59.272599Z 7 [Note](--->MDL PRINT) Namespace is:GLOBAL 
2018-08-07T08:03:59.272613Z 7 [Note](----->MDL PRINT) Mdl type is:MDL_SHARED(S) 
2018-08-07T08:03:59.272627Z 7 [Note](------>MDL PRINT) Mdl  duration is:MDL_EXPLICIT 
2018-08-07T08:03:59.272642Z 7 [Note](------->MDL PRINT) Mdl  status is:EMPTY 
2018-08-07T08:03:59.292471Z 7 [Note] [Call Acquire_lock] THIS MDL LOCK acquire [OK]:
2018-08-07T08:03:59.292522Z 7 [Note](>MDL PRINT) |Thread id is 7|Current_state: starting| 
2018-08-07T08:03:59.292538Z 7 [Note](--->MDL PRINT) Namespace is:COMMIT 
2018-08-07T08:03:59.292551Z 7 [Note](----->MDL PRINT) Mdl type is:MDL_SHARED(S) 
2018-08-07T08:03:59.292564Z 7 [Note](------>MDL PRINT) Mdl  duration is:MDL_EXPLICIT 
2018-08-07T08:03:59.292580Z 7 [Note](------->MDL PRINT) Mdl  status is:EMPTY

下面是unlock tables释放MDL LOCK的信息：

2018-08-07T08:05:43.520540Z 7 [Note] [Call release_lock] this MDL LOCK will [RELEASE]:
2018-08-07T08:05:43.520571Z 7 [Note](>MDL PRINT) |Thread id is 7|Current_state: starting| 
2018-08-07T08:05:43.520597Z 7 [Note](--->MDL PRINT) Namespace is:COMMIT 
2018-08-07T08:05:43.520609Z 7 [Note](----->MDL PRINT) Mdl type is:MDL_SHARED(S) 
2018-08-07T08:05:43.520620Z 7 [Note](------>MDL PRINT) Mdl  duration is:MDL_EXPLICIT 
2018-08-07T08:05:43.520634Z 7 [Note](------->MDL PRINT) Mdl  status is:EMPTY 
2018-08-07T08:05:43.520658Z 7 [Note] [Call release_lock] this MDL LOCK will [RELEASE]:
2018-08-07T08:05:43.520671Z 7 [Note](>MDL PRINT) |Thread id is 7|Current_state: starting| 
2018-08-07T08:05:43.520682Z 7 [Note](--->MDL PRINT) Namespace is:GLOBAL 
2018-08-07T08:05:43.520693Z 7 [Note](----->MDL PRINT) Mdl type is:MDL_SHARED(S) 
2018-08-07T08:05:43.520704Z 7 [Note](------>MDL PRINT) Mdl  duration is:MDL_EXPLICIT 
2018-08-07T08:05:43.520727Z 7 [Note](------->MDL PRINT) Mdl  status is:EMPTY

如下是关于范围 MDL LOCK的兼容性：

          | Type of active   |
  Request |   scoped lock    |
   type   | IS(*)  IX   S  X |
 ---------+------------------+
 IS       |  +      +   +  + |
 IX       |  +      +   -  - |
 S        |  +      -   +  - |
 X        |  +      -   -  - |

二、常见操作关于和FTWRL MDL 相关锁。

  • 对于DMLFOR UPDATE：需要获取GLOBAL的IX锁持有到语句结束，但是TABLE MDL 持有到事物结束一般为(MDL_SHARED_WRITE(SW) )，DML提交的时候会持有COMMIT的IX锁。
  • SELECT： 不需要GLOBAL的IX锁，但是TABLE级别的MDL 需要持有到事物事物结束一般为(MDL_SHARED_READ(SR))。
  • DDL： 需要获取GLOBAL的IX锁到语句结束，TABLE MDL多变。

三、FTWRL的被什么堵塞

1、长时间的DDLDMLFOR UPDATE堵塞FTWRL，因为FTWRL需要获取 GLOBAL的S锁，而这些语句都会对GLOBAL持有IX（MDL_INTENTION_EXCLUSIVE）锁，根据兼容矩阵不兼容。

等待为：Waiting for global read lock
堵塞栈帧：

#0  0x0000003f7480ba5e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00000000018e7f33 in native_cond_timedwait (cond=0x7fff28009688, mutex=0x7fff28009640, abstime=0x7ffff0318a00)
    at /root/mysql5.7.14/percona-server-5.7.14-7/include/thr_cond.h:129
#2  0x00000000018e82a2 in safe_cond_timedwait (cond=0x7fff28009688, mp=0x7fff28009618, abstime=0x7ffff0318a00, 
    file=0x20013b8 "/root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc", line=1899) at /root/mysql5.7.14/percona-server-5.7.14-7/mysys/thr_cond.c:88
#3  0x00000000014a0149 in my_cond_timedwait (cond=0x7fff28009688, mp=0x7fff28009618, abstime=0x7ffff0318a00, 
    file=0x20013b8 "/root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc", line=1899) at /root/mysql5.7.14/percona-server-5.7.14-7/include/thr_cond.h:180
#4  0x00000000014a06ac in inline_mysql_cond_timedwait (that=0x7fff28009688, mutex=0x7fff28009618, abstime=0x7ffff0318a00, 
    src_file=0x20013b8 "/root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc", src_line=1899)
    at /root/mysql5.7.14/percona-server-5.7.14-7/include/mysql/psi/mysql_thread.h:1229
#5  0x00000000014a192b in MDL_wait::timed_wait (this=0x7fff28009618, owner=0x7fff28009510, abs_timeout=0x7ffff0318a00, set_status_on_timeout=true, 
    wait_state_name=0x2d132c0) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc:1899
#6  0x00000000014a38a7 in MDL_context::acquire_lock (this=0x7fff28009618, mdl_request=0x7ffff0318a70, lock_wait_timeout=31536000)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc:3714
#7  0x00000000017629ef in Global_read_lock::lock_global_read_lock (this=0x7fff2800b300, thd=0x7fff28009510)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/lock.cc:1131
#8  0x00000000015ec19a in reload_acl_and_cache (thd=0x7fff28009510, options=16388, tables=0x0, write_to_binlog=0x7ffff03199fc)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_reload.cc:222
#9  0x00000000015a9c27 in mysql_execute_command (thd=0x7fff28009510, first_level=true) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:4379
#10 0x00000000015adcd6 in mysql_parse (thd=0x7fff28009510, parser_state=0x7ffff031a600) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:5836
#11 0x00000000015a1b95 in dispatch_command (thd=0x7fff28009510, com_data=0x7ffff031ad70, command=COM_QUERY)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1447
#12 0x00000000015a09c6 in do_command (thd=0x7fff28009510) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1010
#13 0x00000000016e29d0 in handle_connection (arg=0x33d01c0) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/conn_handler/connection_handler_per_thread.cc:312
#14 0x0000000001d7b4b0 in pfs_spawn_thread (arg=0x38424d0) at /root/mysql5.7.14/percona-server-5.7.14-7/storage/perfschema/pfs.cc:2188
#15 0x0000003f74807aa1 in start_thread () from /lib64/libpthread.so.0
#16 0x0000003f740e8bcd in clone () from /lib64/libc.so.6
2、长时间的select堵塞FTWRL， 因为FTWRL要关闭所有的表，如果有活跃的语句正在执行table cache不能清空，因此需要等待。实际上即便是flush tables也不能在有语句执行的时候执行同样需要等待。

等待为：Waiting for table flush
堵塞栈帧：

#0  0x0000003f7480ba5e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00000000018e7f33 in native_cond_timedwait (cond=0x7fff28009688, mutex=0x7fff28009640, abstime=0x7ffff0318be0)
    at /root/mysql5.7.14/percona-server-5.7.14-7/include/thr_cond.h:129
#2  0x00000000018e82a2 in safe_cond_timedwait (cond=0x7fff28009688, mp=0x7fff28009618, abstime=0x7ffff0318be0, 
    file=0x20013b8 "/root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc", line=1899) at /root/mysql5.7.14/percona-server-5.7.14-7/mysys/thr_cond.c:88
#3  0x00000000014a0149 in my_cond_timedwait (cond=0x7fff28009688, mp=0x7fff28009618, abstime=0x7ffff0318be0, 
    file=0x20013b8 "/root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc", line=1899) at /root/mysql5.7.14/percona-server-5.7.14-7/include/thr_cond.h:180
#4  0x00000000014a06ac in inline_mysql_cond_timedwait (that=0x7fff28009688, mutex=0x7fff28009618, abstime=0x7ffff0318be0, 
    src_file=0x20013b8 "/root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc", src_line=1899)
    at /root/mysql5.7.14/percona-server-5.7.14-7/include/mysql/psi/mysql_thread.h:1229
#5  0x00000000014a192b in MDL_wait::timed_wait (this=0x7fff28009618, owner=0x7fff28009510, abs_timeout=0x7ffff0318be0, set_status_on_timeout=true, 
    wait_state_name=0x2d09d00) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc:1899
#6  0x00000000016a48ca in TABLE_SHARE::wait_for_old_version (this=0x7fff58984190, thd=0x7fff28009510, abstime=0x7ffff0318be0, deadlock_weight=100)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/table.cc:4585
#7  0x0000000001513e3a in close_cached_tables (thd=0x7fff28009510, tables=0x0, wait_for_refresh=true, timeout=31536000)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_base.cc:1289
#8  0x00000000015ec1d8 in reload_acl_and_cache (thd=0x7fff28009510, options=16388, tables=0x0, write_to_binlog=0x7ffff03199fc)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_reload.cc:224
#9  0x00000000015a9c27 in mysql_execute_command (thd=0x7fff28009510, first_level=true) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:4379
#10 0x00000000015adcd6 in mysql_parse (thd=0x7fff28009510, parser_state=0x7ffff031a600) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:5836
#11 0x00000000015a1b95 in dispatch_command (thd=0x7fff28009510, com_data=0x7ffff031ad70, command=COM_QUERY)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1447
#12 0x00000000015a09c6 in do_command (thd=0x7fff28009510) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1010
#13 0x00000000016e29d0 in handle_connection (arg=0x33d01c0) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/conn_handler/connection_handler_per_thread.cc:312
#14 0x0000000001d7b4b0 in pfs_spawn_thread (arg=0x38424d0) at /root/mysql5.7.14/percona-server-5.7.14-7/storage/perfschema/pfs.cc:2188
#15 0x0000003f74807aa1 in start_thread () from /lib64/libpthread.so.0
#16 0x0000003f740e8bcd in clone () from /lib64/libc.so.6
3、长时间的commit(如大事物提交)也会堵塞FTWRL，因为FTWRL需要获取COMMIT的S锁，而commit语句会对commit持有IX（MDL_INTENTION_EXCLUSIVE）锁，根据兼容矩阵不兼容。

等待为Waiting for commit lock

基本我们看到所有的语句都会堵塞FTWRL。

四、FTWRL堵塞什么

1、FTWRL会堵塞DDLDMLFOR UPDATE操作

等待为：Waiting for global read lock
堵塞栈帧：

#0  0x0000003f7480ba5e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00000000018e7f33 in native_cond_timedwait (cond=0x7fff58000ee8, mutex=0x7fff58000ea0, abstime=0x7ffff0359660)
    at /root/mysql5.7.14/percona-server-5.7.14-7/include/thr_cond.h:129
#2  0x00000000018e82a2 in safe_cond_timedwait (cond=0x7fff58000ee8, mp=0x7fff58000e78, abstime=0x7ffff0359660, 
    file=0x20013b8 "/root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc", line=1899) at /root/mysql5.7.14/percona-server-5.7.14-7/mysys/thr_cond.c:88
#3  0x00000000014a0149 in my_cond_timedwait (cond=0x7fff58000ee8, mp=0x7fff58000e78, abstime=0x7ffff0359660, 
    file=0x20013b8 "/root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc", line=1899) at /root/mysql5.7.14/percona-server-5.7.14-7/include/thr_cond.h:180
#4  0x00000000014a06ac in inline_mysql_cond_timedwait (that=0x7fff58000ee8, mutex=0x7fff58000e78, abstime=0x7ffff0359660, 
    src_file=0x20013b8 "/root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc", src_line=1899)
    at /root/mysql5.7.14/percona-server-5.7.14-7/include/mysql/psi/mysql_thread.h:1229
#5  0x00000000014a192b in MDL_wait::timed_wait (this=0x7fff58000e78, owner=0x7fff58000d70, abs_timeout=0x7ffff0359660, set_status_on_timeout=true, 
    wait_state_name=0x2d132c0) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc:1899
#6  0x00000000014a38a7 in MDL_context::acquire_lock (this=0x7fff58000e78, mdl_request=0x7ffff03596e0, lock_wait_timeout=31536000)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc:3714
#7  0x0000000001517a08 in open_table (thd=0x7fff58000d70, table_list=0x7fff58006a70, ot_ctx=0x7ffff0359b00)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_base.cc:3227
#8  0x000000000151b24f in open_and_process_table (thd=0x7fff58000d70, lex=0x7fff58003350, tables=0x7fff58006a70, counter=0x7fff58003410, flags=0, 
    prelocking_strategy=0x7ffff0359c30, has_prelocking_list=false, ot_ctx=0x7ffff0359b00) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_base.cc:5171
#9  0x000000000151c3ab in open_tables (thd=0x7fff58000d70, start=0x7ffff0359bf0, counter=0x7fff58003410, flags=0, prelocking_strategy=0x7ffff0359c30)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_base.cc:5789
#10 0x000000000151d7e5 in open_tables_for_query (thd=0x7fff58000d70, tables=0x7fff58006a70, flags=0) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_base.cc:6564
#11 0x00000000015acb58 in execute_sqlcom_select (thd=0x7fff58000d70, all_tables=0x7fff58006a70) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:5362
#12 0x00000000015a5320 in mysql_execute_command (thd=0x7fff58000d70, first_level=true) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:2889
#13 0x00000000015adcd6 in mysql_parse (thd=0x7fff58000d70, parser_state=0x7ffff035b600) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:5836
#14 0x00000000015a1b95 in dispatch_command (thd=0x7fff58000d70, com_data=0x7ffff035bd70, command=COM_QUERY)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1447
#15 0x00000000015a09c6 in do_command (thd=0x7fff58000d70) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1010
#16 0x00000000016e29d0 in handle_connection (arg=0x346f2b0) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/conn_handler/connection_handler_per_thread.cc:312
#17 0x0000000001d7b4b0 in pfs_spawn_thread (arg=0x38424d0) at /root/mysql5.7.14/percona-server-5.7.14-7/storage/perfschema/pfs.cc:2188
#18 0x0000003f74807aa1 in start_thread () from /lib64/libpthread.so.0
#19 0x0000003f740e8bcd in clone () from /lib64/libc.so.6
2、FTWRL会堵塞commit操作

等待为Waiting for commit lock
堵塞栈帧：

#0  0x0000003f7480ba5e in pthread_cond_timedwait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0
#1  0x00000000018e7f33 in native_cond_timedwait (cond=0x7fff58000ee8, mutex=0x7fff58000ea0, abstime=0x7ffff03599a0)
    at /root/mysql5.7.14/percona-server-5.7.14-7/include/thr_cond.h:129
#2  0x00000000018e82a2 in safe_cond_timedwait (cond=0x7fff58000ee8, mp=0x7fff58000e78, abstime=0x7ffff03599a0, 
    file=0x20013b8 "/root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc", line=1899) at /root/mysql5.7.14/percona-server-5.7.14-7/mysys/thr_cond.c:88
#3  0x00000000014a0149 in my_cond_timedwait (cond=0x7fff58000ee8, mp=0x7fff58000e78, abstime=0x7ffff03599a0, 
    file=0x20013b8 "/root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc", line=1899) at /root/mysql5.7.14/percona-server-5.7.14-7/include/thr_cond.h:180
#4  0x00000000014a06ac in inline_mysql_cond_timedwait (that=0x7fff58000ee8, mutex=0x7fff58000e78, abstime=0x7ffff03599a0, 
    src_file=0x20013b8 "/root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc", src_line=1899)
    at /root/mysql5.7.14/percona-server-5.7.14-7/include/mysql/psi/mysql_thread.h:1229
#5  0x00000000014a192b in MDL_wait::timed_wait (this=0x7fff58000e78, owner=0x7fff58000d70, abs_timeout=0x7ffff03599a0, set_status_on_timeout=true, 
    wait_state_name=0x2d13380) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc:1899
#6  0x00000000014a38a7 in MDL_context::acquire_lock (this=0x7fff58000e78, mdl_request=0x7ffff0359a10, lock_wait_timeout=31536000)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/mdl.cc:3714
#7  0x0000000000f63bd9 in ha_commit_trans (thd=0x7fff58000d70, all=true, ignore_global_read_lock=false)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/handler.cc:1783
#8  0x00000000016b36bb in trans_commit (thd=0x7fff58000d70) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/transaction.cc:239
#9  0x00000000015aa1f1 in mysql_execute_command (thd=0x7fff58000d70, first_level=true) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:4472
#10 0x00000000015adcd6 in mysql_parse (thd=0x7fff58000d70, parser_state=0x7ffff035b600) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:5836
#11 0x00000000015a1b95 in dispatch_command (thd=0x7fff58000d70, com_data=0x7ffff035bd70, command=COM_QUERY)
    at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1447
#12 0x00000000015a09c6 in do_command (thd=0x7fff58000d70) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/sql_parse.cc:1010
#13 0x00000000016e29d0 in handle_connection (arg=0x346f2b0) at /root/mysql5.7.14/percona-server-5.7.14-7/sql/conn_handler/connection_handler_per_thread.cc:312
#14 0x0000000001d7b4b0 in pfs_spawn_thread (arg=0x38424d0) at /root/mysql5.7.14/percona-server-5.7.14-7/storage/perfschema/pfs.cc:2188
#15 0x0000003f74807aa1 in start_thread () from /lib64/libpthread.so.0
#16 0x0000003f740e8bcd in clone () from /lib64/libc.so.6
3、FTWRL不会堵塞SELECT操作

五、percona对xtrbackup的改进

对于FTWRL percona做了改进应该是backup lock和binlog lock来代替。

具体参考如下：
https://www.percona.com/doc/percona-server/5.6/management/backup_locks.html?spm=5176.11156381.0.0.30d8e606aPdjeQ

六、总结

六、总结

  • FTWRL会被基本所有的常用语句堵塞如长时间的DDLDMLSELECTCOMMIT。
  • FTWRL会堵塞 DDLDMLCOMMIT，但是不会堵塞SELECT。直到unlock tables解锁。
文章标签：
云数据库 RDS MySQL 版
SQL
关系型数据库
MySQL
关键词：
云数据库 RDS MySQL 版总结
云数据库 RDS MySQL 版堵塞
云数据库 RDS MySQL 版堵塞总结
相关实践学习
如何在云端创建MySQL数据库
开始实验后，系统会自动创建一台自建MySQL的 源数据库 ECS 实例和一台 目标数据库 RDS。
全面了解阿里云能为你做什么
阿里云在全球各地部署高效节能的绿色数据中心，利用清洁计算为万物互联的新世界提供源源不断的能源动力，目前开服的区域包括中国（华北、华东、华南、香港）、新加坡、美国（美东、美西）、欧洲、中东、澳大利亚、日本。目前阿里云的产品涵盖弹性计算、数据库、存储与CDN、分析与搜索、云通信、网络、管理与监控、应用服务、互联网中间件、移动服务、视频服务等。通过本课程，来了解阿里云能够为你的业务带来哪些帮助     相关的阿里云产品：云服务器ECS 云服务器 ECS（Elastic Compute Service）是一种弹性可伸缩的计算服务，助您降低 IT 成本，提升运维效率，使您更专注于核心业务创新。产品详情: https://www.aliyun.com/product/ecs
重庆八怪
目录
相关文章
白鹿第一帅
|
SQL 搜索推荐 关系型数据库
MySQL 入门教程：全网最全，MySQL 增删改查高级命令硬核总结
MySQL 入门教程：全网最全，MySQL 增删改查高级命令硬核总结
白鹿第一帅
147 0
MySQL 入门教程：全网最全，MySQL 增删改查高级命令硬核总结
程序员飞鸟
|
SQL 存储 Oracle
（一）MySQL_数据库概述技术总结
简介：MySQL是一个关系型数据库管理系统，由瑞典MySQL AB 公司开发，2008年被Sun公司收购，2009年Sun 被Oracle收购。MySQL 是最流行的关系型数据库管理系统之一，在 WEB 应用方面，MySQL是最好的 RDBMS (Relational Database Management System，关系数据库管理系统) 应用软件之一。
程序员飞鸟
247 6
（一）MySQL_数据库概述技术总结
Kam
|
SQL 存储 关系型数据库
针对MySql百万级数据的分页（Limit/offset）性能低下问题解决方案总结
limit分页优化方案
Kam
1074 0
针对MySql百万级数据的分页（Limit/offset）性能低下问题解决方案总结
yqd666
|
SQL 存储 Oracle
MySQL总结
一.SQL语句简介 1.什么是SQL？ SQL(Structured Query Language):结构化查询语言 其实就是定义了操作所有关系型数据库的规则。每一种数据库操作的方式存在不一样的地方，称为“方言”
yqd666
134 0
MySQL总结
violentayang777-39923
|
SQL 存储 前端开发
MySQL知识点总结
MySQL知识点总结
violentayang777-39923
163 0
MySQL知识点总结
萌狼蓝天
|
关系型数据库 MySQL 数据库
【MySQL】MySQL命令总结 | 数据库与数据表的创建删除与查询
【MySQL】MySQL命令总结 | 数据库与数据表的创建删除与查询
萌狼蓝天
193 0
evqfvospscyim
|
存储 SQL 关系型数据库
MYSQL约束的总结和小练习
约束笔记： 1：主键约束默认是唯一且非空的 2：AUTO_INCREMENT在MYSQL8.0中会将自增主键保存到重做日志中，即使关闭后重启，存储引擎innoDB仍然会根据重做日志初始化计数器内存值。 3：设置了外键约束后，如果要删除主表的内容，则需要先把从表的相关内容给删除。 4：建表时一般设置not null default '' 或default 0，因为nul这个特殊值不好比较，而且查找效率低。 5：外键约束不能跨引擎使用，且mysql中其有一定成本，不适合大并发SQL操作，开发中一般在.
evqfvospscyim
205 0
MYSQL约束的总结和小练习
fanstuck
|
存储 SQL JSON
MySQL技能树学习总结
MySQL技能树学习总结
fanstuck
239 0
MySQL技能树学习总结
东风_
|
SQL 存储 数据可视化
mysql总结
-
东风_
156 0
仙士可
|
SQL 关系型数据库 MySQL
mysql中lock tables与unlock tables(锁表/解锁)使用总结
mysql中lock tables与unlock tables(锁表/解锁)使用总结
仙士可
396 0

热门文章

最新文章

  • 1
    RDS入门——Excel文件转存到RDS数据库实践
  • 2
    PostgreSQL SQL HINT的使用
  • 3
    mysql安装过程
  • 4
    Mysql数据库初始化后更改数据存储目录
  • 5
    MySQL学习笔记_2_MySQL创建数据表（上）
  • 6
    MySQL服务器 IO 100%的案例分析
  • 7
    MySQL和Oracle的添加字段的处理差别
  • 8
    [MySQL]命令行工具和基本操作
  • 9
    PostgreSQL:系统表pg_attribute膨胀解决方案
  • 10
    mysql中的时间函数---运维常用
  • 1
    Java医院绩效考核系统源码B/S+avue+MySQL助力医院实现精细化管理
    76
  • 2
    Linux对MySQL语法校验
    89
  • 3
    【MySQL系列笔记】分库分表
    206
  • 4
    mysql 设置环境变量与未设置环境变量连接数据库的区别
    161
  • 5
    服务器Linux系统配置mysql数据库主从自动备份
    214
  • 6
    mysqlTools 一分钟部署安装本mysql多个版本，解锁繁琐部署过程
    419
  • 7
    golang使用gorm操作mysql3，数据查询
    97
  • 8
    golang使用gorm操作mysql2
    61
  • 9
    golang使用gorm操作mysql1
    112
  • 10
    Hbase与MySQL对比，区别是什么？
    303

    • 相关课程

    更多
  • MySQL企业常见架构与调优经验分享
  • 云数据库MySQL版快速上手教程
  • 阿里云云原生数据仓库AnalyticDB MySQL版 使用教程
  • MySQL实战进阶
  • 数据库及SQL/MySQL基础
  • 云数据库MySQL快速入门

    • 相关电子书

    更多
  • One Box： 解读事务与分析一体化数据库 HybridDB for MySQL
  • One Box：解读事务与分析一体化数据库HybridDB for MySQL
  • 如何支撑HTAP场景-HybridDB for MySQL系统架构和技术演进

    • 相关实验场景

    更多
  • MySQL引擎及架构优化
  • 基于EBS部署高性能的MySQL服务
  • 5分钟上手Flink MySQL连接器
  • 云端MySQL的安装及应用
  • 手动部署MySQL数据库（Alibaba Cloud Linux 2）
  • 手动部署MySQL数据库（CentOS 7）

    • 推荐镜像

    更多
  • mysql
  • mariadb
  • postgresql
    • 下一篇
    fs.oss.accessKeyId和fs.oss.accessKeySecret。