Percona

MAY 1, 2023

PostgreSQL performance optimization aims to improve the efficiency of a PostgreSQL database system by adjusting configurations and implementing best practices to identify and resolve bottlenecks, improve query speed, and maximize database throughput and responsiveness. What is PostgreSQL performance tuning?

Tuning 52

Tuning Efficiency Database Performance 52

The Morning Paper

NOVEMBER 5, 2019

File systems unfit as distributed storage backends: lessons from 10 years of Ceph evolution Aghayev et al., In this case, the assumption that a distributed storage backend should clearly be layered on top of a local file system. What is a distributed storage backend? SOSP’19. This is not surprising in hindsight.

Storage 64

Storage Systems Hardware Efficiency 64

Percona

JULY 25, 2023

After the “data dictionary” (DD) engine and DD cache are initialized on a server, the Storage Engines can ask for a table definition. Initializing a DD engine and the cache adds complexity and other server dependencies. Essentially LRU cache is disabled by loading the tables as non-evictable. ibd > t1.sdi

Cache 84

Cache Benchmarking Servers Design 84

HammerDB

JUNE 27, 2022

As the TPC makes its specifications available for free, the need was seen for an open source benchmarking application that could leverage the standards written by the TPC yet implemented quickly, easily and at low cost by anyone. HammerDB is open source software licensed under the. How to build HammerDB from source.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

JUNE 4, 2023

MariaDB is a popular SQL open source relational database management system that originated as a fork of MySQL after MySQL was acquired by Sun Microsystems in 2008 and later Oracle in 2010. It continues to be developed and maintained by the open source community and remains free to use under the GNU General Public License.

Open Source 52

Open Source Servers Storage Scalability 52

Percona

JULY 5, 2023

The principle of locality While the principle of locality is usually related to processors and cache access patterns, it also applies to data access in general. If your data is organized following the principle of locality, data access will be more efficient. This type of fragmentation can improve performance and efficiency.

Open Source 123

Open Source Database Efficiency Testing 123

IO River

NOVEMBER 2, 2023

It’s not just limited to cloud resources like AWS and Azure; Terraform is versatile, extending its capabilities to key performance areas like Content Delivery Network (CDN) management, ensuring efficient content delivery and optimal user experience.‍Started ‍Why Manage Infrastructure by Code? But how does this apply to CDNs?

Open Source 52

Open Source DevOps AWS Azure 52

Brendan Gregg

FEBRUARY 28, 2023

Make sure your system can handle next-generation DRAM,” [link] Nov 2011 - [Hruska 12] Joel Hruska, “The future of CPU scaling: Exploring options on the cutting edge,” [link] Feb 2012 - [Gregg 13] Brendan Gregg, “Blazing Performance with Flame Graphs,” [link] 2013 - [Shimpi 13] Anand Lal Shimpi, “Seagate to Ship 5TB HDD in 2014 using Shingled Magnetic (..)

Performance 110

Performance Latency Cache Virtualization 110

Percona

JUNE 22, 2023

High availability architecture for open source databases No matter where a database infrastructure is located (on-premises, public or private cloud environment, or hybrid environment) or what technology is used — be it MySQL, PostgreSQL, or MongoDB — it’s vital to eliminate single points of failure.

Availability 105

Availability Database Open Source Hardware 105

IO River

NOVEMBER 2, 2023

significant factor that contributed to Terraform's rise to prominence is its open-source nature. Being open-source, Terraform invited a vast community of developers and companies to rally around it. We've reached an age where efficient and swift infrastructure deployment is more crucial than ever.

Open Source 40

Open Source DevOps AWS Azure 40

The Morning Paper

OCTOBER 26, 2020

