“Transparent Hugepages” is a Linux kernel feature intended to improve performance by making more efficient use of your processor’s memory-mapping hardware. It is enabled (“enabled=always”) by default in most Linux… Read more »
ClickHouse supports different kinds of compressions, namely two LZ4 and ZSTD. But in short, LZ4 is fast but provides smaller compression ratio comparing to ZSTD. While ZSTD is slower than… Read more »
In this article we are going to see use of Oracle Block Change Tracking concept in 19c database. 19c-Block Change Tracking(BCT) Oracle 10g introduced the Block change tracking (BCT) feature… Read more »
The typical MySQL DBA might be familiar working and managing an OLTP (Online Transaction Processing) database as part of their daily routine. You may be familiar with how it works… Read more »
Index usage tracking in Oracle 12.2 replaces the old index monitoring functionality of previous versions. The database maintains all indexes defined against a table regardless of their usage. Index maintenance… Read more »
Prior to Oracle 12c, there were two ways to do ‘top-n’ queries: use rownum after sorting rows with “order by” use row_number() over (order by) Top-n queries are usually required… Read more »
Galera Cluster is a synchronous multi-master replication plug-in for InnoDB. It is very different from the regular MySQL Replication, and addresses a number of issues including write conflicts when writing… Read more »
This single script provides the overall picture of the database in terms of Waits events, Active/Inactive killed sessions, Top Processes (physical i/o, logical i/o, memory and CPU processes),Top CPU usage by… Read more »