Remove 2017 Remove Hardware Remove Storage Remove Tuning
article thumbnail

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality

Scalegrid

Compare ease of use across compatibility, extensions, tuning, operating systems, languages and support providers. Recognized as the fastest growing database by popularity, PostgreSQL was named the DBMS of the year in both 2018 and 2017 by DB-Engines, and continues to grow in popularity in 2019. So Which Is Best?

article thumbnail

Solaris to Linux Migration 2017

Brendan Gregg

Linux has been adding tracing technologies over the years: kprobes (kernel dynamic tracing), uprobes (user-level dynamic tracing), tracepoints (static tracing), and perf_events (profiling and hardware counters). Appliance manufacturers hire kernel engineers to develop custom features, including storage appliances.

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

The Ultimate Guide to MySQL Partitions

Percona

This blog was originally published in July 2017 and was updated in August 2023. Otherwise, the storage engine does a scatter-gather and queries ALL partitions in a UNION that is not concurrent. This method distributes data evenly across partitions to achieve balanced storage and optimal query performance.

article thumbnail

Finding Distinct Values Quickly

SQL Performance

Back in 2014, I wrote an article called Performance Tuning the Whole Query Plan. Finding a small number of distinct values might seem like quite a specific requirement, but I have come across it fairly frequently over the years, usually as part of tuning a larger query. Test Environment. Final Thoughts.

Servers 86
article thumbnail

Using Parallel Query with Amazon Aurora for MySQL

Percona

On multi-core machines – which is the majority of the hardware nowadays – and in the cloud, we have multiple cores available for use. now has a version which will support parallelism for SELECT queries (utilizing the read capacity of storage nodes underneath the Aurora cluster). With faster disks (i.e. AWS Aurora (based on MySQL 5.6)

Cache 46