首页 / MYSQL / gdb调试之---当commit时碰到的第一个等待事件是什么？

gdb调试之---当commit时碰到的第一个等待事件是什么？

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了gdb调试之---当commit时碰到的第一个等待事件是什么？，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含11129字，纯文字阅读大概需要16分钟。

内容图文

转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/18458231 还是接着上一篇文章的实验：gdb调试之---当update时第一个持有的Latch是什么Latch锁？ 1、退出gdb (gdb) qThe program is running. Quit anyway (and detach it)? (y or n) yDetachi

转载请注明出处：http://blog.csdn.net/guoyjoe/article/details/18458231

还是接着上一篇文章的实验：gdb调试之---当update时第一个持有的Latch是什么Latch锁？

1、退出gdb

(gdb) q
The program is running.  Quit anyway (and detach it)? (y or n) y
Detaching from program: /u01/app/oracle/product/11.2.0/bin/oracle, process 7376

[oracle@mydb ~]$ gdb $ORACLE_HOME/bin/oracle 7376
GNU gdb Fedora (6.8-27.el5)
Copyright (C) 2008 Free Software Foundation, Inc.
License GPLv3+: GNU GPL version 3 or later <http://gnu.org/licenses/gpl.html>
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law. Type "show copying"
and "show warranty" for details.
This GDB was configured as "x86_64-redhat-linux-gnu"...
(no debugging symbols found)
Attaching to program: /u01/app/oracle/product/11.2.0/bin/oracle, process 7376
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libodm11.so...(no debugging symbols found)...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libodm11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libcell11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libcell11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libskgxp11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libskgxp11.so
Reading symbols from /lib64/librt.so.1...done.
Loaded symbols for /lib64/librt.so.1
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libnnz11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libnnz11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libclsra11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libclsra11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libdbcfg11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libdbcfg11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libhasgen11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libhasgen11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libskgxn2.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libskgxn2.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libocr11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libocr11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libocrb11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libocrb11.so
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libocrutl11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libocrutl11.so
Reading symbols from /usr/lib64/libaio.so.1...done.
Loaded symbols for /usr/lib64/libaio.so.1
Reading symbols from /lib64/libdl.so.2...done.
Loaded symbols for /lib64/libdl.so.2
Reading symbols from /lib64/libm.so.6...done.
Loaded symbols for /lib64/libm.so.6
Reading symbols from /lib64/libpthread.so.0...done.
[Thread debugging using libthread_db enabled]
[New Thread 0x2b0b8fef0910 (LWP 7376)]
Loaded symbols for /lib64/libpthread.so.0
Reading symbols from /lib64/libnsl.so.1...done.
Loaded symbols for /lib64/libnsl.so.1
Reading symbols from /lib64/libc.so.6...done.
Loaded symbols for /lib64/libc.so.6
Reading symbols from /lib64/ld-linux-x86-64.so.2...done.
Loaded symbols for /lib64/ld-linux-x86-64.so.2
Reading symbols from /usr/lib64/libnuma.so.1...done.
Loaded symbols for /usr/lib64/libnuma.so.1
Reading symbols from /lib64/libnss_files.so.2...done.
Loaded symbols for /lib64/libnss_files.so.2
Reading symbols from /u01/app/oracle/product/11.2.0/lib/libnque11.so...done.
Loaded symbols for /u01/app/oracle/product/11.2.0/lib/libnque11.so
0x0000003f0d40d290 in __read_nocancel () from /lib64/libpthread.so.0
(gdb)

3、执行commit，commit被阻塞了。

gyj@OCM> commit;

(gdb) b kslwtbctx
Breakpoint 1 at 0x8f9a5c2
(gdb) c
Continuing.

Breakpoint 1, 0x0000000008f9a5c2 in kslwtbctx ()
(gdb)

