Browsing Category

MariaDB

26 posts

Articles related to MariaDB

One comment

How to get MySQL Primary Keys in one minute

Kedar
November 30, 2023

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…

View Post

2 comments

Quick Look – MySQL Data Directory Files

Kedar
September 25, 2023

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…

View Post

How to fix MySQL federated table error

Kedar
July 28, 2023

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…

View Post

How to replicate without binary logs in MySQL

Kedar
July 27, 2023

“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…

View Post

MySQL fragmentation and how to defragment

Kedar
July 26, 2023

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…

View Post

How to Fix Connection attributes of length xxx were truncated

Kedar
July 25, 2023

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…

View Post