Showing entries 1 to 10 of 1312
10 Older Entries »
Displaying posts with tag: mariadb (reset)
How to avoid data loss in MySQL Primary Key change

Learn how to safely change primary keys in MySQL using pt-online-schema-change. This blog highlights tips to avoid data loss during online alter of primary key.

The post How to avoid data loss in MySQL Primary Key change first appeared on Change Is Inevitable.

What do you need to debug MySQL issues – a checklist

Welcome to the ultimate guide for MySQL issues debugging — your comprehensive MySQL checklist for tackling MySQL database environment challenges. This checklist for MySQL debugging is as useful to a…

The post What do you need to debug MySQL issues – a checklist first appeared on Change Is Inevitable.

How to get MySQL Primary Keys in one minute

This blog post talks about one of the important MySQL configuration, sql_generate_invisible_primary_key, available in MySQL 8.0.30. This will save you from performance bottlenecks due to tables without Primary Key. If…

The post How to get MySQL Primary Keys in one minute first appeared on Change Is Inevitable.

Quick Look – MySQL Data Directory Files

Do you know what lies inside your MySQL Data Directory? This article is a quick guide about the files stored inside MySQL data directory. Data managed by the MySQL server…

The post Quick Look – MySQL Data Directory Files first appeared on Change Is Inevitable.

How to fix MySQL federated table error

This blog is about a very odd case of a Federated table error causing unable reach the remote MySQL server and causing to error. I’ll share the approach I tool…

The post How to fix MySQL federated table error first appeared on Change Is Inevitable.

How to replicate without binary logs in MySQL

“How can we replicate without using binary logs” just a thought popped up in my brain during a casual discussion. This blog post is a brain dump of the possible…

The post How to replicate without binary logs in MySQL first appeared on Change Is Inevitable.

MySQL fragmentation and how to defragment

In a MySQL database, fragmentation can occur over time as data is inserted, updated, and deleted. Fragmentation refers to the inefficient storage and organization of data within database objects, such…

The post MySQL fragmentation and how to defragment first appeared on Change Is Inevitable.

How to Fix Connection attributes of length xxx were truncated

MySQL, a widely-used database management system, may show the warning “[Warning] Connection attributes of length 571 were truncated” in its error log. In this blog, we will explore the reasons…

The post How to Fix Connection attributes of length xxx were truncated first appeared on Change Is Inevitable.

How To Install specific version of MySQL 8 on Ubuntu

This blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on Ubuntu. The post includes instructions for installation using…

The post How To Install specific version of MySQL 8 on Ubuntu first appeared on Change Is Inevitable.

MariaDB vs MySQL: Key Differences and Use Cases

This blog post was originally published in November 2017 and was updated in June 2023.

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL).

Introduction: MariaDB vs. MySQL

The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. It is largely an unofficial response to published comments from the MariaDB Corporation.

It is worth noting that Percona Server for MySQL is a drop-in compatible branch of MySQL, where Percona contributes as much as possible upstream. MariaDB Server, on the other hand, is a fork of MySQL 5.5. They cherry-picked MySQL features and don’t …

[Read more]
Showing entries 1 to 10 of 1312
10 Older Entries »