article thumbnail

MySQL Data Caching Efficiency

Percona

A shared characteristic in most (if not all) databases, be them traditional relational databases like Oracle, MySQL, and PostgreSQL or some kind of NoSQL-style database like MongoDB, is the use of a caching mechanism to keep (a copy of) part of the data in memory. How do you know if your MySQL database caching is operating efficiently?

Cache 88
article thumbnail

The Three Cs: Concatenate, Compress, Cache

CSS Wizardry

Concatenating our files on the server: Are we going to send many smaller files, or are we going to send one monolithic file? Caching them at the other end: How long should we cache files on a user’s device? Caching them at the other end: How long should we cache files on a user’s device?

Cache 291
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

Five Data-Loading Patterns To Improve Frontend Performance

Smashing Magazine

The resource loading waterfall is a cascade of files downloaded from the network server to the client to load your website from start to finish. It essentially describes the lifetime of each file you download to load your page from the network. It is important to note how much data the client needs to download.

Cache 125
article thumbnail

How to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu

Percona

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. 2) … 1.3

Servers 81
article thumbnail

Benchmark (YCSB) numbers for Redis, MongoDB, Couchbase2, Yugabyte and BangDB

High Scalability

Redis Server: 5.07, x86/64. MongoDB server: 4.4.2, BangDB server: 2.0.0, Application example: user profile cache, where profiles are constructed elsewhere (e.g., However, user can run the bench for as many numbers as they practically find suitable. About YCSB. Following configurations were used for the evaluation purpose.

article thumbnail

The Various Methods to Backup and Restore ProxySQL

Percona

The daemon accepts incoming traffic from MySQL clients and forwards it to backend MySQL servers. These include runtime parameters, server grouping, and traffic-related settings. Below are backup methods to perform a backup restore of the ProxySQL server. The proxy is designed to run continuously without needing to be restarted.

Traffic 106
article thumbnail

Application vulnerabilities: Important lessons from the OWASP top 10 about application security risks

Dynatrace

This method involves providing the lowest level of access by default, deleting inactive accounts, and auditing server activity. For these, it’s important to turn off auto-completing forms, encrypt data both in transit and at rest with up-to-date encryption techniques, and disable caching on data collection forms.