(gdb) info all-register
rax            0x8f     143
rbx            0x1      1
rcx            0x11263  70243
rdx            0x11974  72052
rsi            0x2acf2e 2805550
rdi            0x7fff1c577028   140733668880424
rbp            0x7fff1c576ed0   0x7fff1c576ed0
rsp            0x7fff1c576ed0   0x7fff1c576ed0
r8             0x0      0
r9             0x7a59   31321
r10            0x9b0abcb8       2601172152
r11            0x0      0
r12            0x1      1
r13            0x0      0
r14            0xbb132a4        196162212
r15            0x1      1
rip            0x8f9a5c2        0x8f9a5c2 <kslwtbctx+4>
eflags         0x246    [ PF ZF IF ]
cs             0x33     51
ss             0x2b     43
ds             0x0      0
es             0x0      0
fs             0x0      0
gs             0x0      0
st0            0        (raw 0x00000000000000000000)
---Type  to continue, or q  to quit---
st1            0        (raw 0x00000000000000000000)
st2            0        (raw 0x00000000000000000000)
st3            0        (raw 0x00000000000000000000)
st4            0        (raw 0x00000000000000000000)
st5            0        (raw 0x00000000000000000000)
st6            333296   (raw 0x4011a2be000000000000)
st7            300384   (raw 0x401192ac000000000000)
fctrl          0x27f    639
fstat          0x0      0
ftag           0xffff   65535
fiseg          0x0      0
fioff          0x9394e95        154750613
foseg          0x7fff   32767
fooff          0x1c573f50       475479888
fop            0x0      0
xmm0           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 }, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm1           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 }, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm2           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 }, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm3           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x8000000000000000, 0x8000000000000000}, v16_int8 = {0xfe, 0xff, 0xff, 0xff, 
    0xff, 0xff, 0xff, 0xff, 0xfe, 0xff, 0xff, 0xff, 0xff, 0xff, 0xff, 0xff}, v8_int16 = {0xfffe, 0xffff, 0xffff, 0xffff, 0xfffe, 0xffff, 
    0xffff, 0xffff}, v4_int32 = {0xfffffffe, 0xffffffff, 0xfffffffe, 0xffffffff}, v2_int64 = {0xfffffffffffffffe, 0xfffffffffffffffe}, 
  uint128 = 0xfffffffffffffffefffffffffffffffe}
---Type  to continue, or q  to quit---
xmm4           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 }, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm5           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x32, 0xa3, 0xd7, 0x2, 0x0 }, 
  v8_int16 = {0xa332, 0x2d7, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x2d7a332, 0x0, 0x0, 0x0}, v2_int64 = {0x2d7a332, 0x0}, 
  uint128 = 0x00000000000000000000000002d7a332}
xmm6           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 }, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm7           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0xda, 0x87, 0xd7, 0x2, 0x0 }, 
  v8_int16 = {0x87da, 0x2d7, 0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x2d787da, 0x0, 0x0, 0x0}, v2_int64 = {0x2d787da, 0x0}, 
  uint128 = 0x00000000000000000000000002d787da}
xmm8           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 }, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm9           {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 }, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm10          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 }, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm11          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 }, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm12          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x18, 0xe, 0x73, 0x90, 0xb, 0x2b, 0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0, 0x0, 0x0}, v8_int16 = {0xe18, 0x9073, 0x2b0b, 0x0, 0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x90730e18, 0x2b0b, 0x0, 0x0}, 
  v2_int64 = {0x2b0b90730e18, 0x0}, uint128 = 0x000000000000000000002b0b90730e18}
xmm13          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 }, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
xmm14          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 }, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
---Type  to continue, or q  to quit---
xmm15          {v4_float = {0x0, 0x0, 0x0, 0x0}, v2_double = {0x0, 0x0}, v16_int8 = {0x0 }, v8_int16 = {0x0, 0x0, 0x0, 0x0, 
    0x0, 0x0, 0x0, 0x0}, v4_int32 = {0x0, 0x0, 0x0, 0x0}, v2_int64 = {0x0, 0x0}, uint128 = 0x00000000000000000000000000000000}
mxcsr          0x1fa1   [ IE PE IM DM ZM OM UM PM ]

7、利用第一个参数rdi=0x7fff1c577028，显示内存中32个字节。

(gdb) x/32 0x7fff1c577028
0x7fff1c577028: 0x00007a59      0x00000000      0x1c577110      0x00007fff
0x7fff1c577038: 0x01b5e250      0x00000000      0x00000000      0x00000000
0x7fff1c577048: 0x00000000      0x00000000      0x00000000      0x00000001
0x7fff1c577058: 0x00000000      0x00000000      0x00000000      0x00000000
0x7fff1c577068: 0x00000000      0x00000000      0x00000000      0x00000000
0x7fff1c577078: 0x00000000      0x00000000      0x00000001      0x00000000
0x7fff1c577088: 0x0a12110c      0x00000000      0x0000008f      0x00011974
0x7fff1c577098: 0x7fffffff      0x00000000      0x00011263      0x00000000
(gdb)

