MySQL 8.0 – Invisible Indexes

Overview In this blog, we aim to discuss the new MySQL 8.0 feature: invisible indexes and how to manage index visibility. MySQL 8.0 supports invisible indexes, that is, indexes not used by the optimizer. This feature applies to indexes other…

Read More

The iPhone Experience Conundrum

Many engineering leaders have challenges with expectations regarding timelines, complexity, level of integration and usability because of what I call the “iPhone conundrum.” The iPhone conundrum is the expectation by technology consumers that new functionality shows up overnight, has high…

Read More

How Do I Merge Two Google Workspace Domains?

From merging domains and transferring accounts to rebranding to data migrations to aligning, there are a lot of steps involved in bringing Google Workspace under one, central umbrella. During a merger or acquisition—when companies are most likely to be doing…

Read More

Map Upstream Dependencies using N-grams in Python

l.e. Which option would you prefer to receive when asked to make many changes throughout a complex system you’re unfamiliar with? “fix this” (many times), or “fix this, which might be better known as a name, most likely by making…

Read More

After the migration: How to get the most out of your Google Cloud migration

All public clouds offer flexible computing, networking and storage. And you’re likely using at least one public cloud, if not two or more. But if you’re thinking about moving some of your mission-critical applications to the cloud—such as SAP or…

Read More

Cassandra Consistency Level Guide

When I started learning Cassandra, I noticed some concepts were not well explained, and it might be helpful for beginners to have information on a single topic in one place. This is how the idea of this blog was born….

Read More

Hello from India

The first postcard of 2023 is from a coastal city where Gopi Kampa helps streamline the onboarding process while collaborating with various departments across multiple time zones. Read on to learn more about how this amiable HR coordinator lives and…

Read More

Data Strategy & Digital Transformation

Our previous post discussed how data governance is an enabler when implemented early and aligned with data strategy initiatives. The application of data strategy priorities as part of our data governance programs ensures teams can deliver high-quality and trustworthy data….

Read More

Find and remove unused & duplicate indexes in MySQL

Overview: It is a general rule of thumb, that the more indexes you have on a table, the slower the INSERTs, UPDATEs, and DELETEs operations become. Indexes in MySQL—or for that matter, any database—are never static. Each time you modify…

Read More

Reader Favourites: Some of 2022’s Most Popular Pythian Blogs

  Every year, tens of thousands of IT professionals and executives visit Pythian’s blog to tap into our team’s deep expertise and experience. As 2022 comes to a close, we’d like to highlight a few of our reader’s favourites over…

Read More