Remove Compression
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.

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

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

Compress objects, not cache lines: an object-based compressed memory hierarchy

The Morning Paper

Compress objects, not cache lines: an object-based compressed memory hierarchy Tsai & Sanchez, ASPLOS’19. Last time out we saw how Google have been able to save millions of dollars though memory compression enabled via zswap. ” The big idea. ” The big idea. There are two big “Aha!”

Cache 61
article thumbnail

Backup compression in TDE enabled databases in SQL Server Always On Availability Groups

SQL Shack

In this article, we will explore options for a compressed backup of a TDE database. In the previous article, Transparent Data Encryption for SQL Server Always On Availability Groups, we discussed enabling TDE for the existing database in AG. Introduction TDE protects the physical database, log, backup files using the IO encryptions.

Database 104
article thumbnail

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

SQL Performance

Sounds like a great job for compression, right? ON PS_OID ( OID ) ; Then, in order to put archive compression on all but the last partition, I ran the following: ALTER TABLE dbo. Finally, I applied page compression, in place, to the source table. mdf' ) TO FILEGROUP FG_CCI ; --. ALTER TABLE dbo. tblCCI_Partitioned.