article thumbnail

Quick Data Archival in MySQL Using Partitions

Percona

Space constraint has been an endless and painstaking process for many of us, especially in systems that have a high number of transactions and data growth exceeding hundreds of GBs in a matter of days. MySQL won’t shrink tablespace and storage won’t be released to the file system. What is partitioning? ibd -rw-r --.

Traffic 58
article thumbnail

The Back-to-Basics Readings of 2012 - All Things Distributed

All Things Distributed

In Proceedings of the Eighteenth Symposium on Operating Systems Principles (SOSP-18), Banff, Canada, October, 2001. Aug 24 - The Five-Minute Rule Ten Years Later, and Other Computer Storage Rules of Thumb , Jim Gray and Goetz Graefe, ACM SIGMOD Record 26 (4): 63â?? Traiger, Modeling in Data Base Management Systems, G.M. Nijssen ed.,

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

What Adrian Did Next?—?Part 2?—?Sun Microsystems

Adrian Cockcroft

I made major contributions to two Sun Blueprints books on Resource Management (1999) with Richard McDougall, Evert Hoogendoorn, Enrique Vargas, and Jim Bialaski, and Capacity Planning for Internet Services (2001) with Bill Walker. I’d helped eBay recover from capacity related outages in 1999 and had setup their capacity planning processes.

Tuning 52
article thumbnail

MICRO 2019 Trip Report

ACM Sigarch

The best paper runner-up was “ Dynamic Multi-Resolution Data Storage ”. . Two Test of Time awards went to: “Speculative Lock Elision: Enabling Highly Concurrent Multithreaded Execution” published at MICRO 2001 by Ravi Rajwar and James R.

article thumbnail

Solaris to Linux Migration 2017

Brendan Gregg

There's also a ZFS send/recv code path that should try to use the TASK_INTERRUPTIBLE flag (as suggested by a coworker), to avoid a kernel hang (can't kill -9 the process). On Linux, containers are a combination of namespaces (restricting what a process sees) and cgroups (similar to Solaris resource controls).