本文就一起探讨一下表锁、行锁、间隙锁、元数据锁（MDL）用途及避坑点等（本文基于RR隔离级别进行举例）。 开发同学在工作中经常遇到这些问题：数据库明明没报错，为什么接口突然卡顿？为什么简单的更新语句一直未运行完毕？为什么数据会莫名其妙多出 ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

最近做了不少基于PageAdmin CMS的国产化改造项目，每次转达梦时候都特么的各种坑，这里做一下笔记，方便后面做参考，也可以对遇到这些坑的朋友提供一下参考。 1、直接用迁移工具把mysql导入达梦的，自增Id无法自动递增，也可能是我用的代理商提供的迁移工具 ...

We invest a lot of resources into creating best in class open source packages. You can support us by buying one of our paid products. We highly appreciate you sending us a postcard from your hometown, ...

The auto-increment column is a bread-and-butter feature of single-node transactional databases. It assigns a unique identifier for each row in a way that requires the least manual effort from users.

Your browser does not support the audio element. Version control systems, and Git in particular, are essential tools for tracking code changes, collaborating with ...

NodeMCU is a low-cost open-source IoT platform that initially included firmware which runs on the ESP8266 Wi-Fi SoC from Espressif Systems, and hardware which was based on the ESP-12 module. If you ...

本篇主要介绍 MySQL 的函数索引（也叫表达式索引）。 通常来讲，索引都是基于字段本身或者字段前缀（第 20 篇），而函数索引是基于字段本身加上函数、操作符、表达式等计算而来。如果将表达式或者操作符也看做函数的话，简单来说，这样的索引就可以统称 ...