Change Is Inevitable
  • Home
  • MySQL
    • MySQL-Articles
    • MySQL-Scripts
    • MySQL Resources
  • Technical
    • QA-Testing
  • General
    • Review
    • Just for fun
    • Personal
  • Contact Me
    • Copyright
Change Is Inevitable

Kedar Vaijanapurkar's Blog for MySQL, technology and various subjects

  • Home
  • MySQL
    • MySQL-Articles
    • MySQL-Scripts
    • MySQL Resources
  • Technical
    • QA-Testing
  • General
    • Review
    • Just for fun
    • Personal
  • Contact Me
    • Copyright

Browsing Tag

MySQL

73 posts
MySQL Optimizations
  • MySQL
  • MySQL-Articles
  • 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

One MySQL blog a day challenge

  • Kedar
  • July 31, 2023
In this blog post, I want to share my experience and learning after challenging myself on my MySQL blog writing spree in recent past. I invite you to comment on…
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

How To Install specific version of MySQL 8 on Ubuntu

  • Kedar
  • June 8, 2023
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…
View Post

How to MySQL Replication setup, Master GTID & SSL Encryption

  • Kedar
  • June 4, 2023
Setting up replication in MySQL is a common DBA task. The replication could be traditional binary log replication or based on GTID replication. This blog is a work log and…
View Post

Posts navigation

1 2 … 13 Next
... ...
Change Is Inevitable
Designed & Developed by Code Supply Co.