10 2023 档案

MySQL8 间隙锁在11种情况下的锁持有情况分析与总结

摘要：测试环境及相关必要知识测试环境为mysql 8 版本间隙锁（Gap Lock）：用于锁定索引范围之间的间隙，防止其他事务在此间隙中插入新记录。间隙锁主要用于防止幻读问题。在可重复读的隔离级别下默认打开该锁机制，解决幻读问题，也可手动修改配置文件关闭该锁机制，该锁机制为innodb自动决定间隙范阅读全文

posted @ 2023-10-08 00:55 HumorChen99 阅读(176) 评论(0) 推荐(0) 编辑

Mysql 8手动终止某个事务并释放其持有的锁

摘要：示范数据表 age具有index普通索引在mysql数据库里的information_schema.INNODB_TRX表中存储有innodb的所有事务，我们可以查看该表来查看正在进行的事务现在我开启一个事务，执行第1、2行SQL，启动事务并持有id=3的行锁刷新事务表可以看到这个事务我们可阅读全文

posted @ 2023-10-07 23:32 HumorChen99 阅读(119) 评论(0) 推荐(0) 编辑

Jenkins 添加节点Node报错JNI error has occurred UnsupportedClassVersionError

摘要：节点日志报错信息如下 Error: A JNI error has occurred, please check your installation and try again Exception in thread “main” java.lang.UnsupportedClassVersion 阅读全文

posted @ 2023-10-07 19:54 HumorChen99 阅读(247) 评论(0) 推荐(0) 编辑

Jenkin 添加节点报错No Known Hosts file was found

摘要：/var/lib/jenkins/.ssh/known_hosts [SSH] No Known Hosts file was found at /var/lib/jenkins/.ssh/known_hosts. Please ensure one is created at this path 阅读全文

posted @ 2023-10-07 19:49 HumorChen99 阅读(180) 评论(0) 推荐(0) 编辑