Percona

APRIL 7, 2023

MySQL comes pre-configured to be conservative instead of making the most of the resources available in the server. But since retrieving data from disk is slow, databases tend to work with a caching mechanism to keep as much hot data, the bits and pieces that are most often accessed, in memory. Why is that?

Tuning 134

Tuning Cache Servers Benchmarking 134

Percona

JUNE 22, 2023

A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance. This includes metrics such as query execution time, the number of queries executed per second, and the utilization of query cache and adaptive hash index.

Performance 102

Performance Monitoring Traffic Database 102

HammerDB

JUNE 27, 2022

These factors meant that often when looking for database performance information, the results for a particular combination of software and hardware were not available. Given the increasing importance of open source and the widespread use of HammerDB, the TPC adopted HammerDB in 2019 and now hosts the project on GitHub.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

MARCH 28, 2023

The same data, in the form of pages inside the Wiredtiger cache, are also marked dirty. At every checkpoint interval (Default 60 seconds), MongoDB flushes the modified pages that are marked as dirty in the cache to their respective data files (both collection-*.wt Download Percona Distribution for MongoDB Today! wt and index-*.wt).

Hardware 85

Hardware C++ Storage Cache 85

Smashing Magazine

AUGUST 3, 2023

Download Time of HTML This is the time it takes to download the page’s HTML file. You need to beware of large HTML files or slow network connections because they can lead to longer download times. Fetching And Decoding Images This is the time taken to fetch, download, and decode images, particularly the largest contentful image.

Performance 74

Performance Cache Traffic Metrics 74

Smashing Magazine

JUNE 8, 2021

Image optimization , loading behavior and rendering in the browser require understanding of image formats and image compression techniques, image decoding and browser rendering, image CDNs and adaptive media loading, not to mention effective caching and preloading. Jump to the details ↓ Download a free PDF sample (12MB).

Media 106

Media Cache Google Best Practices 106

Smashing Magazine

APRIL 28, 2021

Image optimization , loading behavior and rendering in the browser require understanding of image formats and image compression techniques, image decoding and browser rendering, image CDNs and adaptive media loading, not to mention effective caching and preloading. Jump to the details ↓ Download a free PDF sample (12MB).

Media 93

Media Cache Google Best Practices 93

Smashing Magazine

NOVEMBER 22, 2021

There are various performance budgeting products and open-source tools available, but we decided to create our own custom budgeting service called Perfer. In addition, this significantly reduced the amount of JavaScript code that needs to be downloaded by the browser. Large preview ). Large preview ).

Website 126

Website Performance Google Media 126

Percona

APRIL 3, 2023

Below are some of the upgrade options available to upgrade to PG11 or above. Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community in a single distribution, designed and tested to work together. Download Percona Distribution for PostgreSQL Today!

C++ 99

C++ Cache Database Storage 99

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. Download The Checklist (PDF, Apple Pages, MS Word). Quick Wins.

Performance 145

Performance Cache Media Metrics 145

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

Smashing Magazine

JANUARY 6, 2020

Download The Checklist (PDF, Apple Pages, MS Word). You can also just download the checklist PDF (166 KB) or download editable Apple Pages file (275 KB) or the.docx file (151 KB). dashboard (open source), SpeedCurve and Calibre are just a few of them, and you can find more tools on perf.rocks. Assets Optimizations.

Performance 145

Performance Cache Network Metrics 145

Percona

JUNE 15, 2023

The reason might be application requirements, compatibility issues, or MySQL bug fixes, or we want the same MySQL version to be installed on all database instances in the cluster, regardless of what actually is the latest version available. Download specific Percona Server for MySQL 8 tarball packages and install them manually.

Servers 82

Servers C++ Database Systems 82

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. PWAs have been around for over five years, yet native applications outnumber them both in the quantity ratio and how many times users download them. But this “look” is now available in browsers.

Code 74

Code Cache Retail Mobile 74

Smashing Magazine

JUNE 2, 2021

The project consisted of upgrading the shop software to our own open-source system and redoing the shop’s front end from scratch. And while you can usually cache the full page of an article, the same is not true of many shop pages and elements. This keeps us from having to download 10 or more additional font files.

Performance 116

Performance Cache Website Mobile 116

Percona

APRIL 17, 2023

Note that the intent of tuning the settings is not exclusively about improving performance but also enhancing the high availability and resilience of the MongoDB database. There is an issue with this, which causes the OS to swap even with memory available. Spoiler alert: This post focuses on MongoDB 3.6.X 25.84 - Total 21.04

Best Practices 52

Best Practices Design Tuning Database 52

Smashing Magazine

