Post

Mysql MDL

Posted
By Xiong Ding 1 min read

Metadata lock

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

#0  open_tables_for_query (thd=0xffff2c001050, tables=0xffff2c0fdd58, flags=0)
    at /code/mysql-server/sql/sql_base.cc:6729
#1  0x0000aaaaae2e4b80 in Sql_cmd_dml::prepare (this=0xffff2c0ff7f0, thd=0xffff2c001050)
    at /code/mysql-server/sql/sql_select.cc:360
#2  0x0000aaaaae2e5630 in Sql_cmd_dml::execute (this=0xffff2c0ff7f0, thd=0xffff2c001050)
    at /code/mysql-server/sql/sql_select.cc:534
#3  0x0000aaaaae25d7f0 in mysql_execute_command (thd=0xffff2c001050, first_level=true)
    at /code/mysql-server/sql/sql_parse.cc:4677
#4  0x0000aaaaae25f7fc in dispatch_sql_command (thd=0xffff2c001050, parser_state=0xffffe067d3e8)
    at /code/mysql-server/sql/sql_parse.cc:5312
#5  0x0000aaaaae2568c4 in dispatch_command (thd=0xffff2c001050, com_data=0xffffe067dd00, command=COM_QUERY)
    at /code/mysql-server/sql/sql_parse.cc:2032
#6  0x0000aaaaae254cd4 in do_command (thd=0xffff2c001050) at /code/mysql-server/sql/sql_parse.cc:1435
#7  0x0000aaaaae48a9ec in handle_connection (arg=0xaaaab6470820)
    at /code/mysql-server/sql/conn_handler/connection_handler_per_thread.cc:302
#8  0x0000aaaab0708810 in pfs_spawn_thread (arg=0xaaaab64b4830) at /code/mysql-server/storage/perfschema/pfs.cc:2986
#9  0x0000fffff759d5c8 in start_thread (arg=0x0) at ./nptl/pthread_create.c:442
#10 0x0000fffff7605d1c in thread_start () at ../sysdeps/unix/sysv/linux/aarch64/clone.S:79
database, mysql
mysql
This post is licensed under CC BY 4.0 by the author.