Tag - insight for developers

The Transaction Behavior Impact of innodb_rollback_on_timeout in MySQL

innodb_rollback_on_timeout

I would say that innodb_rollback_on_timeout is a very important parameter. In this blog, I am going to explain “innodb_rollback_on_timeout” and how it affects the transaction behavior at the MySQL level. I describe two scenarios with practical tests, as it would be helpful to understand this parameter better.
What is innodb_rollback_on_timeout?
The parameter Innodb_rollback_on_timeout will control the […]

Read more

ClickHouse and ColumnStore in the Star Schema Benchmark

ClickHouse and ColumnStore

There were two new releases in the OpenSource Analytical Databases space, which made me want to evaluate how they perform in the Star Schema Benchmark.
I covered Star Schema Benchmarks a few times before:

Star Schema Bechmark: InfoBright, InfiniDB and LucidDB
ClickHouse in a General Analytical Workload (Based on a Star Schema Benchmark)

What are the new releases:
MariaDB […]

Read more

Generating Numeric Sequences in MySQL

Generating Numeric Sequences in MySQL

What is the easiest way to generate a sequence of integers in MySQL? In other words, which “SELECT <something>” statement should I write to get 0, 1, 2, … N – 1?
This is the question I have been struggling with for years and it looks like I have finally got the answer (although I […]

Read more

MongoDB: Utilization of an Index on Subdocuments

MongoDB Index on Subdocument

MongoDB has a lot of possibilities for creating indexes. We have seen in previous articles some of the available index types and discussed explain() usage:
Using Partial and Sparse Indexes in MongoDB
MongoDB Index Types and MongoDB explain() (part 1)
MongoDB: Investigate Queries with explain() and Index Usage (part 2)
You can have a look at those if […]

Read more