8、找到等待事件的编号是0x0000008f，转化为十进制为143，即0x0000008f ===>143号

sys@OCM> select  name from v$event_name where event#=143;

NAME
----------------------------------------------------------------
log file sync

10、commit时的第一个等待事件就是log file sync。

内容总结

以上是互联网集市为您收集整理的gdb调试之---当commit时碰到的第一个等待事件是什么？全部内容，希望文章能够帮你解决gdb调试之---当commit时碰到的第一个等待事件是什么？所遇到的程序开发问题。如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容，请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

扫描二维码推送至手机访问。

本文链接：https://qyyshop.com/info/530175.html

来源：【匿名】

【上一篇】【数据库】数据库中with...as...的用法【下一篇】用IE远程创建Mysql数据库的简易程序

更多 ►

【gdb调试之---当commit时碰到的第一个等待事件是什么？】教程文章相关的互联网学习教程文章

mysql python pymysql模块增删改查插入数据介绍 commit() execute() executemany() 函数【代码】

import pymysqlmysql_host = ‘192.168.0.106‘ port = 3306 mysql_user = ‘root‘ mysql_pwd = ‘123‘ encoding = ‘utf8‘# 建立连接mysql服务端 conn = pymysql.connect(host=mysql_host, # mysql服务端ipport=port, # mysql端口user=mysql_user, # mysql 账号password=mysql_pwd, # mysql服务端密码db=‘db10‘, # 操作的库charset=encoding # 读取字符串编码 )# 拿到游标对象 cur = conn.cursor()‘‘‘ 游标是给mys...

[MySQL 5.6] MySQL 5.6 group commit 性能测试及内部实现流程

[MySQL 5.6] MySQL 5.6 group commit 性能测试及内部实现流程http://mysqllover.com/?p=581尽管Mariadb以及Facebook在long long time ago就fix掉了这个臭名昭著的问题，但官方直到 MySQL5.6 版本才Fix掉，本文主要关注三点：1.MySQL 5.6的性能如何2.在5.6中Group commit的三阶段实现流程新参数MySQL 5.6提供了两个参数来控制binlog group commit：binlog_max_flush_queue_time单位为微妙，用于从flush队列中取事务的超时时间，这主...

MySQL 重要参数 innodb_flush_log_at_trx_commit 和 sync_binlog

innodb_flush_log_at_trx_commit 该参数控制重做日志写入磁盘的过程。我们知道 InnoDB 使用“Write Ahead Log”策略来避免数据丢失问题，即依靠重做日志来保证数据能在丢失后进行恢复。因此，InnoDB 重做日志的持久化非常重要。这个参数的默认值为1首先需要大致了解一下mysql日志操作步骤： log_buff --》 mysql写 (write) --》 log_file --》 OS刷新 (flush) --》 diskinnodb_flush_log_at_trx_commit 参数解释： 0（延迟写）： l...

相同更改数据量的前提下，单次COMMIT和多次COMMIT对日志空间浪费

LGWR进程按照顺序写在线日志，中间不会跳跃，而且LGWR进程不会在同一个日志快写2次，即使一次写入的日志快只占几个字节，下次不会再用了，这就造成日志空间的浪费。Oracle做一次Commit，就会触发LGWR进程进行日志缓冲到日志文件的写入操作，因此可以说更改相LGWR进程按照顺序写在线日志，中间不会跳跃，而且LGWR进程不会在同一个日志快写2次，即使一次写入的日志快只占几个字节，下次不会再用了，这就造成日志空间的浪费。Oracle做...

phpmysqli_commit函数怎么用【图】

php mysqli_commit函数用于提交指定数据库连接的当前事务，其语法是mysqli_commit(connection)，参数connection必需，指规定要使用的MySQL连接。php mysqli_commit函数怎么用？定义和用法mysqli_commit() 函数提交指定数据库连接的当前事务。提示：请查看 mysqli_autocommit() 函数，用于开启或关闭自动提交数据库修改。请查看 mysqli_rollback() 函数，用于回滚当前事务。语法mysqli_commit(connection);参数connection 必需。规定...

rollbackphp+mysql事务rollback&commit示例

mysql_query("BEGIN");//开始一个事务 mysql_query("SET AUTOCOMMIT=0"); //设置事务不自动commit $insert="INSERT INTO userinfo VALUES ('aa12','aa','1','aaa')"; mysql_query($insert); mysql_query("COMMIT");//非autocommit模式，必须手动执行COMMIT使操作生效 //mysql_query("SET AUTOCOMMIT=0"); $insert="INSERT INTO userinfo VALUES ('aa20','aa','1','aaa')"; $insert="INSERT INTO userinfo VALUES ('aa8','aa','1')"...

