DBplatz - Database News. Read our handpicked database-related articles. Where all databases are welcome. SQL and NoSQL. Windows, Linux and MacOS. #useThemAll


InnoDB is the default storage engine for MariaDB Enterprise Server and MariaDB Community Server. While originally based on the MySQL implementation of InnoDB, MariaDB has been diverging from the original for years in order to give MariaDB users a better experience.

  • mariadb.com
  • Marko Mäkelä

Page faults are a prevalent error that mostly occurs in a large application involving large data. It takes place when MongoDB database reads data from physical memory rather than from virtual memory.

  • severalnines.com
  • locks.acquireWaitCount

This month, June 2020, IBM introduced a new function level, FL507, for Db2 12 for z/OS. This is the first new function level this year, and the first since October 2019. The Function Level process was designed to release Db2 functionality using Continuous Delivery (CD) in short, quick bursts.

  • db2portal.blogspot.com
  • Craig S. Mullins

Custom types—called user-defined types in the PostgreSQL docs—are a powerful Postgres capability that, just like Postgres extensions, were envisioned from Day One in the original design of Postgres.

  • citusdata.com
  • Nils Dijk

Today I’m going to talk about my favorite trope, “database security”. When done right, a good security policy not only protects your data but improves performance, system stability, and enhances the development life-cycle.

  • percona.com
  • Robert Bernier

Earlier this month Docker announced our partnership with Microsoft to shorten the developer commute between the desktop and running containers in the cloud.

  • docker.com
  • Brian Christner

In my recent post Evaluating MongoDB Under Python TPCC 1000W Workload with MongoDB benchmarks, I showed an average throughput for a prolonged period of time (900sec or 1800sec), and the average throughput tended to smooth and hide problems.

  • percona.com
  • Vadim Tkachenko

Cloud, Cloud, Cloud. Everyone is talking about the Cloud but a lot of people are still in the fog with Cloud technologies. Let’s talk about basic features of the Oracle Cloud, called OCI for Oracle Cloud Infrastructure. OCI is physically a lot of servers in datacenters all around the world.

  • blog.dbi-services.com
  • Jérôme Dubar

I used to make fun of YAML because I was scared of it. I still make fun of YAML, but I’m not scared of it anymore now that Rob Sewell showed me how to avoid having to write it myself. In this…

  • littlekendra.com

I’ve heard many times incorrectly over the years that CTEs somehow materialize data. But a new one to me was that CTEs execute procedurally, and you could use that to influence plan shapes by always doing certain things first.

  • erikdarlingdata.com
  • Erik Darling

The PostgreSQL Global Development Group announces that the second beta release of PostgreSQL 13 is now available for download. This release contains previews of all features that will be available in the final release of PostgreSQL 13, though some details of the release could change before then.

  • postgresql.org

OmniDB is an open-source, graphical database management tool developed by 2ndQuadrant, a world-leader in PostgreSQL technologies and services. OmniDB is a browser-based, universal client tool that can manage major database engines like PostgreSQL, MariaDB, MySQL, and Oracle.

  • 2ndquadrant.com
  • Sadequl Hussain

We are delighted to announce the introduction of a brand new training course to assist your Enterprise with Onboarding to Couchbase Support. This free, online offering is designed and delivered by our most experienced Technical Support engineers.

  • blog.couchbase.com
  • David Haikney

As the name indicates, an undo log record contains information about how to undo the recent changes by a transaction. When a transaction writes data, it always makes writes on the tablespace files. InnoDB Undo log stores copy of data that is being modified by any current transaction.

  • mydbops.wordpress.com
  • shahbaz Gavasekar

Metricbeat is an extremely easy-to-use, efficient and reliable metric shipper for monitoring your system and the processes...

  • logz.io

Whenever you are using T-SQL to develop queries, you will encounter situations where you have to deal with NULL values. No matter how hard you try, you cannot eliminate NULLs.

  • mssqltips.com
  • Ray Barley

To continue the series, this PowerShell monitoring script will collect instance level data for all of SQL Servers that have been registered for this monitoring solution. This module will gather information about the SQL Server instance, such as the version, edition, memory settings and more.

  • mssqltips.com
  • Alejandro Cobar

Aspen Mesh sponsored this post. One of the bright points to emerge in Kubernetes management is how the core capabilities of the Istio service mesh can help make engineering teams more efficient in running multicluster applications.

  • thenewstack.io
  • B. Cameron Gain

We released a new Modbus input plugin in Telegraf 1.14 and in this blog I’d like to tell you more about that plugin and how you can use it.

  • influxdata.com
  • Samantha Wang

By Franck Pachot . I had a few questions about the Oracle ACE program recently and I thought about putting some answers there.

  • blog.dbi-services.com
  • Franck Pachot

24th Jun 2020

The new MySQL Shell or mysqlsh has provisions for loading user plugins in Python or JavaScript that are loaded when the shell starts up. I am just taking my initial steps into this area and wanted to share with you how easy it is to create a plug-in to produce a report.

  • elephantdolphin.blogspot.com
  • Dave Stokes

In the second article of this series, Edward Pollack demonstrates some ways to design and populate a columnstore index to get even better performance.

  • red-gate.com
  • tables

An important part of performing a migration from Oracle to PostgreSQL is selecting the right tool for helping with the conversion between systems. When people ask me how they can get the migration process started, I like to recommend a powerful open source utility called "ora2pg".

  • info.crunchydata.com
  • Yorvi Arias

Usually, database people are familiar with table fragmentation with DELETE statements. Whenever doing a huge delete, in most cases, they are always rebuilding the table to reclaim the disk space. But, are you thinking only DELETEs can cause table fragmentation? (Answer: NO).

  • percona.com
  • Sri Sakthivel

You should never take any decision on what you read on the internet without verifying. It is totally valid to consider a move to Open Source databases, but doing it without good understanding is a risk for your migration project success.

  • blog.dbi-services.com
  • Franck Pachot

One of Elastic’s guiding principles is to be where our users are. We publish our products for several platforms in a variety of formats, so that you can get up-and-running as quickly as possible.

  • elastic.co
  • Rory Hunter

Turning raw data into improved business performance is a multilayered problem, but it doesn’t have to be complicated. To make things simpler, let’s start at the end and work backwards. Ultimately, the goal is to make better decisions during the execution of a business process.

  • ibmbigdatahub.com
  • Andrew Buckler

Have you always wanted to paint pictures with your data? Do you strive to accelerate your data science cycles and rapidly iterate by running your analytics on GPUs? Or do you just like Spark and want to work with your favorite MLlib algorithms? Lucky for you, we have each of these bases covered in t

  • splunk.com
  • Philipp Drieger

MariaDB ColumnStore 1.5 brings a high-performance, open source, distributed, SQL-compatible analytics solution to the market. Included as a pluggable storage engine with MariaDB Community Server 10.5, MariaDB ColumnStore 1.

  • mariadb.com
  • Todd Stoffel

We didn’t implement SELECT FOR UPDATE to ensure consistency. Unlike Amazon Aurora, CockroachDB already guarantees serializable isolation, the highest isolation level provided by the ANSI SQL standard.

  • cockroachlabs.com
  • John Kendall