Articles under the label of MySql

  1. Home
  2. MySql

Mysql行锁

Mysql行锁属于悲观锁,悲观锁比较悲观，当多个线程对同一行数据实现修改的时候，最后只有一个线程才能修改成功，只要谁能够对获取该到行锁则其他线程时不能够对...

  • Szx
  • August 14, 2021
  • No comments

    • MySQL释放锁

    语法kill 锁的ID

  • Szx
  • August 14, 2021
  • No comments

    • MySQL查询行锁

    查询行锁详细信息select * from information_schema.innodb_trx t 查询行锁IDselect t.trx_mys...

  • Szx
  • August 14, 2021
  • No comments

    • SQLyog连接数据库报错plugin caching_sha2_password***解决方法

    错误代码2058 Plugin caching_sha2_password could not be loaded配置新连接报错：错误号码 2058，分析...

  • Szx
  • April 17, 2020
  • No comments

    • Linux安装MySql8最新版实战教程

    安装软件MySQL8最新版本,环境:阿里云 Centos7.7 64位基本命令安装 : yum install mysql-community-se...

  • Szx
  • April 17, 2020
  • No comments

    • Mysql报错[root@localhost mysql]# FATAL ERROR: please install the following Perl modules before executing ./scripts//mysql_install_db:

    [root@localhost mysql]# FATAL ERROR: please install the following Perl module...

  • Szx
  • December 23, 2019
  • No comments

    • JetBrains DataGrip 2019连接MySql报错解决方法

    使用JetBrains DataGrip 2019.1.4 x64连接mysql的时候报错如下:Connection to @localhost fail...

  • Szx
  • July 7, 2019
  • 2 comments