Skip to content
The Fellowship Of Data
Menu
  • HOME
  • BLOG
  • CONTACT ME

mysql

Uncategorized

Compiling MySQL (Desmistifying)

Today we are going to talk about a topic that many people are afraid of. We know that MySQL is open-source, but there are some steps from the code until …

Databases / Hot Topics / MySQL

Toss a coin to your DBA: Estimate MySQL Redo Log Size

Having a right REDO log size is fundamental for MySQL to run smoothly without struggling. An undersized REDO can even lead to errors in operations! For example, this week, a …

Databases / MySQL

Monitor MySQL Memory Usage – Part 2 (Valgrind)

So, today, continuing with memory analysis I will present the Valgrind tool. Valgrind programming tool provides information for memory debugging, memory leak detection, and profiling. It is useful for cases …

Databases / MySQL

MySQL built-in function x user-defined function performance

In this article, I’m going to cover the use of built-in functions. The idea is to use the functions that MySQL has available instead of making custom functions (aka user-defined …

Databases / MySQL / Percona Toolkit

Export The Slow_log Table To Slow Query Log File To Apply The Pt-query-digest

Working on customer cases always brings challenges. This week I got one where the customer provided the dump of mysql.slow_log table and it was necessary to analyze it. Unfortunately, pt-query-digest …

Databases / Docker / MySQL / Virtualization

Deploying Percona MySQL Server container in one command line

That’s it? Do I have to execute only this line? A: Yes. This article is a silver bullet for those who want to deploy a Percona Server MySQL to quickly …

Databases

DBA Talk – What is Isolation Level

This week I came across a topic in a group of DBAs where the following statement was made: Oracle is the only DB where writing does not block reading and …

Databases / MySQL / Webinar

Webinar: Enhancing MySQL Security

A few days ago, I presented a webinar about security over MySQL. I covered a few topics and discussed the pros and cons of implementing those features. Below is the …

Databases / MySQL

Ressincronizar Slave MySQL sem downtime com Percona Toolkit

Recentemente, trabalhei em um caso extremo em que um slave ficou dessincronizado, mas não pôde ser reconstruído do zero porque o slave estava agindo como um servidor master para uma …

Databases / MySQL

MySQL 8.0.17 Clone Plugin: How to Create a Slave from Scratch

In this post, we will discuss a new feature – the MySQL 8.0.17 clone plugin. Here I will demonstrate how easy it is to use to create the “classic” replication, …

Hot Topics

  • The 5th dimension of MongoDB: Adjusting Eviction Threads
    The 5th dimension of MongoDB: Adjusting Eviction Threads
  • Boosting MySQL Replication
    Boosting MySQL Replication
  • Create a XFS filesystem using LVM
    Create a XFS filesystem using LVM
  • Stop Fake News! The most common fake news about MySQL (contains bad language)
    Stop Fake News! The most common fake news about MySQL (contains bad language)
  • Toss a coin to your DBA: Estimate MySQL Redo Log Size
    Toss a coin to your DBA: Estimate MySQL Redo Log Size

Menu

  • HOME
  • BLOG
  • CONTACT ME

Newsletter

Sign up and receive news.

Follow Me

Copyright © 2022 The Fellowship Of Data – OnePress theme by FameThemes