---
title: "Discussion on \"Tips and Tricks for reducing Leaf Block Contention happening to InnoDB\" | Hashnode"
description: "Discussion on \"Tips and Tricks for reducing Leaf Block Contention happening to InnoDB\". Enhance MySQL performance with larger innodb_page_size, table partitioning, covering indexes, query optimization, and transaction tweaks"
url: "https://hashnode.com/posts/tips-and-tricks-for-reducing-leaf-block-contention-happening-to-innodb/65ca74c0fcdc78c62f4af9f9"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Tips and Tricks for reducing Leaf Block Contention happening to InnoDB](https://shiviyer.hashnode.dev/tips-and-tricks-for-reducing-leaf-block-contention-happening-to-innodb?utm_source=hashnode&utm_medium=feed)

Enhance MySQL performance with larger innodb\_page\_size, table partitioning, covering indexes, query optimization, and transaction tweaks

Feb 12, 2024 · 3 min read · shiviyer.hashnode.dev  
Read the article

-   [#mysql](https://hashnode.com/tag/mysql)
-   [#postgresql](https://hashnode.com/tag/postgresql)
-   [#sql](https://hashnode.com/tag/sql)
-   [#sql-server](https://hashnode.com/tag/sql-server)
-   [#oltp](https://hashnode.com/tag/oltp)
-   [#databases](https://hashnode.com/tag/databases)
-   [#data-science](https://hashnode.com/tag/data-science)
-   [#linux](https://hashnode.com/tag/linux)
-   [#devops](https://hashnode.com/tag/devops)
-   [#analytics](https://hashnode.com/tag/analytics)
-   [#data-structures](https://hashnode.com/tag/data-structures)
-   [#data-analysis](https://hashnode.com/tag/data-analysis)
-   [#big-data](https://hashnode.com/tag/big-data)
-   [#bigdata-analytics-datascience-ai-machinelearning-iot-iiot-python-rstats-tensorflow-javascript-reactjs-cloudcomputing-serverless-datascientist-linux-programming-coding-100daysofcode](https://hashnode.com/tag/bigdata-analytics-datascience-ai-machinelearning-iot-iiot-python-rstats-tensorflow-javascript-reactjs-cloudcomputing-serverless-datascientist-linux-programming-coding-100daysofcode)

## Written by

[Shiv Iyer](https://hashnode.com/@shiviyer)

@shiviyer

  
[View profile](https://hashnode.com/@shiviyer)

Founder CEO of #MinervaDB #ChistaDATA #MySQL #PostgreSQL #RocksDB #InnoDB #MariaDB #ClickHouse #MongoDB #Linux #Entreprenuer #Investor #Star

Over two decades of experience as a Database Architect and Database Engineer with core expertize in Database Systems Architecture/Internals, Performance Engineering, Scalability, Distributed Database Systems, SQL Tuning, Index Optimization, Cloud Database Infrastructure Optimization, Disk I/O Optimization, Data Migration and Database Security. I am the founder CEO of MinervaDB Inc. and ChistaDATA Inc.

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