JANUARY 7, 2019

Download The Checklist (PDF, Apple Pages, MS Word). You can also just download the checklist PDF (166 KB) or download editable Apple Pages file (275 KB) or the.docx file (151 KB). dashboard (open source), SpeedCurve and Calibre are just a few of them, and you can find more tools on perf.rocks. Assets Optimizations.

Performance 104

Performance Cache Network Metrics 104

Alex Russell

APRIL 29, 2021

This post mines publicly available data on the pace of compatibility fixes and feature additions to assess the claim. Apple Corporate is at fault, not Open Source engineers or the line managers who support them. Count of APIs available from JavaScript by Web Confluence. Still not available for iOS or iPadOS.

Media 145

Media Games Education Engineering 145

Enprowess

MAY 24, 2022

Both are open-sourced frameworks using JavaScript. ReactJS is an open-source JavaScript library. When a web crawler visits a server that has already rendered the content and pictures, indexing and caching of the content becomes quicker. React Native is an open-source JavaScript framework.

Mobile 52

Mobile Open Source Virtualization Speed 52

Smashing Magazine

JUNE 1, 2022

The most popular, by far, is the Google Lighthouse report (available in Chrome Developer Tools) and Google’s Page Speed Insights. You can adjust what browser is used, the kind of network connection to employ, the locations to test from, whether or not the browser’s cache is empty or full, how frequently to take the measurements, and more.

Website 131

Website Design Network Best Practices 131

Percona

FEBRUARY 1, 2023

This is the only strategy available for non-TOAST-able data types, such as integers or booleans. To address this issue, try creating indexes on the TOAST table or consider using a caching layer to reduce the number of times data needs to be fetched from the TOAST table. Download Percona Distribution for PostgreSQL Today!

Storage 87

Storage Scalability Strategy Performance 87

Smashing Magazine

NOVEMBER 17, 2022

Web performance refers to the speed at which a website loads, how fast it’s downloaded, and how an app is displayed on the user’s browser. Clearly, we want to give freedom to our content creators, but we can leave to chance neither the resolution nor the speed of delivery and download of the images that will be displayed on our website.

Media 106

Media Cache Website Mobile 106

Smashing Magazine

AUGUST 20, 2021

Now there’s a massive range of Jamstack CMSs available, which bring all the advantages of static sites while allowing non-technical folk to update content. It was a battle of not only proprietary vs open source but also static vs dynamic. ’ It’s the same problem that led the community to adopt the term ‘Jamstack.’

Ecommerce 139

Ecommerce Website Government Internet 139

MachMetrics

FEBRUARY 10, 2020

Unfortunately, there is typically much less thought put into the performance cost of using the amazing third-party font you downloaded. This means they don’t need to be downloaded to the visitor’s computer when they visit your site. Source: caniuse.com. They can also be easily cached to improve load times.

Speed 65

Speed Performance Google Open Source 65

Percona

MAY 2, 2023

Also, we will take a look at our open-source backup utility custom-built to help avoid costs and proprietary software – Percona Backup for MongoDB or PBM. Hence, the node would still be available for other operations. Caveat: Good as long as you have the additional resources available for running the parallel threads.

Best Practices 52

Best Practices Database Storage Servers 52

Smashing Magazine

SEPTEMBER 6, 2021

This approach was touted to be better for fine-grained caching because each subresource could be cached individually and the full bundle didn’t need to be redownloaded if one of them changed. To be able to download multiple files on a single connection, you need to somehow multiplex them. Prioritization.

Network 105

Network Servers Cache Traffic 105

Smashing Magazine

MARCH 19, 2021

Gael Metais suggested to more aggressively subset web fonts and look into caching issues with our AVIF files. If a browser doesn’t support AVIF, it gets a JPEG file (properly cached), The content negotiation happens via <picture> + srcset in the browser. With over 56k downloads (just over a thousand per week, and growing!),

Mobile 140

Mobile Design Cache Code 140

Smashing Magazine

AUGUST 22, 2021

This in turn affects how fast a page’s resources can be downloaded. Additionally, even if we knew the available physical bandwidth, that wouldn’t mean we could use all of it ourselves. Several users are typically active on a network concurrently, each of whom need a fair share of the available bandwidth. Did You Know?

Performance 106

Performance Network Latency Servers 106

Smashing Magazine

APRIL 29, 2021

Lighthouse is an open-source, automated tool for improving the quality of web pages. width="400" height="400"> When width and height are specified on an image, the browser knows how much space to reserve for the image until it is downloaded. By reducing main-thread CPU usage, FID can also be reduced. Lighthouse.

Media 145

Media Network Metrics Mobile 145