What’s New in MySQLTuner v2.8.44: A Deep Dive into the Latest 3 Months of Performance Tuning Evolution

MySQLTuner is one of the most widely trusted open-source command-line utilities for auditing and optimizing database servers. Written in Perl, its simplicity, zero external dependency design (by default), and direct, actionable advice have made it a staple in the toolkit of Database Administrators (DBAs), DevOps engineers, and system administrators worldwide. In the last three months, […]

Mastering the MySQL Client on Linux: Boost Your Command-Line Performance!

The MySQL command-line client on Linux is a powerful tool for interacting with your databases directly from the terminal. Whether you are a database administrator or a developer, mastering this tool can significantly improve your management and development workflows. 🚀 🛠️ Installing the MySQL Client on Linux: A Quick Guide Before getting started, here are […]

Writing data into MySQL InnoDB

Detailed Analysis of the Write Process in MySQL 8.0+ with InnoDB This document provides an in-depth analysis of the write process (INSERT, UPDATE, DELETE) for the InnoDB storage engine in MySQL 8.0 and later versions. It describes the key components, data flow, relevant configuration parameters, and associated risks. Table of Contents 💾 General Write Process […]

Open Source Audit plugins from MySQL 5.7/MySQL 8.0

Conclusion first MySQL Oracle since 5.7.33 doesn’t get any open source auditing solution I have tried several options: Create a VirtualBox with Vagrant Useful links Creating a Centos/7 virtual server Prepare Virtual machine for MySQL 5.7 Install compilation environment Download MySQL 5.7.40 source code Adding code source from MySQL 5.7 AWS audit plugin Compile source […]

Golang and MySQL or MariaDB

MySQL is a popular open-source relational database management system (RDBMS) that is widely used to store and manage data for a wide variety of applications. It is known for its reliability, flexibility, and performance, making it a good choice for many developers. Golang, also known as Go, is a programming language developed by Google in […]