PostgreSQL 16 introduces several enhancements to its query planner and executor, often referred to as built-in query intelligence. These improvements aim to make query planning and execution more efficient, intelligent, and adaptable. Here are some o...
In MySQL, the InnoDB storage engine uses the ibdata1 file to manage critical database functions. This guide offers a concise overview of its role and management. Key aspects of ibdata1 Data and Indexes Stored unless innodb_file_per_table is set. Doub...
Introduction The way databases store data on disk is both intricate and fascinating. It combines principles of computer science, data management, and software engineering. In this deep dive, we'll expand our focus on InnoDB, a popular storage engine ...
The log file sync breakdown in MySQL's InnoDB storage engine is a critical aspect of understanding the performance and efficiency of database transactions. InnoDB uses a write-ahead logging (WAL) strategy to ensure data integrity and consistency, whi...
Troubleshooting node corruption in an InnoDB Cluster in MySQL 8 requires a careful approach to diagnose issues and recover from them without jeopardizing the integrity of the entire cluster. Here are some tips and tricks: 1. Identify the Corrupted No...
Using BIT or BOOLEAN flags in MariaDB can lead to performance and maintenance issues in certain scenarios. Here are some reasons why you should be cautious when using these data types: Performance: BIT and BOOLEAN flags can negatively impact the per...
在之前的文章 #issue 68021 MySQL unique check 问题中, 我们已经介绍了在 MySQL 里面, 由于唯一键的检查(unique check), 导致 MySQL 在 Read Commit 隔离级别也需要添加 GAP lock, 导致有些比较奇怪情况下有一些锁等待. 另外一类问题是由于唯一键检查导致的死锁问题, 这类问题也非常多, 也是我们处理线上经常收到用户反馈的问题, 这里我们就分析几个这样死锁的 Case. Replace into 操作是非常常用的操作, 很...
💡 이 글은 Real MySQL 8.0과 공식 문서를 읽고 개인적으로 정리한 내용입니다. 1. InnoDB 스토리지 엔진 아키텍처 InnoDB 스토리지 엔진은 MySQL의 스토리지 엔진 가운데 가장 많이 사용되는 엔진입니다. MySQL에서 사용할 수 있는 스토리지 엔진 중 거의 유일하게 레코드 기반의 잠금을 제공하고, 그 때문에 높은 동시성 처리가 가능하고 안정적이며 성능이 뛰어납니다. 1.1. 프라이머리 키에 의한 클러스터링 각 Inno...
When working with MySQL, selecting the appropriate storage engine is crucial to meet the specific requirements of your application. In this blog post, we will delve into two commonly used storage engines: MyISAM and InnoDB. We will examine the differ...
If you’ve been around the database space at least for a little while and know your way around MySQL or any of its flavors, you will surely know what InnoDB is – it’s one of the main storage engines offered by MySQL and it’s also the default storage e...
