Remove Compression
article thumbnail

The Three Cs: Concatenate, Compress, Cache

CSS Wizardry

Compressing them over the network: Which compression algorithm, if any, will we use? This gave rise to heavy bundling and concatenation—why download three CSS files (half of our budget) if we could compress them into one? Compress The above tests were run with Brotli compression 2. in this article. It gets worse.

Cache 291
article thumbnail

Compression Methods in MongoDB: Snappy vs. Zstd

Percona

Compression in any database is necessary as it has many advantages, like storage reduction, data transmission time, etc. As the amount of data grows, the need for efficient data compression becomes increasingly important to save storage space, reduce I/O overhead, and improve query performance. provides higher compression rates.

Storage 111
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

Managing MySQL Server Logs: Rotate, Compress, Retain & Delete

Scalegrid

A: Let’s say it can grow up to 300 MB after which it needs to be rotated and compressed. Assuming a 90% compression ratio – we will have 30 compressed log files of size 30 MB each and a live log file of about 300 MB. Managing MySQL Server Logs: Rotate, Compress, Retain & Delete Click To Tweet.

Servers 247
article thumbnail

The Deprecation of qpress/QuickLZ Compression Algorithm

Percona

To reduce the backup size, save storage space, and speed up the backup and restore process, you can compress a backup with Percona XtraBackup. To compress and decompress local or streaming backups, Percona XtraBackup uses xbstream – a binary that supports simultaneously compressing and streaming dynamically generated files.

article thumbnail

WAL Compression in PostgreSQL and Recent Improvements in Version 15

Percona

Attempts to compress PostgreSQL WAL at different levels have always been around since the beginning. Some of the built-in features ( wal_compression ) have been there since 2016, and almost all backup tools do the WAL compression before taking it to the backup repository. What is Full Page Writes?

Database 118
article thumbnail

Fun with (columnstore) compression on a very large table – part 3

SQL Performance

In part 1 of this series, I tried out a few ways to compress a 1TB table. There I outlined a few of the things I thought might be performance issues, and laid out how I would better partition the destination table for optimal columnstore compression. Timings and compression rates: Some options are better than others.

Speed 113
article thumbnail

Gzip vs Brotli – Best Browser Compression

MachMetrics

One such measure is HTTP compression. You might have noticed 2 different compression options in your research, and wondered which was better. What is HTTP Compression? Simply put, compression allows the web server to send smaller files to your web site viewers. Gzip Compression. Brotli Compression.

Speed 67