Articles by Shiv Iyer

About Shiv Iyer

Open Source Database Systems Engineer with a deep understanding of Optimizer Internals, Performance Engineering, Scalability and Data SRE. Shiv currently is the Founder, Investor, Board Member and CEO of multiple Database Systems Infrastructure Operations companies in the Transaction Processing Computing and ColumnStores ecosystem. He is also a frequent speaker in open source software conferences globally.

Exploring SELECT for JSON in MySQL 8: Retrieving Data in JSON Format

The SELECT for JSON implementation in MySQL 8 allows you to retrieve query results in JSON format directly from the database. Consequently, it simplifies data retrieval and facilitates integration with applications that consume JSON data. […]

Troubleshooting MySQL Error Code 1213 and Error Code 1205: Resolving Deadlock Situations

MySQL Error Code 1213 and Error Code 1205 – Troubleshooting Deadlock Situations MySQL Error Code 1213 and Error Code 1205 both indicate deadlock situations where transactions wait for each other to release resources, creating a […]

Troubleshooting MySQL Error Code 1206: Addressing Lock Wait Timeouts for Improved Performance

MySQL Error Code 1206 When you encounter Error Code 1206, which indicates a lock wait timeout in MySQL, follow these troubleshooting steps to resolve the issue:: By following these troubleshooting steps, you can identify the […]

Unlocking Success: Why Internet Companies Trust MinervaDB for Optimal Open Source Database Infrastructure Operations

MinervaDB Several internet companies—including startups, medium-sized enterprises, and large organizations—engage with MinervaDB for consultative support and 24/7 managed services of PostgreSQL, MySQL, and ClickHouse. They choose MinervaDB for several key reasons. MinervaDB’s expertise, consultative approach, […]

Troubleshooting Error Code 2013: Connection Lost Error in MySQL – 10 Reasons and Solution

MySQL Error Code 2013 The MySQL Error Code 2013 (CR_SERVER_LOST) indicates a connection lost error. Here are 10 possible reasons for this error and how to troubleshoot them: To troubleshoot Error Code 2013, it’s essential […]

Clustered Index Design considerations in PostgreSQL

In PostgreSQL, a clustered index works through a feature called “clustered table” or “clustered index scan.” It physically reorders a table’s rows based on the indexed column(s). This process directly determines how PostgreSQL organizes data […]

How is Process Memory Protection implemented in PostgreSQL?

Process Memory Protection in PostgreSQL Process memory protection in PostgreSQL is primarily implemented through the use of memory management techniques provided by the operating system. PostgreSQL relies on the underlying operating system’s memory management capabilities […]

The WebScale Database Infrastructure Operations Experts in PostgreSQL, MySQL, MariaDB, MongoDB and ClickHouse

Enterprise-class 24*7 Consultative Support and Managed Services for PostgreSQL, MySQL, MariaDB, MongoDB and ClickHouse