Desativar as Transparent Huge Pages (THP) de forma permanente no Ubuntu 22.04 exige a modificação dos arquivos de configuração do sistema para que a alteração seja aplicada durante o boot. Existem diversas maneiras de fazer isso, mas um método comum é utilizar o rc.local ou criar um serviço systemd personalizado, já que o Ubuntu pode…
Releem: MySQL Performance Tool
Who wouldn’t love a reliable database free from issues and allowing us to sleep peacefully? That’s what Roman Agabekov, the CEO of Releem, aims to provide. As a tool specializing in MySQL Performance Tuning, Releem helps developers and database administrators by automating MySQL tuning, enhancing application performance, and reducing server costs. In this blog post,…
Improving Database Performance with ReadySet: A MySQL Caching Solution
Many developers face the challenge of achieving performance without compromising on real-time application functionality in database management. This brings us to today’s spotlight technology: ReadySet. What is ReadySet? According to its GitHub repository, ReadySet is designed to enhance the performance of real-time applications by providing a powerful SQL caching engine that requires no changes to…
MySQL: Identifying Tables Not Using InnoDB
This blog post aims to spotlight tables within a MySQL database that do not employ the InnoDB storage engine. The essence of the query is to filter out tables that do not utilize the InnoDB engine, thereby enabling a focused analysis or migration plan for database optimization. Below is the query:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
SELECT table_schema AS 'database_name', table_name, engine FROM information_schema.tables WHERE engine NOT LIKE 'InnoDB' AND table_type = 'BASE TABLE' AND table_schema NOT IN ( 'information_schema', 'sys', 'performance_schema', 'mysql' ) ORDER BY table_schema, table_name; |
Let’s dissect the…
Introduction to the New Percona Everest Beta
In the rapidly evolving world of technology, database management remains a crucial, albeit challenging, aspect for many organizations. Percona, a leading provider of open-source database solutions, comes with its latest product, which is now in its beta phase: Percona Everest. This post aims to shed light on what Percona Everest is, how it works, and…
How to Permanently Disable Transparent Huge Pages (THP) on Ubuntu 22.04
Disabling Transparent Huge Pages (THP) permanently on Ubuntu 22.04 requires editing system configuration files to apply the change at boot time. There are a few methods to achieve this, but one common approach is to use rc.local or a custom systemd service since Ubuntu may not have rc.local enabled by default in newer versions. Here,…
How to Create SSH Keys
An SSH key consists of a pair of files: the private key and the public key. The private key is confidential and should never be shared, while the public key enables you to log into the servers, containers, and VMs you set up. When creating these keys using the ssh-keygen command, the keys are stored…
That’s a Wrap: MySQL Belgian Days and FOSDEM 2024
Hey everyone! FOSDEM and MySQL Belgian days are over, and I wanted to share my impressions from an incredible 4-day journey filled with talks about databases and, of course, the famous Belgian beers. 🍻 🛬 Touchdown in Brussels After a whopping 16-hour flight from Sao Paulo, I arrived in Brussels on Wednesday, a day before…
How to Use MySQL Shell to Create an InnoDB Cluster
Introduction The efficiency and reliability of database management systems are paramount. This blog post is your step-by-step guide to mastering the creation of an InnoDB Cluster from scratch using MySQL Shell. Let’s dive into the detailed steps. Prerequisites for Setting Up an InnoDB Cluster Laying the Groundwork: What You Need Before You Begin Before creating…
How to Add a New MySQL Server Node to an InnoDB Cluster
Introduction It is possible to expand the capacity and the availability of an InnoDB Cluster by adding more MySQL servers. For example, a 5-node InnoDB cluster can tolerate up to 2 node failures, while a 3-node InnoDB cluster can tolerate only a single failure. Objective This guide will navigate you through the process of integrating…