mysql show tables_mysql>SHOW TABLES卡住

几分钟了，还没有返回结果

strace查看mysqld进程，得到返回如下

[root@zj100-host ~]# strace -p 5060

Process 5060 attached - interrupt to quit

select(13, [10 12], NULL, NULL, NULL) = 1 (in [10])

fcntl(10, F_SETFL, O_RDWR|O_NONBLOCK) = 0

accept(10, {sa_family=AF_INET, sin_port=htons(36954), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 14

fcntl(10, F_SETFL, O_RDWR) = 0

getsockname(14, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 0

fcntl(14, F_SETFL, O_RDONLY) = 0

fcntl(14, F_GETFL) = 0x2 (flags O_RDWR)

fcntl(14, F_SETFL, O_RDWR|O_NONBLOCK) = 0

setsockopt(14, SOL_IP, IP_TOS, [8], 4) = 0

setsockopt(14, SOL_TCP, TCP_NODELAY, [1], 4) = 0

time(NULL) = 1314580587

clone(child_stack=0x45b22210, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x45b229d0, tls=0x45b22940, child_tidptr=0x45b229d0) = 8195

select(13, [10 12], NULL, NULL, NULL) = 1 (in [10])

fcntl(10, F_SETFL, O_RDWR|O_NONBLOCK) = 0

accept(10, {sa_family=AF_INET, sin_port=htons(36955), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 15

fcntl(10, F_SETFL, O_RDWR) = 0

getsockname(15, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 0

fcntl(15, F_SETFL, O_RDONLY) = 0

fcntl(15, F_GETFL) = 0x2 (flags O_RDWR)

fcntl(15, F_SETFL, O_RDWR|O_NONBLOCK) = 0

setsockopt(15, SOL_IP, IP_TOS, [8], 4) = 0

setsockopt(15, SOL_TCP, TCP_NODELAY, [1], 4) = 0

time(NULL) = 1314580587

clone(child_stack=0x45ae1210, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x45ae19d0, tls=0x45ae1940, child_tidptr=0x45ae19d0) = 8196

select(13, [10 12], NULL, NULL, NULL) = 1 (in [10])

fcntl(10, F_SETFL, O_RDWR|O_NONBLOCK) = 0

accept(10, {sa_family=AF_INET, sin_port=htons(36956), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 16

fcntl(10, F_SETFL, O_RDWR) = 0

getsockname(16, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 0

fcntl(16, F_SETFL, O_RDONLY) = 0

fcntl(16, F_GETFL) = 0x2 (flags O_RDWR)

fcntl(16, F_SETFL, O_RDWR|O_NONBLOCK) = 0

setsockopt(16, SOL_IP, IP_TOS, [8], 4) = 0

setsockopt(16, SOL_TCP, TCP_NODELAY, [1], 4) = 0

time(NULL) = 1314580587

clone(child_stack=0x45aa0210, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x45aa09d0, tls=0x45aa0940, child_tidptr=0x45aa09d0) = 8197

select(13, [10 12], NULL, NULL, NULL) = 1 (in [10])

fcntl(10, F_SETFL, O_RDWR|O_NONBLOCK) = 0

accept(10, {sa_family=AF_INET, sin_port=htons(36957), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 14

fcntl(10, F_SETFL, O_RDWR) = 0

getsockname(14, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 0

fcntl(14, F_SETFL, O_RDONLY) = 0

fcntl(14, F_GETFL) = 0x2 (flags O_RDWR)

fcntl(14, F_SETFL, O_RDWR|O_NONBLOCK) = 0

setsockopt(14, SOL_IP, IP_TOS, [8], 4) = 0

setsockopt(14, SOL_TCP, TCP_NODELAY, [1], 4) = 0

time(NULL) = 1314580767

clone(child_stack=0x45aa0210, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x45aa09d0, tls=0x45aa0940, child_tidptr=0x45aa09d0) = 8202

select(13, [10 12], NULL, NULL, NULL) = 1 (in [10])

fcntl(10, F_SETFL, O_RDWR|O_NONBLOCK) = 0

accept(10, {sa_family=AF_INET, sin_port=htons(36958), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 15

fcntl(10, F_SETFL, O_RDWR) = 0

getsockname(15, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 0

fcntl(15, F_SETFL, O_RDONLY) = 0

fcntl(15, F_GETFL) = 0x2 (flags O_RDWR)

fcntl(15, F_SETFL, O_RDWR|O_NONBLOCK) = 0

setsockopt(15, SOL_IP, IP_TOS, [8], 4) = 0

setsockopt(15, SOL_TCP, TCP_NODELAY, [1], 4) = 0

time(NULL) = 1314580767

clone(child_stack=0x45b22210, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x45b229d0, tls=0x45b22940, child_tidptr=0x45b229d0) = 8203

select(13, [10 12], NULL, NULL, NULL) = 1 (in [10])

fcntl(10, F_SETFL, O_RDWR|O_NONBLOCK) = 0

accept(10, {sa_family=AF_INET, sin_port=htons(36959), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 16

fcntl(10, F_SETFL, O_RDWR) = 0

getsockname(16, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 0

fcntl(16, F_SETFL, O_RDONLY) = 0

fcntl(16, F_GETFL) = 0x2 (flags O_RDWR)

fcntl(16, F_SETFL, O_RDWR|O_NONBLOCK) = 0

setsockopt(16, SOL_IP, IP_TOS, [8], 4) = 0

setsockopt(16, SOL_TCP, TCP_NODELAY, [1], 4) = 0

time(NULL) = 1314580767

clone(child_stack=0x45ae1210, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x45ae19d0, tls=0x45ae1940, child_tidptr=0x45ae19d0) = 8204

select(13, [10 12], NULL, NULL, NULL) = 1 (in [10])

fcntl(10, F_SETFL, O_RDWR|O_NONBLOCK) = 0

accept(10, {sa_family=AF_INET, sin_port=htons(39832), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 14

fcntl(10, F_SETFL, O_RDWR) = 0

getsockname(14, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 0

fcntl(14, F_SETFL, O_RDONLY) = 0

fcntl(14, F_GETFL) = 0x2 (flags O_RDWR)

fcntl(14, F_SETFL, O_RDWR|O_NONBLOCK) = 0

setsockopt(14, SOL_IP, IP_TOS, [8], 4) = 0

setsockopt(14, SOL_TCP, TCP_NODELAY, [1], 4) = 0

time(NULL) = 1314580947

clone(child_stack=0x45ae1210, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x45ae19d0, tls=0x45ae1940, child_tidptr=0x45ae19d0) = 8211

select(13, [10 12], NULL, NULL, NULL) = 1 (in [10])

fcntl(10, F_SETFL, O_RDWR|O_NONBLOCK) = 0

accept(10, {sa_family=AF_INET, sin_port=htons(39833), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 15

fcntl(10, F_SETFL, O_RDWR) = 0

getsockname(15, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 0

fcntl(15, F_SETFL, O_RDONLY) = 0

fcntl(15, F_GETFL) = 0x2 (flags O_RDWR)

fcntl(15, F_SETFL, O_RDWR|O_NONBLOCK) = 0

setsockopt(15, SOL_IP, IP_TOS, [8], 4) = 0

setsockopt(15, SOL_TCP, TCP_NODELAY, [1], 4) = 0

time(NULL) = 1314580947

clone(child_stack=0x45b22210, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x45b229d0, tls=0x45b22940, child_tidptr=0x45b229d0) = 8212

select(13, [10 12], NULL, NULL, NULL) = 1 (in [10])

fcntl(10, F_SETFL, O_RDWR|O_NONBLOCK) = 0

accept(10, {sa_family=AF_INET, sin_port=htons(39834), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 16

fcntl(10, F_SETFL, O_RDWR) = 0

getsockname(16, {sa_family=AF_INET, sin_port=htons(3306), sin_addr=inet_addr("127.0.0.1")}, [16864854713185599504]) = 0

fcntl(16, F_SETFL, O_RDONLY) = 0

fcntl(16, F_GETFL) = 0x2 (flags O_RDWR)

fcntl(16, F_SETFL, O_RDWR|O_NONBLOCK) = 0

setsockopt(16, SOL_IP, IP_TOS, [8], 4) = 0

setsockopt(16, SOL_TCP, TCP_NODELAY, [1], 4) = 0

time(NULL) = 1314580947

clone(child_stack=0x45aa0210, flags=CLONE_VM|CLONE_FS|CLONE_FILES|CLONE_SIGHAND|CLONE_THREAD|CLONE_SYSVSEM|CLONE_SETTLS|CLONE_PARENT_SETTID|CLONE_CHILD_CLEARTID, parent_tidptr=0x45aa09d0, tls=0x45aa0940, child_tidptr=0x45aa09d0) = 8213

select(13, [10 12], NULL, NULL, NULL

问题补充：

AngelAndAngel 写道

被锁了吧。先输入命令 unlock tables;

然后再show。

谢谢

我发现没有有命令末尾敲“;”~~~