Pages

▼
Monday, July 24, 2023

NonParallelPlanReason="CouldNotGenerateValidParallelPlan" - one of the possible reasons

›
When you see your query doesn't go parallel and in the execution plan XML you see  NonParallelPlanReason = "CouldNotGenerateValidPa...
Monday, November 28, 2022

Minimizing deadlocks

›
A deadlock occurs when two or more sessions permanently block each other by each session having a lock on a resource that the other session(...
Friday, September 9, 2022

Change Tracking cleanup doesn't work - negative cleanup_version / change_tracking_hardened_cleanup_version

›
So you have enabled the Change Tracking with AUTO_CLEANUP = ON, but the CT cleanup doesn't work, no records deleted from the side tables...
Friday, January 15, 2021

How to identify MySQL replication slave lag

›
Let's first understand how the standard asynchronous MySQL replication works at a high level. For simplicity, let's assume that ther...
Wednesday, October 28, 2020

MySQL guide for SQL Server developers/DBAs - Part 1

›
Do you know what "My" means in MySQL? "My" is the name of one of the co-founders Michael Widenius’s daughter. If you are...
2 comments:
Friday, October 23, 2020

Fork-and-Branch Git Workflow(GitHub)

›
Some companies use GitHub and Fork-and-Branch Git Workflow. Let's see how it works in detail. Each developer will have 2 server-side Git...
1 comment:
Monday, August 24, 2020

MySQL - ERROR 1298 (HY000): Unknown or incorrect time zone: 'UTC'

›
Let`s assume have a MySQL 5.6 Server installed on a Windows machine. and you get the error below when trying to set time_zone to 'UTC...