phpmysqli_commit()函数和mysqli_autocommit()函数比较

本篇文章我们是介绍mysqli_commit和mysqli_autocommit函数的定义，语法和用法来对比他们之间的区别，首先我们先来介绍下mysqli_commit函数：定义和用法mysqli_commit() 函数提交指定数据库连接的当前事务。提示：请查看 mysqli_autocommit() 函数，用于开启或关闭自动提交数据库修改。请查看 mysqli_rollback() 函数，用于回滚当前事务。语法mysqli_commit(connection);参数描述connection 必需。规定要使用的 MySQL 连接。 ...

在PHP中开始事务后，程序抛出异常没有执行commit也没有执行rollbackmysql事务会回滚吗？

网上有人说开启事务后 sql语句执行错误或程序出错没有执行rollback的情况下，下一次运行就会自动commit 程序出错不会回滚rollback 但是也有人说抛出异常等程序如果MySQL存在没有提交的事务，那么这时候 AUTOCOMMIT 自动提交的参数应该是为 0 的。不过如果你通过其他的语言的MySQL驱动来操作的话，这些驱动一般都带有自动恢复 AUTOCOMMIT 的功能，在请求处理完成后会自动 ROLLBACK 没有处理的事务。回复内容：网上有人说开启事务后...

php+mysql事务rollback&amp;commit示例_PHP教程

mysql事务执行完毕,需要恢复autocommit=1吗?

set autocommit =0; //关闭自动提交 start transaction; //开启一个事务; ---------------------...... commit; //正式提交事务;事务结束; commit之后,还要把set autocommit =1恢复吗? 我看别人的案例都没恢复,commit会自动恢复? 回复讨论(解决方案) 不需要因为一般不会在一个程序代码中进行多次事务操作即便是，那也是在你掌控中的连接断开，设置就自动失效了不...

php顶用mysql的STARTTRANSACTION和commit包围了4条插入语句，发现用事务比不用的时候插入的快这是为什么呢

php中用mysql的START TRANSACTION和commit包围了4条插入语句，发现用事务比不用的时候插入的快这是为什么呢？php中用mysql的START TRANSACTION和commit包围了4条插入语句，发现用事务比不用的时候插入的快这是为什么呢？------解决方案--------------------这是相对的，而不是绝对的。通常说索引可以加快查询速度，但只有在数据量达到一定规模的情况下是这样的。个人认为简单操作，使用事务的效果不是非常明显。只有在批量操作时...

mysql事宜执行完毕,需要恢复autocommit=1吗

mysql事务执行完毕,需要恢复autocommit=1吗?set autocommit =0; //关闭自动提交start transaction; //开启一个事务;---------------------......commit; //正式提交事务;事务结束;commit之后,还要把set autocommit =1恢复吗? 我看别人的案例都没恢复,commit会自动恢复?------解决思路----------------------autocommit 默认为1，即自动提交事务你 set autocommit =0 是为了关闭自动提交，显然这是你个...

php+mysql事务rollback&commit示例_php技巧

php+mysql事务rollback&commit示例

MySQL事物系列：3：innodb_flush_log_at_trx_commit小实验【代码】

1：创建表和存储过程mysql> create database trx; Query OK, 1 row affected (0.02 sec)mysql> USE trx Database changed mysql> CREATE TABLE test_trx(-> id int(5),-> uname char(30))-> engine =innodb; Query OK, 0 rows affected (0.01 sec)mysql> DROP PROCEDURE IF EXISTS pro_trx $$ Query OK, 0 rows affected (0.00 sec)mysql> DELIMITER $$ mysql> DROP PROCEDURE IF EXISTS pro_trx $$ Query OK, 0 rows affected, 1 ...

首页 / MYSQL / gdb调试之---当commit时碰到的第一个等待事件是什么？

gdb调试之---当commit时碰到的第一个等待事件是什么？

内容导读

内容图文

内容总结

内容备注

内容手机端

【gdb调试之---当commit时碰到的第一个等待事件是什么？】教程文章相关的互联网学习教程文章

调试 - 相关标签

MYSQL - 技术教程分类

MYSQL - 最新教程

MYSQL - 最热教程