On the surface this is a paper about fast data ingestion from high-volume streams, with indexing to support efficient querying. The emergence of edge computing has raised new challenges for big data systems… In recent years a number of distributed streaming systems have been built via either open source or industry effort (e.g.

Cloud 104

Cloud Big Data Latency Architecture 104

All Things Distributed

OCTOBER 12, 2016

While caching continues to be a dominant use of ElastiCache for Redis, we see customers increasingly use it as an in-memory NoSQL database. All these capabilities are available to customers at no additional charge, and maintain open-source Redis compatibility. with ElastiCache for Redis Multi-AZ.

Scalability 130

Scalability Analytics Cache AWS 130

Smashing Magazine

OCTOBER 26, 2021

Nx is an open-source build framework that helps you architect, test, and build at any scale — integrating seamlessly with modern technologies and libraries, while providing a robust command-line interface (CLI), caching, and dependency management. Nx also stores the cached project graph. Cloud storage.

Cache 110

Cache Servers Code Storage 110

Brendan Gregg

FEBRUARY 28, 2023

Make sure your system can handle next-generation DRAM,” [link] , Nov 2011 [Hruska 12] Joel Hruska, “The future of CPU scaling: Exploring options on the cutting edge,” [link] , Feb 2012 [Gregg 13] Brendan Gregg, “Blazing Performance with Flame Graphs,” [link] , 2013 [Shimpi 13] Anand Lal Shimpi, “Seagate to Ship 5TB HDD in 2014 using Shingled Magnetic (..)

Performance 52

Performance Latency Cache Virtualization 52

Percona

APRIL 17, 2023

Make sure the drives are mounted with noatime and also if the drives are behind a RAID controller with appropriate battery-backed cache. For example: Read/Write tickets WiredTiger uses tickets to control the number of read / write operations simultaneously processed by the storage engine. By default, it uses 50% of the memory + 1 GB.

Best Practices 52

Best Practices Design Tuning Database 52

Abhishek Tiwari

NOVEMBER 3, 2018

Cost is one of the key reasons why most government organisations, mid to large sized business, and publisher prefer open source CMS options such as WordPress and Drupal. In addition, open source CMS solutions also struggle with blotted plugin ecosystem. Eventually, we decided to move them to Jekyll.

Systems 63

Systems Cache Website Network 63

Percona

MAY 15, 2023

This operation is quite expensive but our database can run it in a few milliseconds or less, thanks to several optimizations that allow the node to execute most of them in memory with no or little access to mass storage. In the MySQL open source ecosystem, we have only two consolidated ways to perform sharding — Vitess and ProxySQL.

Traffic 121

Traffic Scalability Database Servers 121

Smashing Magazine

NOVEMBER 2, 2021

When dealing with e-commerce at some point, you probably have heard, and perhaps used Magento, an open-source e-commerce platform. Cost-Efficient And Effort-Saving Development. On the contrary, a native application of an e-commerce store can come at 30, 50, or even 100 MB and up, consuming internal device storage.

Code 74

Code Cache Retail Mobile 74

Smashing Magazine

JANUARY 11, 2021

Build Optimizations JavaScript modules, module/nomodule pattern, tree-shaking, code-splitting, scope-hoisting, Webpack, differential serving, web worker, WebAssembly, JavaScript bundles, React, SPA, partial hydration, import on interaction, 3rd-parties, cache. This improves page load time and caching during navigations.

Performance 145

Performance Cache Media Metrics 145

Alex Russell

APRIL 29, 2021

Apple Corporate is at fault, not Open Source engineers or the line managers who support them. Chrome has missed several APIs for 3+ years: Storage Access API. Efficiently enables new styles of drawing content on the web , removing many hard tradeoffs between visual richness , accessibility, and performance.

Media 145

Media Games Education Engineering 145

Smashing Magazine

JANUARY 6, 2020

dashboard (open source), SpeedCurve and Calibre are just a few of them, and you can find more tools on perf.rocks. In exchange, your team gains maintainability and developer efficiency, of course. Large preview ). There are many tools allowing you to achieve that: SiteSpeed.io But this consideration needs to be deliberate.

Performance 145

Performance Cache Network Metrics 145

Enprowess

JANUARY 12, 2022

So it is convenient for all to use irrespective of internet speed and it works offline using cached data. Other benefits: It has other benefits like a Quicker launch to the market, Easier distribution, saving device power and storage, seamless maintenance, and updating. Image Source. Famous PWA Use Examples.

Blockchain 59

Blockchain IoT Development Serverless 59

Smashing Magazine

JANUARY 7, 2019

dashboard (open source), SpeedCurve and Calibre are just a few of them, and you can find more tools on perf.rocks. In exchange, your team gains maintainability and developer efficiency, of course. In 2015, Google introduced Brotli , a new open-source lossless data format, which is now supported in all modern browsers.

Performance 104

Performance Cache Network Metrics 104

ACM Sigarch

NOVEMBER 4, 2019

Krste Asanovic from UC Berkeley kicked off the main program sharing his experience on “ Rejuvenating Computer Architecture Research with Open-Source Hardware ”. Using genomics and deep learning as two motivating examples, he highlighted the importance of algorithm-architecture co-design to improve end-to-end efficiency.

Hardware 18

Hardware Architecture Programming Innovation 18